Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values

created: 2022-08-12 10:30:43
disabled: False
format: raw
id: 1360
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906559

created: 2026-04-17 00:19:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-17/1776403179'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-17/1776403179
id: 906559
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: 1360
schema_scan_id: 6415128
updated: 2026-04-17 00:20:01

Version 906318

created: 2026-04-16 00:07:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-16/1776316056'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-16/1776316056
id: 906318
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: 1360
schema_scan_id: 6414552
updated: 2026-04-16 00:07:54

Version 906142

created: 2026-04-15 00:27:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-15/1776230859'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-15/1776230859
id: 906142
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: 1360
schema_scan_id: 6414106
updated: 2026-04-15 00:28:08

Version 905898

created: 2026-04-14 00:10:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-14/1776143408'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-14/1776143408
id: 905898
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: 1360
schema_scan_id: 6413564
updated: 2026-04-14 00:10:24

Version 905686

created: 2026-04-13 00:15:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-13/1776057297'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-13/1776057297
id: 905686
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: 1360
schema_scan_id: 6413019
updated: 2026-04-13 00:15:19

Version 905495

created: 2026-04-12 00:10:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-12/1775970632'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-12/1775970632
id: 905495
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: 1360
schema_scan_id: 6412647
updated: 2026-04-12 00:10:49

Version 905289

created: 2026-04-11 00:10:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-11/1775884233'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-11/1775884233
id: 905289
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: 1360
schema_scan_id: 6412261
updated: 2026-04-11 00:10:56

Version 905057

created: 2026-04-10 00:06:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-10/1775797604'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-10/1775797604
id: 905057
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: 1360
schema_scan_id: 6411737
updated: 2026-04-10 00:07:03

Version 904884

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-09/1775711753'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-09/1775711753
id: 904884
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: 1360
schema_scan_id: 6411271
updated: 2026-04-09 00:16:15

Version 904667

created: 2026-04-08 00:24:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-08/1775625863'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-08/1775625863
id: 904667
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: 1360
schema_scan_id: 6410768
updated: 2026-04-08 00:24:38

Version 904422

created: 2026-04-07 00:08:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-07/1775538533'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-07/1775538533
id: 904422
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: 1360
schema_scan_id: 6410224
updated: 2026-04-07 00:09:10

Version 904206

created: 2026-04-06 00:06:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-06/1775451987'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-06/1775451987
id: 904206
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: 1360
schema_scan_id: 6409678
updated: 2026-04-06 00:06:42

Version 904008

created: 2026-04-05 00:07:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-05/1775365663'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-05/1775365663
id: 904008
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: 1360
schema_scan_id: 6409302
updated: 2026-04-05 00:08:03

Version 903819

created: 2026-04-04 00:10:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-04/1775279399'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-04/1775279399
id: 903819
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: 1360
schema_scan_id: 6408935
updated: 2026-04-04 00:10:17

Version 903572

created: 2026-04-03 00:05:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-03/1775192745'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-03/1775192745
id: 903572
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: 1360
schema_scan_id: 6408403
updated: 2026-04-03 00:06:02

Schema Scans: 15

Last at 2026-04-17 00:19:50

Scan 6415128

duration: 0:00:11.791553

exit_message:

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

id: 6415128

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-17/1776403179",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-17/1776403179/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2158749688279692260,
        "service_name": "sparefoot",
        "span_id": 11160721438410258009,
        "trace_id": 2158749688279692260
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-17 00:19:50
success: True
trace_id: 2158749688279692260

Scan 6414552

duration: 0:00:14.239016

exit_message:

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

id: 6414552

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-16/1776316056",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-16/1776316056/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5631130534936442422,
        "service_name": "sparefoot",
        "span_id": 6782045712590313438,
        "trace_id": 5631130534936442422
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-16 00:07:39
success: True
trace_id: 5631130534936442422

Scan 6414106

duration: 0:00:11.796005

exit_message:

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

id: 6414106

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-15/1776230859",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-15/1776230859/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9192587334937625318,
        "service_name": "sparefoot",
        "span_id": 3662410126123996501,
        "trace_id": 9192587334937625318
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-15 00:27:56
success: True
trace_id: 9192587334937625318

Scan 6413564

duration: 0:00:12.016809

exit_message:

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

id: 6413564

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-14/1776143408",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-14/1776143408/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4198466986499663249,
        "service_name": "sparefoot",
        "span_id": 11117361652844011207,
        "trace_id": 4198466986499663249
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-14 00:10:12
success: True
trace_id: 4198466986499663249

