{
  "computedColumns": [],
  "enableAutoCastInJoinConditions": false,
  "engineParams": {
    "hive": {
      "addDkuUdf": false,
      "executionEngine": "HIVESERVER2",
      "hiveconf": [],
      "inheritConf": "default",
      "skipPrerunValidate": false
    },
    "impala": {
      "forceStreamMode": true
    },
    "lowerCaseSchemaIfEngineRequiresIt": true,
    "sparkSQL": {
      "executionEngine": "SPARK_SUBMIT",
      "overwriteOutputSchema": false,
      "pipelineAllowMerge": true,
      "pipelineAllowStart": true,
      "readParams": {
        "autoModeRepartitionInto": 10,
        "map": {
          "cardholder_info_placeholder": {
            "cache": false,
            "repartition": 10
          },
          "merchant_info_placeholder": {
            "cache": false,
            "repartition": 10
          },
          "transactions_stacked": {
            "cache": false,
            "repartition": 10
          }
        },
        "mode": "AUTO"
      },
      "skipPrerunValidate": false,
      "sparkConfig": {
        "conf": [],
        "inheritConf": "default"
      },
      "useGlobalMetastore": false
    },
    "sqlPipelineParams": {
      "pipelineAllowMerge": true,
      "pipelineAllowStart": true
    }
  },
  "engineType": "DSS",
  "joins": [
    {
      "conditionsMode": "AND",
      "on": [
        {
          "column1": {
            "name": "card_id",
            "table": 0
          },
          "column2": {
            "name": "internal_card_mapping",
            "table": 1
          },
          "maxDistance": 1,
          "type": "EQ"
        }
      ],
      "outerJoinOnTheLeft": true,
      "rightLimit": {
        "decisionColumn": {}
      },
      "table1": 0,
      "table2": 1,
      "type": "LEFT"
    },
    {
      "conditionsMode": "AND",
      "on": [
        {
          "caseInsensitive": false,
          "column1": {
            "name": "merchant_id",
            "table": 0
          },
          "column2": {
            "name": "merchant_id",
            "table": 2
          },
          "dateDiffUnit": "DAY",
          "maxDistance": 0,
          "maxMatches": 1,
          "normalizeText": false,
          "strict": false,
          "type": "EQ"
        },
        {
          "caseInsensitive": false,
          "column1": {
            "name": "merchant_category_id",
            "table": 0
          },
          "column2": {
            "name": "merchant_category_id",
            "table": 2
          },
          "dateDiffUnit": "DAY",
          "maxDistance": 0,
          "maxMatches": 1,
          "normalizeText": false,
          "strict": false,
          "type": "EQ"
        }
      ],
      "outerJoinOnTheLeft": true,
      "rightLimit": {},
      "table1": 0,
      "table2": 2,
      "type": "LEFT"
    }
  ],
  "postFilter": {
    "$status": {
      "fullyTranslated": false,
      "message": "Filter expression is invalid",
      "ok": false,
      "schema": {
        "columns": [
          {
            "name": "transaction_id",
            "type": "string"
          },
          {
            "name": "authorized_flag",
            "type": "string"
          },
          {
            "name": "purchase_date",
            "type": "string"
          },
          {
            "name": "card_id",
            "type": "string"
          },
          {
            "name": "merchant_id",
            "type": "string"
          },
          {
            "name": "merchant_category_id",
            "type": "bigint"
          },
          {
            "name": "item_category",
            "type": "string"
          },
          {
            "name": "purchase_amount",
            "type": "double"
          },
          {
            "name": "signature_provided",
            "type": "bigint"
          },
          {
            "name": "card_first_active_month",
            "type": "string"
          },
          {
            "name": "card_reward_program",
            "type": "string"
          },
          {
            "name": "card_latitude",
            "type": "double"
          },
          {
            "name": "card_longitude",
            "type": "double"
          },
          {
            "name": "card_fico_score",
            "type": "bigint"
          },
          {
            "name": "card_age",
            "type": "bigint"
          },
          {
            "name": "merchant_subsector_description",
            "type": "string"
          },
          {
            "name": "merchant_latitude",
            "type": "double"
          },
          {
            "name": "merchant_longitude",
            "type": "double"
          }
        ],
        "userModified": false
      },
      "validated": true
    },
    "enabled": true,
    "uiData": {
      "conditions": [
        {
          "col": "authorized_flag",
          "input": "purchase_date",
          "num": 0,
          "operator": "contains",
          "string": "${year}"
        }
      ],
      "mode": "&&"
    }
  },
  "selectedColumns": [
    {
      "name": "transaction_id",
      "table": 0,
      "type": "string"
    },
    {
      "name": "authorized_flag",
      "table": 0,
      "type": "string"
    },
    {
      "name": "purchase_date",
      "table": 0,
      "type": "string"
    },
    {
      "name": "card_id",
      "table": 0,
      "type": "string"
    },
    {
      "name": "merchant_id",
      "table": 0,
      "type": "string"
    },
    {
      "name": "merchant_category_id",
      "table": 0,
      "type": "bigint"
    },
    {
      "name": "item_category",
      "table": 0,
      "type": "string"
    },
    {
      "name": "purchase_amount",
      "table": 0,
      "type": "double"
    },
    {
      "name": "signature_provided",
      "table": 0,
      "type": "bigint"
    },
    {
      "name": "first_active_month",
      "table": 1,
      "type": "string"
    },
    {
      "name": "reward_program",
      "table": 1,
      "type": "string"
    },
    {
      "name": "latitude",
      "table": 1,
      "type": "double"
    },
    {
      "name": "longitude",
      "table": 1,
      "type": "double"
    },
    {
      "name": "fico_score",
      "table": 1,
      "type": "bigint"
    },
    {
      "name": "age",
      "table": 1,
      "type": "bigint"
    },
    {
      "name": "subsector_description",
      "table": 2,
      "type": "string"
    },
    {
      "name": "latitude",
      "table": 2,
      "type": "double"
    },
    {
      "name": "longitude",
      "table": 2,
      "type": "double"
    }
  ],
  "virtualInputs": [
    {
      "index": 2,
      "outputColumnsSelectionMode": "MANUAL"
    },
    {
      "index": 0,
      "outputColumnsSelectionMode": "MANUAL",
      "prefix": "card"
    },
    {
      "index": 1,
      "outputColumnsSelectionMode": "MANUAL",
      "prefix": "merchant"
    }
  ]
}