Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_search_weights

created: 2022-08-12 10:58:24
disabled: False
format: raw
id: 1385
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906540

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-17/1776402936'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-17/1776402936
id: 906540
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6415108
updated: 2026-04-17 00:16:20

Version 906336

created: 2026-04-16 00:10:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-16/1776316189'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-16/1776316189
id: 906336
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6414571
updated: 2026-04-16 00:10:18

Version 906139

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-15/1776230849'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-15/1776230849
id: 906139
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6414104
updated: 2026-04-15 00:27:56

Version 905929

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-14/1776143593'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-14/1776143593
id: 905929
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6413597
updated: 2026-04-14 00:13:33

Version 905668

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-13/1776057130'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-13/1776057130
id: 905668
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6412999
updated: 2026-04-13 00:12:28

Version 905487

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-12/1775970537'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-12/1775970537
id: 905487
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6412638
updated: 2026-04-12 00:09:22

Version 905297

created: 2026-04-11 00:11:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-11/1775884289'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-11/1775884289
id: 905297
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6412269
updated: 2026-04-11 00:11:53

Version 905077

created: 2026-04-10 00:09:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-10/1775797790'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-10/1775797790
id: 905077
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6411759
updated: 2026-04-10 00:10:07

Version 904836

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-09/1775711436'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-09/1775711436
id: 904836
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6411220
updated: 2026-04-09 00:10:56

Version 904642

created: 2026-04-08 00:08:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-08/1775624912'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-08/1775624912
id: 904642
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6410737
updated: 2026-04-08 00:08:49

Version 904441

created: 2026-04-07 00:12:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-07/1775538761'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-07/1775538761
id: 904441
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6410245
updated: 2026-04-07 00:13:09

Version 904195

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-06/1775451883'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

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

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6409667
updated: 2026-04-06 00:05:15

Version 904014

created: 2026-04-05 00:08:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-05/1775365726'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-05/1775365726
id: 904014
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6409308
updated: 2026-04-05 00:09:08

Version 903835

created: 2026-04-04 00:12:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-04/1775279533'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-04/1775279533
id: 903835
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6408952
updated: 2026-04-04 00:12:34

Version 903586

created: 2026-04-03 00:07:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-03/1775192849'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-03/1775192849
id: 903586
processed: 1

raw_data:

{
    "active": "int16",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int32",
    "search_weight_test_id": "int32",
    "yield_multiplier": "double"
}

schema_attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

schema_name_id: 1385
schema_scan_id: 6408419
updated: 2026-04-03 00:07:44

Schema Scans: 15

Last at 2026-04-17 00:16:08

Scan 6415108

duration: 0:00:11.781232

exit_message:

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

id: 6415108

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_search_weights/2026-04-17/1776402936",
        "key": "raw/sparefoot_search_weights/2026-04-17/1776402936/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15320616345379770169,
        "service_name": "sparefoot",
        "span_id": 3541430323459534775,
        "trace_id": 15320616345379770169
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-17 00:16:08
success: True
trace_id: 15320616345379770169

Scan 6414571

duration: 0:00:14.214068

exit_message:

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

id: 6414571

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_search_weights/2026-04-16/1776316189",
        "key": "raw/sparefoot_search_weights/2026-04-16/1776316189/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12736620547878717725,
        "service_name": "sparefoot",
        "span_id": 14589040443874091531,
        "trace_id": 12736620547878717725
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-16 00:10:04
success: True
trace_id: 12736620547878717725

Scan 6414104

duration: 0:00:11.733985

exit_message:

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

id: 6414104

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_search_weights/2026-04-15/1776230849",
        "key": "raw/sparefoot_search_weights/2026-04-15/1776230849/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4049824402878025984,
        "service_name": "sparefoot",
        "span_id": 10690119112114138319,
        "trace_id": 4049824402878025984
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-15 00:27:44
success: True
trace_id: 4049824402878025984

Scan 6413597

duration: 0:00:11.790754

exit_message:

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

id: 6413597

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_search_weights/2026-04-14/1776143593",
        "key": "raw/sparefoot_search_weights/2026-04-14/1776143593/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11908494464498590829,
        "service_name": "sparefoot",
        "span_id": 6645575166137009737,
        "trace_id": 11908494464498590829
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-14 00:13:21
success: True
trace_id: 11908494464498590829

Scan 6412999

duration: 0:00:14.428066

exit_message:

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

id: 6412999

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_search_weights/2026-04-13/1776057130",
        "key": "raw/sparefoot_search_weights/2026-04-13/1776057130/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8371383668679645478,
        "service_name": "sparefoot",
        "span_id": 9641330455816103839,
        "trace_id": 8371383668679645478
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-13 00:12:13
success: True
trace_id: 8371383668679645478

Scan 6412638

duration: 0:00:14.192009

exit_message:

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

id: 6412638

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_search_weights/2026-04-12/1775970537",
        "key": "raw/sparefoot_search_weights/2026-04-12/1775970537/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18093724678698405911,
        "service_name": "sparefoot",
        "span_id": 9564844115285499188,
        "trace_id": 18093724678698405911
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-12 00:09:08
success: True
trace_id: 18093724678698405911