Scan 6413019

duration: 0:00:14.180893

exit_message:

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

id: 6413019

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-13/1776057297",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-13/1776057297/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 373189900580945397,
        "service_name": "sparefoot",
        "span_id": 8381849911656552125,
        "trace_id": 373189900580945397
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-13 00:15:04
success: True
trace_id: 373189900580945397

Scan 6412647

duration: 0:00:14.168913

exit_message:

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

id: 6412647

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-12/1775970632",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-12/1775970632/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10665533228111783321,
        "service_name": "sparefoot",
        "span_id": 2901610454500623690,
        "trace_id": 10665533228111783321
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-12 00:10:35
success: True
trace_id: 10665533228111783321

Scan 6412261

duration: 0:00:11.883443

exit_message:

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

id: 6412261

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-11/1775884233",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-11/1775884233/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6000850436898803460,
        "service_name": "sparefoot",
        "span_id": 7104397615433886085,
        "trace_id": 6000850436898803460
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-11 00:10:45
success: True
trace_id: 6000850436898803460

Scan 6411737

duration: 0:00:14.259571

exit_message:

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

id: 6411737

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-10/1775797604",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-10/1775797604/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17099558971460697652,
        "service_name": "sparefoot",
        "span_id": 17574225513384635120,
        "trace_id": 17099558971460697652
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-10 00:06:48
success: True
trace_id: 17099558971460697652

Scan 6411271

duration: 0:00:14.263580

exit_message:

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

id: 6411271

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-09/1775711753",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-09/1775711753/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 456978219256062670,
        "service_name": "sparefoot",
        "span_id": 17297815735366944745,
        "trace_id": 456978219256062670
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-09 00:16:01
success: True
trace_id: 456978219256062670

Scan 6410768

duration: 0:00:11.688377

exit_message:

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

id: 6410768

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-08/1775625863",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-08/1775625863/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 125645610628794260,
        "service_name": "sparefoot",
        "span_id": 5315396230360066137,
        "trace_id": 125645610628794260
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-08 00:24:27
success: True
trace_id: 125645610628794260

Scan 6410224

duration: 0:00:14.188767

exit_message:

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

id: 6410224

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-07/1775538533",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-07/1775538533/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18206615719196409357,
        "service_name": "sparefoot",
        "span_id": 13232697742554877439,
        "trace_id": 18206615719196409357
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-07 00:08:56
success: True
trace_id: 18206615719196409357

Scan 6409678

duration: 0:00:11.746766

exit_message:

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

id: 6409678

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-06/1775451987",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-06/1775451987/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10088124905666525303,
        "service_name": "sparefoot",
        "span_id": 17735108875393465354,
        "trace_id": 10088124905666525303
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-06 00:06:31
success: True
trace_id: 10088124905666525303

Scan 6409302

duration: 0:00:11.788172

exit_message:

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

id: 6409302

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-05/1775365663",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-05/1775365663/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9357948318432710045,
        "service_name": "sparefoot",
        "span_id": 1797912402160640981,
        "trace_id": 9357948318432710045
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-05 00:07:51
success: True
trace_id: 9357948318432710045

Scan 6408935

duration: 0:00:11.753354

exit_message:

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

id: 6408935

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-04/1775279399",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-04/1775279399/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2925628199922475344,
        "service_name": "sparefoot",
        "span_id": 15549085815355587892,
        "trace_id": 2925628199922475344
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-04 00:10:05
success: True
trace_id: 2925628199922475344

Scan 6408403

duration: 0:00:14.249461

exit_message:

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

id: 6408403

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_algorithm_distance_values/2026-04-03/1775192745",
        "key": "raw/sparefoot_algorithm_distance_values/2026-04-03/1775192745/algorithm_distance_values_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11079756065319823473,
        "service_name": "sparefoot",
        "span_id": 11428999692914341010,
        "trace_id": 11079756065319823473
    }
}

running: False
schema_name_id: 1360
start_time: 2026-04-03 00:05:47
success: True
trace_id: 11079756065319823473

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 00:19:50

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-17/1776403179'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-12 10:30:43",
        "disabled": false,
        "format": "raw",
        "id": 1360,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_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 00:19:50",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_algorithm_distance_values/2026-04-17/1776403179'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_algorithm_distance_values"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}