Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values

created: 2022-08-18 17:23:58
disabled: False
format: raw
id: 1130
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_prod_rds",
    "table": "sparefoot_sparefoot_algorithm_distance_values"
}

type: rds

Schema Versions: 15

Version 1718394

created: 2026-04-17 14:15:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-17/1776453332'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-17/1776453332
id: 1718394
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162194010
updated: 2026-04-17 14:15:49

Version 1718229

created: 2026-04-17 09:26:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-17/1776435964'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-17/1776435964
id: 1718229
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162178335
updated: 2026-04-17 09:26:30

Version 1717470

created: 2026-04-17 00:13:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-17/1776402643'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-17/1776402643
id: 1717470
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162163630
updated: 2026-04-17 00:14:03

Version 1717347

created: 2026-04-16 20:24:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-16/1776388908'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-16/1776388908
id: 1717347
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162156143
updated: 2026-04-16 20:24:21

Version 1717163

created: 2026-04-16 14:15:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-16/1776366922'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-16/1776366922
id: 1717163
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162138053
updated: 2026-04-16 14:15:52

Version 1716997

created: 2026-04-16 09:14:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-16/1776348894'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-16/1776348894
id: 1716997
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162122535
updated: 2026-04-16 09:15:09

Version 1716209

created: 2026-04-16 00:09:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-16/1776316145'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-16/1776316145
id: 1716209
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162107785
updated: 2026-04-16 00:09:45

Version 1716109

created: 2026-04-15 20:24:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-15/1776302660'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-15/1776302660
id: 1716109
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162100325
updated: 2026-04-15 20:24:37

Version 1715965

created: 2026-04-15 14:16:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-15/1776280558'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-15/1776280558
id: 1715965
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162081721
updated: 2026-04-15 14:16:31

Version 1715793

created: 2026-04-15 08:45:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-15/1776260516'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-15/1776260516
id: 1715793
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162064571
updated: 2026-04-15 08:45:43

Version 1715034

created: 2026-04-15 00:21:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-15/1776230459'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-15/1776230459
id: 1715034
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162052005
updated: 2026-04-15 00:21:25

Version 1714892

created: 2026-04-14 20:15:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-14/1776215716'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-14/1776215716
id: 1714892
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162044252
updated: 2026-04-14 20:15:58

Version 1714758

created: 2026-04-14 14:17:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-14/1776194213'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-14/1776194213
id: 1714758
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162026161
updated: 2026-04-14 14:18:01

Version 1714541

created: 2026-04-14 08:54:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-14/1776174878'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-14/1776174878
id: 1714541
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 162009392
updated: 2026-04-14 08:55:06

Version 1713831

created: 2026-04-14 00:15:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-14/1776143747'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-14/1776143747
id: 1713831
processed: 1

raw_data:

