Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo

created: 2022-08-12 12:21:21
disabled: False
format: raw
id: 1406
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906564

created: 2026-04-17 00:20:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-17/1776403222'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-17/1776403222
id: 906564
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6415132
updated: 2026-04-17 00:20:37

Version 906351

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-16/1776316291'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-16/1776316291
id: 906351
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6414587
updated: 2026-04-16 00:11:57

Version 906105

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-15/1776229656'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-15/1776229656
id: 906105
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6414064
updated: 2026-04-15 00:07:52

Version 905914

created: 2026-04-14 00:11:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-14/1776143491'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-14/1776143491
id: 905914
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6413580
updated: 2026-04-14 00:11:52

Version 905672

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-13/1776057160'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-13/1776057160
id: 905672
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6413003
updated: 2026-04-13 00:13:14

Version 905498

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-12/1775970653'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-12/1775970653
id: 905498
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6412650
updated: 2026-04-12 00:11:22

Version 905294

created: 2026-04-11 00:11:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-11/1775884275'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-11/1775884275
id: 905294
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6412266
updated: 2026-04-11 00:11:30

Version 905058

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-10/1775797603'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-10/1775797603
id: 905058
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6411738
updated: 2026-04-10 00:07:08

Version 904851

created: 2026-04-09 00:12:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-09/1775711557'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-09/1775711557
id: 904851
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6411237
updated: 2026-04-09 00:12:58

Version 904668

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-08/1775625864'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-08/1775625864
id: 904668
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6410769
updated: 2026-04-08 00:24:49

Version 904447

created: 2026-04-07 00:15:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-07/1775538903'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-07/1775538903
id: 904447
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6410251
updated: 2026-04-07 00:15:22

Version 904191

created: 2026-04-06 00:04:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-06/1775451883'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-06/1775451883
id: 904191
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6409662
updated: 2026-04-06 00:04:59

Version 904021

created: 2026-04-05 00:09:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-05/1775365758'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-05/1775365758
id: 904021
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6409316
updated: 2026-04-05 00:09:42

Version 903801

created: 2026-04-04 00:07:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-04/1775279257'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-04/1775279257
id: 903801
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6408916
updated: 2026-04-04 00:07:52

Version 903619

created: 2026-04-03 00:12:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-03/1775193151'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_listing_avail_photo/2026-04-03/1775193151
id: 903619
processed: 1

raw_data:

