Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_segment_content_map

created: 2022-08-18 17:26:40
disabled: False
format: raw
id: 1141
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718416

created: 2026-04-17 14:17:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-17/1776453447'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-17/1776453447
id: 1718416
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: 1141
schema_scan_id: 162194061
updated: 2026-04-17 14:17:47

Version 1718228

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-17/1776435965'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-17/1776435965
id: 1718228
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: 1141
schema_scan_id: 162178334
updated: 2026-04-17 09:26:27

Version 1717478

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-17/1776402951'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-17/1776402951
id: 1717478
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: 1141
schema_scan_id: 162163659
updated: 2026-04-17 00:16:05

Version 1717369

created: 2026-04-16 20:40:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-16/1776390000'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-16/1776390000
id: 1717369
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: 1141
schema_scan_id: 162156251
updated: 2026-04-16 20:40:18

Version 1717188

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-16/1776367217'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-16/1776367217
id: 1717188
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: 1141
schema_scan_id: 162138144
updated: 2026-04-16 14:20:57

Version 1717051

created: 2026-04-16 09:45:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-16/1776350683'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-16/1776350683
id: 1717051
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: 1141
schema_scan_id: 162122921
updated: 2026-04-16 09:45:25

Version 1716242

created: 2026-04-16 00:19:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-16/1776316770'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-16/1776316770
id: 1716242
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: 1141
schema_scan_id: 162107832
updated: 2026-04-16 00:20:01

Version 1716131

created: 2026-04-15 20:29:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-15/1776302961'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-15/1776302961
id: 1716131
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: 1141
schema_scan_id: 162100365
updated: 2026-04-15 20:29:40

Version 1715998

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-15/1776280864'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-15/1776280864
id: 1715998
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: 1141
schema_scan_id: 162081818
updated: 2026-04-15 14:21:22

Version 1715784

created: 2026-04-15 08:44:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-15/1776260609'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-15/1776260609
id: 1715784
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: 1141
schema_scan_id: 162064539
updated: 2026-04-15 08:44:32

Version 1715048

created: 2026-04-15 00:24:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-15/1776230668'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-15/1776230668
id: 1715048
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: 1141
schema_scan_id: 162052020
updated: 2026-04-15 00:24:45

Version 1714923

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-14/1776216431'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-14/1776216431
id: 1714923
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: 1141
schema_scan_id: 162044350
updated: 2026-04-14 20:27:29

Version 1714765

created: 2026-04-14 14:20:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-14/1776194272'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-14/1776194272
id: 1714765
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: 1141
schema_scan_id: 162026207
updated: 2026-04-14 14:20:57

Version 1714603

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-14/1776175880'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-14/1776175880
id: 1714603
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: 1141
schema_scan_id: 162010974
updated: 2026-04-14 09:12:09

Version 1713843

created: 2026-04-14 00:16:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_segment_content_map/2026-04-14/1776143801'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_segment_content_map/2026-04-14/1776143801
id: 1713843
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: 1141
schema_scan_id: 161996388
updated: 2026-04-14 00:17:03

Schema Scans: 15

Last at 2026-04-17 14:17:36

Scan 162194061

duration: 0:00:11.776733

exit_message:

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

id: 162194061

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

running: False
schema_name_id: 1141
start_time: 2026-04-17 14:17:36
success: True
trace_id: 17700383122780234248

Scan 162178334

duration: 0:00:14.328586

exit_message:

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

id: 162178334

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

running: False
schema_name_id: 1141
start_time: 2026-04-17 09:26:13
success: True
trace_id: 14398006737019072318

Scan 162163659

duration: 0:00:11.508276

exit_message:

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

id: 162163659

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

running: False
schema_name_id: 1141
start_time: 2026-04-17 00:15:54
success: True
trace_id: 941266594194427531

Scan 162156251

duration: 0:00:14.302746

exit_message:

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

id: 162156251

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

running: False
schema_name_id: 1141
start_time: 2026-04-16 20:40:04
success: True
trace_id: 1277556956260528118

Scan 162138144

duration: 0:00:14.289774

exit_message:

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

id: 162138144

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

running: False
schema_name_id: 1141
start_time: 2026-04-16 14:20:43
success: True
trace_id: 9521924452476854184

Scan 162122921

duration: 0:00:14.199503

exit_message:

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

id: 162122921

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

running: False
schema_name_id: 1141
start_time: 2026-04-16 09:45:11
success: True
trace_id: 420288552315682048

Scan 162107832

duration: 0:00:14.229622

exit_message:

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

id: 162107832

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

running: False
schema_name_id: 1141
start_time: 2026-04-16 00:19:47
success: True
trace_id: 9635678949673671711

Scan 162100365

duration: 0:00:14.177607

exit_message:

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

id: 162100365

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

running: False
schema_name_id: 1141
start_time: 2026-04-15 20:29:26
success: True
trace_id: 17413279076950611689

Scan 162081818

duration: 0:00:14.120976

exit_message:

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

id: 162081818

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

running: False
schema_name_id: 1141
start_time: 2026-04-15 14:21:08
success: True
trace_id: 9543363848901155024

Scan 162064539

duration: 0:00:14.144201

exit_message:

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

id: 162064539

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

running: False
schema_name_id: 1141
start_time: 2026-04-15 08:44:18
success: True
trace_id: 10317176528292970953

Scan 162052020

duration: 0:00:14.206009

exit_message:

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

id: 162052020

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

running: False
schema_name_id: 1141
start_time: 2026-04-15 00:24:31
success: True
trace_id: 16759231331272447281

Scan 162044350

duration: 0:00:14.146872

exit_message:

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

id: 162044350

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

running: False
schema_name_id: 1141
start_time: 2026-04-14 20:27:15
success: True
trace_id: 3585744300139060441

Scan 162026207

duration: 0:00:14.358936

exit_message:

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

id: 162026207

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

running: False
schema_name_id: 1141
start_time: 2026-04-14 14:20:43
success: True
trace_id: 13968023677513586481

Scan 162010974

duration: 0:00:11.733926

exit_message:

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

id: 162010974

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

running: False
schema_name_id: 1141
start_time: 2026-04-14 09:11:58
success: True
trace_id: 8237370637917476214

Scan 161996388

duration: 0:00:14.256295

exit_message:

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

id: 161996388

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

running: False
schema_name_id: 1141
start_time: 2026-04-14 00:16:49
success: True
trace_id: 12706156905149858205

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 14:17:36

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_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-prod/raw/sparefoot_segment_content_map/2026-04-17/1776453447'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
}

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:26:40",
        "disabled": false,
        "format": "raw",
        "id": 1141,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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 14:17:36",
        "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_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-prod/raw/sparefoot_segment_content_map/2026-04-17/1776453447'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_segment_content_map`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_segment_content_map"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}