{
    "distance": "int32",
    "id": "int32",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

schema_name_id: 1130
schema_scan_id: 161996376
updated: 2026-04-14 00:16:08

Schema Scans: 15

Last at 2026-04-17 14:15:35

Scan 162194010

duration: 0:00:14.171630

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162194010

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-17/1776453332",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-17/1776453332/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13010744428347335444,
        "service_name": "sparefoot",
        "span_id": 18112655081375174476,
        "trace_id": 13010744428347335444
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-17 14:15:35
success: True
trace_id: 13010744428347335444

Scan 162178335

duration: 0:00:14.290619

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162178335

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-17/1776435964",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-17/1776435964/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12492862448192147484,
        "service_name": "sparefoot",
        "span_id": 10348609948833945053,
        "trace_id": 12492862448192147484
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-17 09:26:15
success: True
trace_id: 12492862448192147484

Scan 162163630

duration: 0:00:11.669747

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162163630

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-17/1776402643",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-17/1776402643/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 581848662105937899,
        "service_name": "sparefoot",
        "span_id": 5518941549256591808,
        "trace_id": 581848662105937899
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-17 00:13:52
success: True
trace_id: 581848662105937899

Scan 162156143

duration: 0:00:14.216914

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162156143

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-16/1776388908",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-16/1776388908/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17169447692404865031,
        "service_name": "sparefoot",
        "span_id": 17531565255978657021,
        "trace_id": 17169447692404865031
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-16 20:24:07
success: True
trace_id: 17169447692404865031

Scan 162138053

duration: 0:00:14.228861

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162138053

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-16/1776366922",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-16/1776366922/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14528843112507578054,
        "service_name": "sparefoot",
        "span_id": 2280962887570592750,
        "trace_id": 14528843112507578054
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-16 14:15:38
success: True
trace_id: 14528843112507578054

Scan 162122535

duration: 0:00:11.677632

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162122535

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-16/1776348894",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-16/1776348894/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8621994351789747631,
        "service_name": "sparefoot",
        "span_id": 4582401232507744447,
        "trace_id": 8621994351789747631
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-16 09:14:58
success: True
trace_id: 8621994351789747631

Scan 162107785

duration: 0:00:11.722910

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162107785

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-16/1776316145",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-16/1776316145/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7589595085784957802,
        "service_name": "sparefoot",
        "span_id": 12801918214702355698,
        "trace_id": 7589595085784957802
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-16 00:09:33
success: True
trace_id: 7589595085784957802

Scan 162100325

duration: 0:00:14.241208

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162100325

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-15/1776302660",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-15/1776302660/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14689710927602227364,
        "service_name": "sparefoot",
        "span_id": 11342163250159048580,
        "trace_id": 14689710927602227364
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-15 20:24:23
success: True
trace_id: 14689710927602227364

Scan 162081721

duration: 0:00:11.694045

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162081721

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-15/1776280558",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-15/1776280558/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13807149332985518582,
        "service_name": "sparefoot",
        "span_id": 5183552885931918051,
        "trace_id": 13807149332985518582
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-15 14:16:19
success: True
trace_id: 13807149332985518582

Scan 162064571

duration: 0:00:11.823892

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162064571

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-15/1776260516",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-15/1776260516/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12719983715757520721,
        "service_name": "sparefoot",
        "span_id": 1573239469557767286,
        "trace_id": 12719983715757520721
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-15 08:45:32
success: True
trace_id: 12719983715757520721

Scan 162052005

duration: 0:00:11.756008

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162052005

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-15/1776230459",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-15/1776230459/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16724202255909679131,
        "service_name": "sparefoot",
        "span_id": 5398010207105912881,
        "trace_id": 16724202255909679131
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-15 00:21:13
success: True
trace_id: 16724202255909679131

Scan 162044252

duration: 0:00:14.360495

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162044252

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-14/1776215716",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-14/1776215716/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8831802389371908108,
        "service_name": "sparefoot",
        "span_id": 10631849582936762967,
        "trace_id": 8831802389371908108
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-14 20:15:43
success: True
trace_id: 8831802389371908108

Scan 162026161

duration: 0:00:11.775987

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162026161

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-14/1776194213",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-14/1776194213/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1872232583940588604,
        "service_name": "sparefoot",
        "span_id": 4817129876537944199,
        "trace_id": 1872232583940588604
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-14 14:17:49
success: True
trace_id: 1872232583940588604

Scan 162009392

duration: 0:00:14.204850

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162009392

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-14/1776174878",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-14/1776174878/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10514670524643265273,
        "service_name": "sparefoot",
        "span_id": 8854744417905728727,
        "trace_id": 10514670524643265273
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-14 08:54:52
success: True
trace_id: 10514670524643265273

Scan 161996376

duration: 0:00:14.164026

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161996376

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-14/1776143747",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-14/1776143747/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12799857436214810755,
        "service_name": "sparefoot",
        "span_id": 11930474817327199665,
        "trace_id": 12799857436214810755
    }
}

running: False
schema_name_id: 1130
start_time: 2026-04-14 00:15:53
success: True
trace_id: 12799857436214810755

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "distance": "int",
    "id": "int",
    "latitude": "double",
    "location_key": "string",
    "longitude": "double",
    "value": "double"
}

created: 2026-04-17 14:15:35

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-17/1776453332'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-18 17:23:58",
        "disabled": false,
        "format": "raw",
        "id": 1130,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_algorithm_distance_values"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "distance": "int",
            "id": "int",
            "latitude": "double",
            "location_key": "string",
            "longitude": "double",
            "value": "double"
        },
        "created": "2026-04-17 14:15:35",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`\n(\n `distance`  int , `id`  int , `latitude`  double , `location_key`  string , `longitude`  double , `value`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_algorithm_distance_values/2026-04-17/1776453332'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_algorithm_distance_values"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}