Scan 6412269

duration: 0:00:14.370940

exit_message:

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

id: 6412269

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_search_weights/2026-04-11/1775884289",
        "key": "raw/sparefoot_search_weights/2026-04-11/1775884289/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9145487185920120535,
        "service_name": "sparefoot",
        "span_id": 8478943428076171461,
        "trace_id": 9145487185920120535
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-11 00:11:38
success: True
trace_id: 9145487185920120535

Scan 6411759

duration: 0:00:14.213983

exit_message:

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

id: 6411759

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_search_weights/2026-04-10/1775797790",
        "key": "raw/sparefoot_search_weights/2026-04-10/1775797790/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9452058373268901011,
        "service_name": "sparefoot",
        "span_id": 647562934886206920,
        "trace_id": 9452058373268901011
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-10 00:09:53
success: True
trace_id: 9452058373268901011

Scan 6411220

duration: 0:00:11.741097

exit_message:

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

id: 6411220

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_search_weights/2026-04-09/1775711436",
        "key": "raw/sparefoot_search_weights/2026-04-09/1775711436/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6526103483453291325,
        "service_name": "sparefoot",
        "span_id": 16534460362359964895,
        "trace_id": 6526103483453291325
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-09 00:10:45
success: True
trace_id: 6526103483453291325

Scan 6410737

duration: 0:00:14.280628

exit_message:

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

id: 6410737

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_search_weights/2026-04-08/1775624912",
        "key": "raw/sparefoot_search_weights/2026-04-08/1775624912/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11131198304325664144,
        "service_name": "sparefoot",
        "span_id": 4684221244177105195,
        "trace_id": 11131198304325664144
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-08 00:08:34
success: True
trace_id: 11131198304325664144

Scan 6410245

duration: 0:00:14.233044

exit_message:

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

id: 6410245

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_search_weights/2026-04-07/1775538761",
        "key": "raw/sparefoot_search_weights/2026-04-07/1775538761/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16962918836752160141,
        "service_name": "sparefoot",
        "span_id": 2020776091596656304,
        "trace_id": 16962918836752160141
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-07 00:12:54
success: True
trace_id: 16962918836752160141

Scan 6409667

duration: 0:00:11.904183

exit_message:

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

id: 6409667

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_search_weights/2026-04-06/1775451883",
        "key": "raw/sparefoot_search_weights/2026-04-06/1775451883/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6523765268077135683,
        "service_name": "sparefoot",
        "span_id": 8205213554475385855,
        "trace_id": 6523765268077135683
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-06 00:05:03
success: True
trace_id: 6523765268077135683

Scan 6409308

duration: 0:00:11.793133

exit_message:

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

id: 6409308

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_search_weights/2026-04-05/1775365726",
        "key": "raw/sparefoot_search_weights/2026-04-05/1775365726/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15653687591792134547,
        "service_name": "sparefoot",
        "span_id": 15850521620708245198,
        "trace_id": 15653687591792134547
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-05 00:08:57
success: True
trace_id: 15653687591792134547

Scan 6408952

duration: 0:00:11.641495

exit_message:

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

id: 6408952

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_search_weights/2026-04-04/1775279533",
        "key": "raw/sparefoot_search_weights/2026-04-04/1775279533/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7178215848240778854,
        "service_name": "sparefoot",
        "span_id": 1522892252869765985,
        "trace_id": 7178215848240778854
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-04 00:12:22
success: True
trace_id: 7178215848240778854

Scan 6408419

duration: 0:00:11.744236

exit_message:

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

id: 6408419

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_search_weights/2026-04-03/1775192849",
        "key": "raw/sparefoot_search_weights/2026-04-03/1775192849/search_weights.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_search_weights",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16153080797677981916,
        "service_name": "sparefoot",
        "span_id": 12458835518572894489,
        "trace_id": 16153080797677981916
    }
}

running: False
schema_name_id: 1385
start_time: 2026-04-03 00:07:32
success: True
trace_id: 16153080797677981916

Partitions:

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

Schema:

attributes:

{
    "active": "smallint",
    "algorithm": "string",
    "distance_multiplier": "double",
    "label": "string",
    "price_mulitplier": "double",
    "search_weight_id": "int",
    "search_weight_test_id": "int",
    "yield_multiplier": "double"
}

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

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_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-17/1776402936'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
}

Server:

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

Raw:

{
    "name": {
        "created": "2022-08-12 10:58:24",
        "disabled": false,
        "format": "raw",
        "id": 1385,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_search_weights"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "smallint",
            "algorithm": "string",
            "distance_multiplier": "double",
            "label": "string",
            "price_mulitplier": "double",
            "search_weight_id": "int",
            "search_weight_test_id": "int",
            "yield_multiplier": "double"
        },
        "created": "2026-04-17 00:16:08",
        "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_search_weights`\n(\n `active`  smallint , `algorithm`  string , `distance_multiplier`  double , `label`  string , `price_mulitplier`  double , `search_weight_id`  int , `search_weight_test_id`  int , `yield_multiplier`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-stage/raw/sparefoot_search_weights/2026-04-17/1776402936'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_search_weights`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_search_weights"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}