{
    "listing_avail_id": "int32",
    "listing_avail_photo_id": "int32",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int32",
    "picture_timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

schema_name_id: 1406
schema_scan_id: 6408454
updated: 2026-04-03 00:12:53

Schema Scans: 15

Last at 2026-04-17 00:20:26

Scan 6415132

duration: 0:00:11.733226

exit_message:

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

id: 6415132

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_listing_avail_photo/2026-04-17/1776403222",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-17/1776403222/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5608455869004355214,
        "service_name": "sparefoot",
        "span_id": 13782811442819114495,
        "trace_id": 5608455869004355214
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-17 00:20:26
success: True
trace_id: 5608455869004355214

Scan 6414587

duration: 0:00:11.745064

exit_message:

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

id: 6414587

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_listing_avail_photo/2026-04-16/1776316291",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-16/1776316291/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18222922039187661955,
        "service_name": "sparefoot",
        "span_id": 12986406154517705692,
        "trace_id": 18222922039187661955
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-16 00:11:46
success: True
trace_id: 18222922039187661955

Scan 6414064

duration: 0:00:11.676723

exit_message:

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

id: 6414064

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_listing_avail_photo/2026-04-15/1776229656",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-15/1776229656/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16515083315601470792,
        "service_name": "sparefoot",
        "span_id": 781584164833904746,
        "trace_id": 16515083315601470792
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-15 00:07:40
success: True
trace_id: 16515083315601470792

Scan 6413580

duration: 0:00:14.528985

exit_message:

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

id: 6413580

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_listing_avail_photo/2026-04-14/1776143491",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-14/1776143491/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17002912883681644493,
        "service_name": "sparefoot",
        "span_id": 4978438752841938892,
        "trace_id": 17002912883681644493
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-14 00:11:38
success: True
trace_id: 17002912883681644493

Scan 6413003

duration: 0:00:14.363054

exit_message:

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

id: 6413003

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_listing_avail_photo/2026-04-13/1776057160",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-13/1776057160/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7133402827941722917,
        "service_name": "sparefoot",
        "span_id": 6096979525847376305,
        "trace_id": 7133402827941722917
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-13 00:13:00
success: True
trace_id: 7133402827941722917

Scan 6412650

duration: 0:00:14.396351

exit_message:

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

id: 6412650

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_listing_avail_photo/2026-04-12/1775970653",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-12/1775970653/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9792981283885531784,
        "service_name": "sparefoot",
        "span_id": 9526819777358577702,
        "trace_id": 9792981283885531784
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-12 00:11:08
success: True
trace_id: 9792981283885531784

Scan 6412266

duration: 0:00:11.622711

exit_message:

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

id: 6412266

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_listing_avail_photo/2026-04-11/1775884275",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-11/1775884275/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3954663790852615172,
        "service_name": "sparefoot",
        "span_id": 11341210631790517672,
        "trace_id": 3954663790852615172
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-11 00:11:18
success: True
trace_id: 3954663790852615172

Scan 6411738

duration: 0:00:14.244162

exit_message:

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

id: 6411738

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_listing_avail_photo/2026-04-10/1775797603",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-10/1775797603/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12127898635163318930,
        "service_name": "sparefoot",
        "span_id": 9872510696854269533,
        "trace_id": 12127898635163318930
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-10 00:06:53
success: True
trace_id: 12127898635163318930

Scan 6411237

duration: 0:00:14.226047

exit_message:

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

id: 6411237

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_listing_avail_photo/2026-04-09/1775711557",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-09/1775711557/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14384136405379319542,
        "service_name": "sparefoot",
        "span_id": 8172457430175628495,
        "trace_id": 14384136405379319542
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-09 00:12:44
success: True
trace_id: 14384136405379319542

Scan 6410769

duration: 0:00:11.787888

exit_message:

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

id: 6410769

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_listing_avail_photo/2026-04-08/1775625864",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-08/1775625864/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18282736163450848388,
        "service_name": "sparefoot",
        "span_id": 7461637394879252805,
        "trace_id": 18282736163450848388
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-08 00:24:37
success: True
trace_id: 18282736163450848388

Scan 6410251

duration: 0:00:11.930885

exit_message:

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

id: 6410251

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_listing_avail_photo/2026-04-07/1775538903",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-07/1775538903/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16336844745686852225,
        "service_name": "sparefoot",
        "span_id": 10191603010262295213,
        "trace_id": 16336844745686852225
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-07 00:15:10
success: True
trace_id: 16336844745686852225

Scan 6409662

duration: 0:00:11.685398

exit_message:

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

id: 6409662

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_listing_avail_photo/2026-04-06/1775451883",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-06/1775451883/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9451619653336792584,
        "service_name": "sparefoot",
        "span_id": 10763652989233829750,
        "trace_id": 9451619653336792584
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-06 00:04:48
success: True
trace_id: 9451619653336792584

Scan 6409316

duration: 0:00:14.284594

exit_message:

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

id: 6409316

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_listing_avail_photo/2026-04-05/1775365758",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-05/1775365758/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15352648236800907691,
        "service_name": "sparefoot",
        "span_id": 4911419222384647658,
        "trace_id": 15352648236800907691
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-05 00:09:27
success: True
trace_id: 15352648236800907691

Scan 6408916

duration: 0:00:11.753668

exit_message:

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

id: 6408916

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_listing_avail_photo/2026-04-04/1775279257",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-04/1775279257/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14721084934195858007,
        "service_name": "sparefoot",
        "span_id": 17896480014126518458,
        "trace_id": 14721084934195858007
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-04 00:07:40
success: True
trace_id: 14721084934195858007

Scan 6408454

duration: 0:00:14.537572

exit_message:

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

id: 6408454

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_listing_avail_photo/2026-04-03/1775193151",
        "key": "raw/sparefoot_listing_avail_photo/2026-04-03/1775193151/listing_avail_photo_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14878400318226624351,
        "service_name": "sparefoot",
        "span_id": 6293463839833059497,
        "trace_id": 14878400318226624351
    }
}

running: False
schema_name_id: 1406
start_time: 2026-04-03 00:12:39
success: True
trace_id: 14878400318226624351

Partitions:

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

Schema:

attributes:

{
    "listing_avail_id": "int",
    "listing_avail_photo_id": "int",
    "md5_chksum": "string",
    "picture_filename": "string",
    "picture_num": "int",
    "picture_timestamp": "timestamp"
}

created: 2026-04-17 00:20:26

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_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-17/1776403222'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
}

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 12:21:21",
        "disabled": false,
        "format": "raw",
        "id": 1406,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_listing_avail_photo"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "listing_avail_id": "int",
            "listing_avail_photo_id": "int",
            "md5_chksum": "string",
            "picture_filename": "string",
            "picture_num": "int",
            "picture_timestamp": "timestamp"
        },
        "created": "2026-04-17 00:20:26",
        "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_listing_avail_photo`\n(\n `listing_avail_id`  int , `listing_avail_photo_id`  int , `md5_chksum`  string , `picture_filename`  string , `picture_num`  int , `picture_timestamp`  timestamp \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_listing_avail_photo/2026-04-17/1776403222'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_listing_avail_photo"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}