{
  "computedColumns": [],
  "cumeDist": false,
  "denseRank": 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
    }
  },
  "keys": [],
  "legacyUnboundedWindowStreamBehavior": false,
  "ntile": false,
  "ntileValues": "10",
  "outputColumnNameOverrides": {},
  "postFilter": {
    "$status": {
      "schema": {
        "columns": [
          {
            "name": "transaction_id",
            "type": "bigint"
          },
          {
            "name": "authorized_flag",
            "type": "bigint"
          },
          {
            "name": "purchase_date_parsed",
            "type": "date"
          },
          {
            "name": "purchase_year",
            "type": "bigint"
          },
          {
            "name": "purchase_month",
            "type": "bigint"
          },
          {
            "name": "purchase_day",
            "type": "bigint"
          },
          {
            "name": "purchase_dow",
            "type": "bigint"
          },
          {
            "name": "purchase_weekend",
            "type": "bigint"
          },
          {
            "name": "purchase_hour",
            "type": "bigint"
          },
          {
            "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_first_active_month_parsed",
            "type": "date"
          },
          {
            "name": "days_active",
            "type": "bigint"
          },
          {
            "name": "card_reward_program",
            "type": "string"
          },
          {
            "name": "card_latitude",
            "type": "string"
          },
          {
            "name": "card_longitude",
            "type": "string"
          },
          {
            "name": "card_fico_score",
            "type": "bigint"
          },
          {
            "name": "card_age",
            "type": "bigint"
          },
          {
            "name": "merchant_latitude",
            "type": "string"
          },
          {
            "name": "merchant_longitude",
            "type": "string"
          },
          {
            "name": "merchant_location",
            "type": "string"
          },
          {
            "name": "merchant_cardholder_distance",
            "type": "double"
          },
          {
            "name": "merchant_state",
            "type": "string"
          },
          {
            "name": "merchant_state_enName",
            "type": "string"
          },
          {
            "name": "card_location",
            "type": "string"
          },
          {
            "name": "card_state",
            "type": "string"
          },
          {
            "name": "card_state_enName",
            "type": "string"
          },
          {
            "name": "card_purchase_amount_min",
            "type": "double"
          },
          {
            "name": "card_purchase_amount_max",
            "type": "double"
          },
          {
            "name": "card_purchase_amount_avg",
            "type": "double"
          },
          {
            "name": "merchant_purchase_amount_min",
            "type": "double"
          },
          {
            "name": "merchant_purchase_amount_max",
            "type": "double"
          },
          {
            "name": "merchant_purchase_amount_avg",
            "type": "double"
          }
        ],
        "userModified": false
      }
    },
    "distinct": false,
    "enabled": false
  },
  "preFilter": {
    "distinct": false,
    "enabled": false
  },
  "rank": false,
  "retrievedColumnsSelectionMode": "EXPLICIT",
  "rowNumber": false,
  "values": [
    {
      "$idx": 0,
      "$selected": false,
      "avg": false,
      "column": "transaction_id",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 1,
      "avg": false,
      "column": "authorized_flag",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 2,
      "avg": false,
      "column": "purchase_date_orig",
      "concat": false,
      "count": false,
      "first": false,
      "lag": false,
      "lagDiff": false,
      "last": false,
      "lead": false,
      "leadDiff": false,
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": false
    },
    {
      "$idx": 3,
      "avg": false,
      "column": "purchase_date_parsed",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "date",
      "value": true
    },
    {
      "$idx": 4,
      "avg": false,
      "column": "purchase_year",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 5,
      "avg": false,
      "column": "purchase_month",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 6,
      "avg": false,
      "column": "purchase_day",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 7,
      "avg": false,
      "column": "purchase_dow",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 8,
      "avg": false,
      "column": "purchase_weekend",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 9,
      "avg": false,
      "column": "purchase_hour",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 10,
      "avg": false,
      "column": "card_id",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 11,
      "avg": false,
      "column": "merchant_id",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 12,
      "avg": false,
      "column": "merchant_category_id",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 13,
      "avg": false,
      "column": "item_category",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 14,
      "$selected": false,
      "avg": true,
      "column": "purchase_amount",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": true,
      "min": true,
      "stddev": false,
      "sum": false,
      "type": "double",
      "value": true
    },
    {
      "$idx": 15,
      "avg": false,
      "column": "signature_provided",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 16,
      "avg": false,
      "column": "card_first_active_month",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 17,
      "avg": false,
      "column": "card_first_active_month_parsed",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "date",
      "value": true
    },
    {
      "$idx": 18,
      "avg": false,
      "column": "days_active",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 19,
      "avg": false,
      "column": "card_reward_program",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 20,
      "avg": false,
      "column": "card_latitude",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 21,
      "avg": false,
      "column": "card_longitude",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 22,
      "avg": false,
      "column": "card_fico_score",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 23,
      "avg": false,
      "column": "card_age",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "bigint",
      "value": true
    },
    {
      "$idx": 24,
      "avg": false,
      "column": "merchant_latitude",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 25,
      "avg": false,
      "column": "merchant_longitude",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 26,
      "avg": false,
      "column": "merchant_location",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 27,
      "avg": false,
      "column": "merchant_cardholder_distance",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "double",
      "value": true
    },
    {
      "$idx": 28,
      "avg": false,
      "column": "merchant_state",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 29,
      "avg": false,
      "column": "merchant_state_enName",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 30,
      "avg": false,
      "column": "card_location",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 31,
      "avg": false,
      "column": "card_state",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    },
    {
      "$idx": 32,
      "avg": false,
      "column": "card_state_enName",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": false,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "string",
      "value": true
    }
  ],
  "windows": [
    {
      "enableLimits": true,
      "enableOrdering": true,
      "enablePartitioning": true,
      "followingRows": 0,
      "limitFollowing": true,
      "limitPreceding": false,
      "orders": [
        {
          "column": "purchase_date_parsed",
          "desc": false
        }
      ],
      "partitioningColumns": [
        "card_id"
      ],
      "precedingRows": 0,
      "prefix": "card",
      "windowLimitMode": "ROWS",
      "windowLowerBound": 0,
      "windowUpperBound": 0
    },
    {
      "enableLimits": true,
      "enableOrdering": true,
      "enablePartitioning": true,
      "followingRows": 0,
      "limitFollowing": true,
      "orders": [
        {
          "column": "purchase_date_parsed",
          "desc": false
        }
      ],
      "partitioningColumns": [
        "merchant_id"
      ],
      "prefix": "merchant",
      "windowLimitMode": "ROWS"
    }
  ]
}