Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_segment_content_map

created: 2022-08-12 11:01:38
disabled: False
format: raw
id: 1400
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906585

created: 2026-04-17 00:36:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-17/1776404189'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-17/1776404189
id: 906585
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6415153
updated: 2026-04-17 00:36:43

Version 906365

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-16/1776316371'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-16/1776316371
id: 906365
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6414602
updated: 2026-04-16 00:13:20

Version 906153

created: 2026-04-15 00:29:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-15/1776230952'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-15/1776230952
id: 906153
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6414117
updated: 2026-04-15 00:29:36

Version 905933

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-14/1776143617'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-14/1776143617
id: 905933
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6413601
updated: 2026-04-14 00:13:54

Version 905717

created: 2026-04-13 00:19:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-13/1776057537'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-13/1776057537
id: 905717
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6413053
updated: 2026-04-13 00:19:15

Version 905518

created: 2026-04-12 00:15:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-12/1775970928'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-12/1775970928
id: 905518
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6412670
updated: 2026-04-12 00:15:47

Version 905323

created: 2026-04-11 00:40:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-11/1775885987'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-11/1775885987
id: 905323
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6412296
updated: 2026-04-11 00:40:22

Version 905101

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-10/1775797990'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-10/1775797990
id: 905101
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6411784
updated: 2026-04-10 00:13:41

Version 904890

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-09/1775711788'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-09/1775711788
id: 904890
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6411277
updated: 2026-04-09 00:16:43

Version 904679

created: 2026-04-08 00:32:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-08/1775626369'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-08/1775626369
id: 904679
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6410782
updated: 2026-04-08 00:33:06

Version 904461

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-07/1775538998'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-07/1775538998
id: 904461
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6410265
updated: 2026-04-07 00:17:00

Version 904247

created: 2026-04-06 00:14:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-06/1775452482'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-06/1775452482
id: 904247
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6409720
updated: 2026-04-06 00:15:04

Version 904050

created: 2026-04-05 00:17:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-05/1775366253'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-05/1775366253
id: 904050
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6409346
updated: 2026-04-05 00:17:59

Version 903845

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-04/1775279575'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-04/1775279575
id: 903845
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6408962
updated: 2026-04-04 00:13:23

Version 903626

created: 2026-04-03 00:13:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-03/1775193175'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_segment_content_map/2026-04-03/1775193175
id: 903626
processed: 1

raw_data:

{
    "content_id": "int32",
    "insert_time": "timestamp[ns]",
    "segment_content_map_id": "int32",
    "segment_id": "int32"
}

schema_attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

schema_name_id: 1400
schema_scan_id: 6408461
updated: 2026-04-03 00:13:22

Schema Scans: 15

Last at 2026-04-17 00:36:32

Scan 6415153

duration: 0:00:11.596277

exit_message:

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

id: 6415153

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_segment_content_map/2026-04-17/1776404189",
        "key": "raw/sparefoot_segment_content_map/2026-04-17/1776404189/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3786574598812723199,
        "service_name": "sparefoot",
        "span_id": 15521034505849989470,
        "trace_id": 3786574598812723199
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-17 00:36:32
success: True
trace_id: 3786574598812723199

Scan 6414602

duration: 0:00:11.689837

exit_message:

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

id: 6414602

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_segment_content_map/2026-04-16/1776316371",
        "key": "raw/sparefoot_segment_content_map/2026-04-16/1776316371/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6000385883405432437,
        "service_name": "sparefoot",
        "span_id": 7865662411403782220,
        "trace_id": 6000385883405432437
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-16 00:13:09
success: True
trace_id: 6000385883405432437

Scan 6414117

duration: 0:00:14.297768

exit_message:

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

id: 6414117

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_segment_content_map/2026-04-15/1776230952",
        "key": "raw/sparefoot_segment_content_map/2026-04-15/1776230952/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6442478896012225769,
        "service_name": "sparefoot",
        "span_id": 6952085070505429601,
        "trace_id": 6442478896012225769
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-15 00:29:22
success: True
trace_id: 6442478896012225769

Scan 6413601

duration: 0:00:14.275764

exit_message:

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

id: 6413601

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_segment_content_map/2026-04-14/1776143617",
        "key": "raw/sparefoot_segment_content_map/2026-04-14/1776143617/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6790327563347986454,
        "service_name": "sparefoot",
        "span_id": 5596005705324243021,
        "trace_id": 6790327563347986454
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-14 00:13:40
success: True
trace_id: 6790327563347986454

Scan 6413053

duration: 0:00:14.235395

exit_message:

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

id: 6413053

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_segment_content_map/2026-04-13/1776057537",
        "key": "raw/sparefoot_segment_content_map/2026-04-13/1776057537/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17686716026295438541,
        "service_name": "sparefoot",
        "span_id": 4513129994285766067,
        "trace_id": 17686716026295438541
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-13 00:19:00
success: True
trace_id: 17686716026295438541

Scan 6412670

duration: 0:00:11.692585

exit_message:

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

