{
  "computedColumns": [],
  "enableAutoCastInJoinConditions": false,
  "engineParams": {
    "hive": {
      "addDkuUdf": false,
      "executionEngine": "HIVECLI_LOCAL",
      "hiveconf": [],
      "inheritConf": "default",
      "skipPrerunValidate": false
    },
    "impala": {
      "forceStreamMode": true
    },
    "lowerCaseSchemaIfEngineRequiresIt": true,
    "sparkSQL": {
      "executionEngine": "SPARK_SUBMIT",
      "overwriteOutputSchema": false,
      "pipelineAllowMerge": true,
      "pipelineAllowStart": true,
      "readParams": {
        "autoModeRepartitionInto": 10,
        "map": {},
        "mode": "AUTO"
      },
      "skipPrerunValidate": false,
      "sparkConfig": {
        "conf": [],
        "inheritConf": "default"
      },
      "useGlobalMetastore": false
    },
    "sqlPipelineParams": {
      "pipelineAllowMerge": true,
      "pipelineAllowStart": true
    }
  },
  "joins": [
    {
      "conditionsMode": "AND",
      "on": [
        {
          "caseInsensitive": false,
          "column1": {
            "name": "merchant_id",
            "table": 0
          },
          "column2": {
            "name": "merchant_id",
            "table": 1
          },
          "dateDiffUnit": "DAY",
          "maxDistance": 0,
          "maxMatches": 1,
          "normalizeText": false,
          "strict": false,
          "type": "EQ"
        }
      ],
      "outerJoinOnTheLeft": true,
      "table1": 0,
      "table2": 1,
      "type": "LEFT"
    },
    {
      "conditionsMode": "AND",
      "on": [
        {
          "column1": {
            "name": "card_id",
            "table": 0
          },
          "column2": {
            "name": "internal_card_mapping",
            "table": 2
          },
          "dateDiffUnit": "SECOND",
          "type": "EQ"
        }
      ],
      "outerJoinOnTheLeft": true,
      "rightLimit": {},
      "table1": 0,
      "table2": 2,
      "type": "LEFT"
    }
  ],
  "postFilter": {
    "$status": {
      "schema": {
        "columns": [
          {
            "name": "transaction_id",
            "type": "bigint"
          },
          {
            "name": "authorized_flag",
            "type": "bigint"
          },
          {
            "name": "purchase_date",
            "type": "string"
          },
          {
            "name": "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": "merchant_subsector_description",
            "type": "string"
          },
          {
            "name": "merchant_latitude",
            "type": "string"
          },
          {
            "name": "merchant_longitude",
            "type": "string"
          },
          {
            "name": "card_first_active_month",
            "type": "string"
          },
          {
            "name": "card_reward_program",
            "type": "string"
          },
          {
            "name": "card_latitude",
            "type": "string"
          },
          {
            "name": "card_longitude",
            "type": "string"
          },
          {
            "name": "card_fico_score",
            "type": "string"
          },
          {
            "name": "card_age",
            "type": "string"
          }
        ],
        "userModified": false
      }
    }
  },
  "resolvedSelectedColumns": [],
  "selectedColumns": [
    {
      "name": "transaction_id",
      "table": 0,
      "type": "bigint"
    },
    {
      "name": "authorized_flag",
      "table": 0,
      "type": "bigint"
    },
    {
      "name": "purchase_date",
      "table": 0,
      "type": "string"
    },
    {
      "name": "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": "subsector_description",
      "table": 1,
      "type": "string"
    },
    {
      "name": "latitude",
      "table": 1,
      "type": "string"
    },
    {
      "name": "longitude",
      "table": 1,
      "type": "string"
    },
    {
      "name": "first_active_month",
      "table": 2,
      "type": "string"
    },
    {
      "name": "reward_program",
      "table": 2,
      "type": "string"
    },
    {
      "name": "latitude",
      "table": 2,
      "type": "string"
    },
    {
      "name": "longitude",
      "table": 2,
      "type": "string"
    },
    {
      "name": "fico_score",
      "table": 2,
      "type": "string"
    },
    {
      "name": "age",
      "table": 2,
      "type": "string"
    }
  ],
  "virtualInputs": [
    {
      "autoSelectColumns": false,
      "computedColumns": [],
      "index": 0,
      "originLabel": "transactions_prepared",
      "outputColumnsSelectionMode": "MANUAL",
      "preFilter": {
        "distinct": false,
        "enabled": false
      }
    },
    {
      "autoSelectColumns": false,
      "computedColumns": [],
      "index": 1,
      "originLabel": "merchant_info",
      "outputColumnsSelectionMode": "MANUAL",
      "preFilter": {
        "distinct": false,
        "enabled": false
      },
      "prefix": "merchant"
    },
    {
      "autoSelectColumns": false,
      "index": 2,
      "outputColumnsSelectionMode": "MANUAL",
      "preFilter": {},
      "prefix": "card"
    }
  ]
}