Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_listing_avail_photo

created: 2022-08-18 17:22:52
disabled: False
format: raw
id: 1122
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718381

created: 2026-04-17 14:12:47

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-17/1776453163
id: 1718381
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: 1122
schema_scan_id: 162193981
updated: 2026-04-17 14:12:59

Version 1718195

created: 2026-04-17 09:18:24

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-17/1776435500
id: 1718195
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: 1122
schema_scan_id: 162178281
updated: 2026-04-17 09:18:38

Version 1717461

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-17/1776402635
id: 1717461
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: 1122
schema_scan_id: 162163619
updated: 2026-04-17 00:13:21

Version 1717348

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-16/1776388888
id: 1717348
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: 1122
schema_scan_id: 162156144
updated: 2026-04-16 20:24:21

Version 1717180

created: 2026-04-16 14:18:33

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-16/1776367101
id: 1717180
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: 1122
schema_scan_id: 162138125
updated: 2026-04-16 14:18:47

Version 1716974

created: 2026-04-16 09:09:12

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-16/1776348545
id: 1716974
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: 1122
schema_scan_id: 162122495
updated: 2026-04-16 09:09:24

Version 1716201

created: 2026-04-16 00:08:33

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-16/1776316109
id: 1716201
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: 1122
schema_scan_id: 162107776
updated: 2026-04-16 00:08:47

Version 1716091

created: 2026-04-15 20:19:28

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-15/1776302349
id: 1716091
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: 1122
schema_scan_id: 162100299
updated: 2026-04-15 20:19:39

Version 1715952

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-15/1776280281
id: 1715952
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: 1122
schema_scan_id: 162081678
updated: 2026-04-15 14:12:12

Version 1715770

created: 2026-04-15 08:42:30

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-15/1776260542
id: 1715770
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: 1122
schema_scan_id: 162064496
updated: 2026-04-15 08:42:41

Version 1715026

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-15/1776230235
id: 1715026
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: 1122
schema_scan_id: 162051992
updated: 2026-04-15 00:17:36

Version 1714906

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-14/1776216040
id: 1714906
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: 1122
schema_scan_id: 162044309
updated: 2026-04-14 20:20:55

Version 1714716

created: 2026-04-14 14:13:15

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-14/1776193991
id: 1714716
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: 1122
schema_scan_id: 162026094
updated: 2026-04-14 14:13:29

Version 1714558

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-14/1776175169
id: 1714558
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: 1122
schema_scan_id: 162010391
updated: 2026-04-14 09:01:01

Version 1713815

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_listing_avail_photo/2026-04-14/1776143597
id: 1713815
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: 1122
schema_scan_id: 161996354
updated: 2026-04-14 00:13:33

Schema Scans: 15

Last at 2026-04-17 14:12:47

Scan 162193981

duration: 0:00:11.648245

exit_message:

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

id: 162193981

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

running: False
schema_name_id: 1122
start_time: 2026-04-17 14:12:47
success: True
trace_id: 15920631848624144959

Scan 162178281

duration: 0:00:14.616824

exit_message:

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

id: 162178281

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

running: False
schema_name_id: 1122
start_time: 2026-04-17 09:18:24
success: True
trace_id: 7091536936860648725

Scan 162163619

duration: 0:00:11.861694

exit_message:

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

id: 162163619

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

running: False
schema_name_id: 1122
start_time: 2026-04-17 00:13:09
success: True
trace_id: 10802372565890417075

Scan 162156144

duration: 0:00:11.766560

exit_message:

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

id: 162156144

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

running: False
schema_name_id: 1122
start_time: 2026-04-16 20:24:09
success: True
trace_id: 12830845334649134071

Scan 162138125

duration: 0:00:14.270035

exit_message:

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

id: 162138125

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

running: False
schema_name_id: 1122
start_time: 2026-04-16 14:18:33
success: True
trace_id: 17500530854113466991

Scan 162122495

duration: 0:00:11.770644

exit_message:

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

id: 162122495

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

running: False
schema_name_id: 1122
start_time: 2026-04-16 09:09:12
success: True
trace_id: 9304902083879485320

Scan 162107776

duration: 0:00:14.217953

exit_message:

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

id: 162107776

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

running: False
schema_name_id: 1122
start_time: 2026-04-16 00:08:33
success: True
trace_id: 18086648851248129900

Scan 162100299

duration: 0:00:11.686859

exit_message:

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

id: 162100299

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

running: False
schema_name_id: 1122
start_time: 2026-04-15 20:19:27
success: True
trace_id: 10186679991855070615

Scan 162081678

duration: 0:00:14.458852

exit_message:

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

id: 162081678

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

running: False
schema_name_id: 1122
start_time: 2026-04-15 14:11:57
success: True
trace_id: 7815658299958064320

Scan 162064496

duration: 0:00:11.618388

exit_message:

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

id: 162064496

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

running: False
schema_name_id: 1122
start_time: 2026-04-15 08:42:29
success: True
trace_id: 7725062111461914881

Scan 162051992

duration: 0:00:11.718510

exit_message:

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

id: 162051992

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

running: False
schema_name_id: 1122
start_time: 2026-04-15 00:17:24
success: True
trace_id: 17613369877926840392

Scan 162044309

duration: 0:00:11.615604

exit_message:

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

id: 162044309

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

running: False
schema_name_id: 1122
start_time: 2026-04-14 20:20:43
success: True
trace_id: 8341878546759211801

Scan 162026094

duration: 0:00:14.354895

exit_message:

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

id: 162026094

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

running: False
schema_name_id: 1122
start_time: 2026-04-14 14:13:14
success: True
trace_id: 12950600625420959375

Scan 162010391

duration: 0:00:11.933045

exit_message:

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

id: 162010391

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

running: False
schema_name_id: 1122
start_time: 2026-04-14 09:00:49
success: True
trace_id: 1432636538983111133

Scan 161996354

duration: 0:00:11.594506

exit_message:

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

id: 161996354

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

running: False
schema_name_id: 1122
start_time: 2026-04-14 00:13:21
success: True
trace_id: 10912753787696178267

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 14:12:47

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

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