id: 6412670

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_segment_content_map/2026-04-12/1775970928",
        "key": "raw/sparefoot_segment_content_map/2026-04-12/1775970928/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15763347327396841240,
        "service_name": "sparefoot",
        "span_id": 7592559166185207647,
        "trace_id": 15763347327396841240
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-12 00:15:36
success: True
trace_id: 15763347327396841240

Scan 6412296

duration: 0:00:14.260190

exit_message:

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

id: 6412296

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_segment_content_map/2026-04-11/1775885987",
        "key": "raw/sparefoot_segment_content_map/2026-04-11/1775885987/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3356745934968086050,
        "service_name": "sparefoot",
        "span_id": 2624571917906885942,
        "trace_id": 3356745934968086050
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-11 00:40:08
success: True
trace_id: 3356745934968086050

Scan 6411784

duration: 0:00:14.138305

exit_message:

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

id: 6411784

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_segment_content_map/2026-04-10/1775797990",
        "key": "raw/sparefoot_segment_content_map/2026-04-10/1775797990/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12989161723197930303,
        "service_name": "sparefoot",
        "span_id": 2485515747920157109,
        "trace_id": 12989161723197930303
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-10 00:13:27
success: True
trace_id: 12989161723197930303

Scan 6411277

duration: 0:00:11.777699

exit_message:

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

id: 6411277

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_segment_content_map/2026-04-09/1775711788",
        "key": "raw/sparefoot_segment_content_map/2026-04-09/1775711788/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4210498169308146209,
        "service_name": "sparefoot",
        "span_id": 1188018693825501971,
        "trace_id": 4210498169308146209
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-09 00:16:31
success: True
trace_id: 4210498169308146209

Scan 6410782

duration: 0:00:14.198473

exit_message:

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

id: 6410782

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_segment_content_map/2026-04-08/1775626369",
        "key": "raw/sparefoot_segment_content_map/2026-04-08/1775626369/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15880392333012339939,
        "service_name": "sparefoot",
        "span_id": 1228008041649222419,
        "trace_id": 15880392333012339939
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-08 00:32:52
success: True
trace_id: 15880392333012339939

Scan 6410265

duration: 0:00:14.434081

exit_message:

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

id: 6410265

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_segment_content_map/2026-04-07/1775538998",
        "key": "raw/sparefoot_segment_content_map/2026-04-07/1775538998/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3650703446107436908,
        "service_name": "sparefoot",
        "span_id": 5746655275478665814,
        "trace_id": 3650703446107436908
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-07 00:16:46
success: True
trace_id: 3650703446107436908

Scan 6409720

duration: 0:00:11.674677

exit_message:

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

id: 6409720

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_segment_content_map/2026-04-06/1775452482",
        "key": "raw/sparefoot_segment_content_map/2026-04-06/1775452482/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3282351506751095688,
        "service_name": "sparefoot",
        "span_id": 3488567058364495463,
        "trace_id": 3282351506751095688
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-06 00:14:53
success: True
trace_id: 3282351506751095688

Scan 6409346

duration: 0:00:14.540759

exit_message:

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

id: 6409346

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_segment_content_map/2026-04-05/1775366253",
        "key": "raw/sparefoot_segment_content_map/2026-04-05/1775366253/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13426437459447916746,
        "service_name": "sparefoot",
        "span_id": 1586669099263164133,
        "trace_id": 13426437459447916746
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-05 00:17:45
success: True
trace_id: 13426437459447916746

Scan 6408962

duration: 0:00:14.200187

exit_message:

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

id: 6408962

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_segment_content_map/2026-04-04/1775279575",
        "key": "raw/sparefoot_segment_content_map/2026-04-04/1775279575/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10074016908372877249,
        "service_name": "sparefoot",
        "span_id": 1840046799902983251,
        "trace_id": 10074016908372877249
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-04 00:13:09
success: True
trace_id: 10074016908372877249

Scan 6408461

duration: 0:00:14.200118

exit_message:

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

id: 6408461

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_segment_content_map/2026-04-03/1775193175",
        "key": "raw/sparefoot_segment_content_map/2026-04-03/1775193175/segment_content_map_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_segment_content_map",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13028359632694670682,
        "service_name": "sparefoot",
        "span_id": 8811880640135404876,
        "trace_id": 13028359632694670682
    }
}

running: False
schema_name_id: 1400
start_time: 2026-04-03 00:13:08
success: True
trace_id: 13028359632694670682

Partitions:

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

Schema:

attributes:

{
    "content_id": "int",
    "insert_time": "timestamp",
    "segment_content_map_id": "int",
    "segment_id": "int"
}

created: 2026-04-17 00:36:32

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_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-17/1776404189'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
}

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 11:01:38",
        "disabled": false,
        "format": "raw",
        "id": 1400,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_segment_content_map"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "content_id": "int",
            "insert_time": "timestamp",
            "segment_content_map_id": "int",
            "segment_id": "int"
        },
        "created": "2026-04-17 00:36:32",
        "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_segment_content_map`\n(\n `content_id`  int , `insert_time`  timestamp , `segment_content_map_id`  int , `segment_id`  int \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_segment_content_map/2026-04-17/1776404189'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_segment_content_map`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_segment_content_map"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}