{
  "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": "id",
            "type": "bigint"
          },
          {
            "name": "authorized_flag",
            "type": "bigint"
          },
          {
            "name": "purchase_date",
            "type": "date"
          },
          {
            "name": "card_id",
            "type": "string"
          },
          {
            "name": "merchant_id",
            "type": "string"
          },
          {
            "name": "item_category",
            "type": "string"
          },
          {
            "name": "purchase_amount",
            "type": "double"
          },
          {
            "name": "purchase_amount_eur",
            "type": "double"
          },
          {
            "name": "signature_provided",
            "type": "bigint"
          },
          {
            "name": "product_title",
            "type": "string"
          },
          {
            "name": "apple1",
            "type": "string"
          },
          {
            "name": "first_active_month",
            "type": "string"
          },
          {
            "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"
          },
          {
            "name": "purchase_date_lag_diff",
            "type": "bigint"
          },
          {
            "name": "purchase_amount_avg",
            "type": "double"
          },
          {
            "name": "rownumber",
            "type": "bigint"
          }
        ],
        "userModified": false
      }
    },
    "distinct": false,
    "enabled": false
  },
  "preFilter": {
    "distinct": false,
    "enabled": false
  },
  "rank": false,
  "retrievedColumnsSelectionMode": "ALL",
  "rowNumber": true,
  "values": [
    {
      "$idx": 0,
      "avg": false,
      "column": "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,
      "$selected": false,
      "avg": false,
      "column": "purchase_date",
      "concat": false,
      "concatDistinct": false,
      "count": false,
      "countDistinct": false,
      "dateDiffUnit": "DAY",
      "first": false,
      "firstLastNotNull": false,
      "lag": false,
      "lagDiff": true,
      "lagValues": "1",
      "last": false,
      "lead": false,
      "leadDiff": false,
      "leadValues": "1",
      "max": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "date",
      "value": true
    },
    {
      "$idx": 3,
      "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": 4,
      "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": 5,
      "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": 6,
      "$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": false,
      "min": false,
      "stddev": false,
      "sum": false,
      "type": "double",
      "value": true
    },
    {
      "$idx": 7,
      "avg": false,
      "column": "purchase_amount_eur",
      "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": 8,
      "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": 9,
      "avg": false,
      "column": "product_title",
      "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": 10,
      "avg": false,
      "column": "apple1",
      "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": "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": 12,
      "avg": false,
      "column": "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": 13,
      "avg": false,
      "column": "cardholder_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": 14,
      "avg": false,
      "column": "cardholder_fico_range",
      "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": 15,
      "avg": false,
      "column": "cardholder_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": 16,
      "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": 17,
      "avg": false,
      "column": "merchant_subsector",
      "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": 18,
      "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": "double",
      "value": true
    },
    {
      "$idx": 19,
      "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": "double",
      "value": true
    }
  ],
  "windows": [
    {
      "enableLimits": true,
      "enableOrdering": true,
      "enablePartitioning": true,
      "followingRows": 0,
      "limitFollowing": true,
      "limitPreceding": true,
      "orders": [
        {
          "column": "purchase_date",
          "desc": false
        }
      ],
      "partitioningColumns": [
        "card_id"
      ],
      "precedingRows": 0,
      "windowDateRangeUnit": "DAY",
      "windowLimitMode": "RANGE",
      "windowLowerBound": 5,
      "windowUpperBound": -1
    }
  ]
}