{
  "joins": [
    {
      "table2": 1,
      "table1": 0,
      "conditionsMode": "AND",
      "type": "LEFT",
      "outerJoinOnTheLeft": true,
      "on": [
        {
          "column1": {
            "name": "card_id",
            "table": 0
          },
          "dateDiffUnit": "SECOND",
          "column2": {
            "name": "id",
            "table": 1
          },
          "type": "EQ"
        }
      ]
    },
    {
      "table2": 2,
      "table1": 0,
      "conditionsMode": "AND",
      "rightLimit": {},
      "type": "LEFT",
      "outerJoinOnTheLeft": true,
      "on": [
        {
          "column1": {
            "name": "merchant_id",
            "table": 0
          },
          "dateDiffUnit": "SECOND",
          "column2": {
            "name": "id",
            "table": 2
          },
          "type": "EQ"
        }
      ]
    }
  ],
  "selectedColumns": [
    {
      "name": "id",
      "type": "bigint",
      "table": 0
    },
    {
      "name": "authorized_flag",
      "type": "bigint",
      "table": 0
    },
    {
      "name": "purchase_date",
      "type": "string",
      "table": 0
    },
    {
      "name": "card_id",
      "type": "string",
      "table": 0
    },
    {
      "name": "merchant_id",
      "type": "string",
      "table": 0
    },
    {
      "name": "item_category",
      "type": "string",
      "table": 0
    },
    {
      "name": "purchase_amount",
      "type": "double",
      "table": 0
    },
    {
      "name": "signature_provided",
      "type": "bigint",
      "table": 0
    },
    {
      "name": "product_title",
      "type": "string",
      "table": 0
    },
    {
      "name": "first_active_month",
      "type": "string",
      "table": 1
    },
    {
      "name": "reward_program",
      "type": "string",
      "table": 1
    },
    {
      "name": "cardholder_fico_score",
      "type": "bigint",
      "table": 1
    },
    {
      "name": "cardholder_age",
      "type": "bigint",
      "table": 1
    },
    {
      "name": "category_id",
      "type": "bigint",
      "table": 2
    },
    {
      "name": "subsector",
      "type": "string",
      "table": 2
    },
    {
      "name": "latitude",
      "type": "double",
      "table": 2
    },
    {
      "name": "longitude",
      "type": "double",
      "table": 2
    }
  ],
  "resolvedSelectedColumns": [],
  "engineParams": {
    "hive": {
      "skipPrerunValidate": false,
      "hiveconf": [],
      "inheritConf": "default",
      "addDkuUdf": false,
      "executionEngine": "HIVECLI_LOCAL"
    },
    "sqlPipelineParams": {
      "pipelineAllowMerge": true,
      "pipelineAllowStart": true
    },
    "impala": {
      "forceStreamMode": true
    },
    "lowerCaseSchemaIfEngineRequiresIt": true,
    "sparkSQL": {
      "skipPrerunValidate": false,
      "pipelineAllowMerge": true,
      "pipelineAllowStart": true,
      "useGlobalMetastore": false,
      "readParams": {
        "mode": "AUTO",
        "autoModeRepartitionInto": 10,
        "map": {}
      },
      "overwriteOutputSchema": false,
      "executionEngine": "SPARK_SUBMIT",
      "sparkConfig": {
        "conf": [],
        "inheritConf": "default"
      }
    }
  },
  "virtualInputs": [
    {
      "outputColumnsSelectionMode": "AUTO_NON_CONFLICTING",
      "preFilter": {
        "uiData": {
          "$latestOperator": "\u0026\u0026",
          "mode": "CUSTOM",
          "$filterOptions": "CUSTOM",
          "conditions": [
            {
              "col": "authorized_flag",
              "input": "purchase_date",
              "string": "2017-01",
              "$showList": false,
              "num": 0,
              "operator": "contains"
            }
          ]
        },
        "expression": "contains(strval(\u0027purchase_date\u0027), variables[\"tx_month\"])",
        "$status": {
          "validated": true,
          "fullyTranslated": true,
          "message": "Incorrect formula: \u0027contains(strval(\u0027purchase_date\u0027), )\u0027 : Missing number, string, identifier, regex, or parenthesized expression (Parsing error at offset 34)",
          "ok": true,
          "sql": "\"purchase_date\" LIKE CONCAT(\u0027%\u0027, REPLACE(REPLACE(REPLACE(\u00272017-01\u0027, \u0027\\\u0027, \u0027\\\\\u0027), \u0027%\u0027, \u0027\\%\u0027), \u0027_\u0027, \u0027\\_\u0027), \u0027%\u0027)"
        },
        "distinct": false,
        "enabled": true
      },
      "originLabel": "tx",
      "index": 0,
      "computedColumns": []
    },
    {
      "outputColumnsSelectionMode": "AUTO_NON_CONFLICTING",
      "index": 1
    },
    {
      "outputColumnsSelectionMode": "AUTO_NON_CONFLICTING",
      "preFilter": {},
      "prefix": "merchant",
      "index": 2
    }
  ],
  "computedColumns": [],
  "postFilter": {
    "$status": {
      "schema": {
        "columns": [
          {
            "name": "id",
            "type": "bigint"
          },
          {
            "name": "authorized_flag",
            "type": "bigint"
          },
          {
            "name": "purchase_date",
            "type": "string"
          },
          {
            "name": "card_id",
            "type": "string"
          },
          {
            "name": "merchant_id",
            "type": "string"
          },
          {
            "name": "item_category",
            "type": "string"
          },
          {
            "name": "purchase_amount",
            "type": "double"
          },
          {
            "name": "signature_provided",
            "type": "bigint"
          },
          {
            "name": "product_title",
            "type": "string"
          },
          {
            "name": "first_active_month",
            "type": "string"
          },
          {
            "name": "first_active_month_parsed",
            "type": "date"
          },
          {
            "name": "reward_program",
            "type": "string"
          },
          {
            "name": "cardholder_fico_score",
            "type": "bigint"
          },
          {
            "name": "cardholder_fico_range",
            "type": "string"
          },
          {
            "name": "cardholder_age",
            "type": "bigint"
          },
          {
            "name": "merchant_category_id",
            "type": "bigint"
          },
          {
            "name": "merchant_subsector",
            "type": "string"
          },
          {
            "name": "merchant_latitude",
            "type": "double"
          },
          {
            "name": "merchant_longitude",
            "type": "double"
          }
        ],
        "userModified": false
      }
    }
  },
  "enableAutoCastInJoinConditions": false
}