{
  "joins": [
    {
      "table2": 1,
      "table1": 0,
      "conditionsMode": "AND",
      "type": "LEFT",
      "outerJoinOnTheLeft": true,
      "on": [
        {
          "column1": {
            "name": "departure_date_parsed",
            "table": 0
          },
          "dateDiffUnit": "DAY",
          "column2": {
            "name": "departure_date_parsed",
            "table": 1
          },
          "maxMatches": 1,
          "caseInsensitive": false,
          "maxDistance": 0,
          "normalizeText": false,
          "type": "EQ",
          "strict": false
        },
        {
          "column1": {
            "name": "Origin",
            "table": 0
          },
          "dateDiffUnit": "DAY",
          "column2": {
            "name": "Origin",
            "table": 1
          },
          "maxMatches": 1,
          "caseInsensitive": false,
          "maxDistance": 0,
          "normalizeText": false,
          "type": "EQ",
          "strict": false
        }
      ]
    }
  ],
  "selectedColumns": [
    {
      "name": "departure_date_parsed",
      "type": "date",
      "table": 0
    },
    {
      "name": "dep_month",
      "type": "bigint",
      "table": 0
    },
    {
      "name": "dep_woy",
      "type": "bigint",
      "table": 0
    },
    {
      "name": "dep_dow",
      "type": "bigint",
      "table": 0
    },
    {
      "name": "dep_hour",
      "type": "bigint",
      "table": 0
    },
    {
      "name": "UniqueCarrier",
      "type": "string",
      "table": 0
    },
    {
      "name": "FlightNum",
      "type": "bigint",
      "table": 0
    },
    {
      "name": "ActualElapsedTime",
      "type": "string",
      "table": 0
    },
    {
      "name": "AirTime",
      "type": "string",
      "table": 0
    },
    {
      "name": "Late",
      "type": "boolean",
      "table": 0
    },
    {
      "name": "Origin",
      "type": "string",
      "table": 0
    },
    {
      "name": "Dest",
      "type": "string",
      "table": 0
    },
    {
      "name": "Distance",
      "type": "bigint",
      "table": 0
    },
    {
      "name": "origin_Latitude",
      "type": "string",
      "table": 0
    },
    {
      "name": "origin_Longitude",
      "type": "string",
      "table": 0
    },
    {
      "name": "origin_Altitude",
      "type": "string",
      "table": 0
    },
    {
      "name": "dest_Latitude",
      "type": "string",
      "table": 0
    },
    {
      "name": "dest_Longitude",
      "type": "string",
      "table": 0
    },
    {
      "name": "dest_Altitude",
      "type": "string",
      "table": 0
    },
    {
      "name": "Late_avg",
      "type": "double",
      "table": 1
    }
  ],
  "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,
      "useGlobalMetastore": false,
      "pipelineAllowStart": true,
      "readParams": {
        "mode": "AUTO",
        "autoModeRepartitionInto": 10,
        "map": {}
      },
      "overwriteOutputSchema": false,
      "executionEngine": "SPARK_SUBMIT",
      "sparkConfig": {
        "inheritConf": "default",
        "conf": []
      }
    }
  },
  "virtualInputs": [
    {
      "preFilter": {
        "distinct": false,
        "enabled": false
      },
      "autoSelectColumns": false,
      "index": 0,
      "computedColumns": []
    },
    {
      "preFilter": {
        "distinct": false,
        "enabled": false
      },
      "autoSelectColumns": false,
      "index": 1,
      "computedColumns": []
    }
  ],
  "computedColumns": [],
  "postFilter": {
    "$status": {
      "schema": {
        "columns": [
          {
            "name": "departure_date_parsed",
            "type": "date"
          },
          {
            "name": "dep_month",
            "type": "bigint"
          },
          {
            "name": "dep_woy",
            "type": "bigint"
          },
          {
            "name": "dep_dow",
            "type": "bigint"
          },
          {
            "name": "dep_hour",
            "type": "bigint"
          },
          {
            "name": "UniqueCarrier",
            "type": "string"
          },
          {
            "name": "FlightNum",
            "type": "bigint"
          },
          {
            "name": "ActualElapsedTime",
            "type": "string"
          },
          {
            "name": "AirTime",
            "type": "string"
          },
          {
            "name": "Late",
            "type": "boolean"
          },
          {
            "name": "Origin",
            "type": "string"
          },
          {
            "name": "Dest",
            "type": "string"
          },
          {
            "name": "Distance",
            "type": "bigint"
          },
          {
            "name": "origin_Latitude",
            "type": "string"
          },
          {
            "name": "origin_Longitude",
            "type": "string"
          },
          {
            "name": "origin_Altitude",
            "type": "string"
          },
          {
            "name": "dest_Latitude",
            "type": "string"
          },
          {
            "name": "dest_Longitude",
            "type": "string"
          },
          {
            "name": "dest_Altitude",
            "type": "string"
          },
          {
            "name": "Late_avg",
            "type": "double"
          }
        ],
        "userModified": false
      }
    }
  },
  "enableAutoCastInJoinConditions": false
}