Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookaccommodation_features

created: 2024-10-08 17:36:27
disabled: False
format: raw
id: 2403
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_drivethru",
    "table": "newbookdev_newbookaccommodation_features"
}

type: drivethrucsv

Schema Versions: 15

Version 4748047

created: 2024-11-05 22:33:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866346'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866346
id: 4748047
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6674079
updated: 2024-11-05 22:33:25

Version 4747548

created: 2024-11-05 22:19:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866284'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866284
id: 4747548
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6673580
updated: 2024-11-05 22:19:54

Version 4747371

created: 2024-11-05 22:14:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866224'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866224
id: 4747371
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6673403
updated: 2024-11-05 22:14:23

Version 4746617

created: 2024-11-05 04:12:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730785638'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730785638
id: 4746617
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6671840
updated: 2024-11-05 04:12:57

Version 4745889

created: 2024-11-05 03:42:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730785075'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730785075
id: 4745889
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6671108
updated: 2024-11-05 03:42:19

Version 4744991

created: 2024-11-05 03:17:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730784770'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730784770
id: 4744991
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6670208
updated: 2024-11-05 03:18:01

Version 4744247

created: 2024-11-05 02:57:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730784167'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730784167
id: 4744247
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6669465
updated: 2024-11-05 02:58:01

Version 4743877

created: 2024-11-05 02:48:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730784004'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730784004
id: 4743877
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6669094
updated: 2024-11-05 02:48:23

Version 4743136

created: 2024-11-05 02:28:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783861'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783861
id: 4743136
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6668354
updated: 2024-11-05 02:28:48

Version 4742337

created: 2024-11-05 02:07:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783717'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783717
id: 4742337
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6667554
updated: 2024-11-05 02:07:46

Version 4741752

created: 2024-11-05 01:51:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783627'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783627
id: 4741752
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6666969
updated: 2024-11-05 01:52:01

Version 4740712

created: 2024-11-05 01:24:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783473'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783473
id: 4740712
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6665929
updated: 2024-11-05 01:24:40

Version 4740111

created: 2024-11-05 01:08:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783254'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783254
id: 4740111
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6665328
updated: 2024-11-05 01:08:51

Version 4739173

created: 2024-11-05 00:43:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730782856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730782856
id: 4739173
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6664388
updated: 2024-11-05 00:43:52

Version 4738414

created: 2024-11-05 00:23:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730782738'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730782738
id: 4738414
processed: 1

raw_data:

{
    "id": 2,
    "name": 3,
    "newbook_online_icon": 4,
    "newbook_online_quantity": 5,
    "newbook_region": 0,
    "tenant": 1,
    "used_in_search": 6
}

schema_attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

schema_name_id: 2403
schema_scan_id: 6663627
updated: 2024-11-05 00:24:05

Schema Scans: 15

Last at 2024-11-05 22:33:13

Scan 6674079

duration: 0:00:11.579791

exit_message:

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

id: 6674079

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866346",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866346/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7502272275510559721,
        "service_name": "drive-thru",
        "span_id": 1194863149005301759,
        "trace_id": 4515192862702283887
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 22:33:13
success: True
trace_id: 4515192862702283887

Scan 6673580

duration: 0:00:11.522371

exit_message:

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

id: 6673580

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866284",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866284/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2644386901001334555,
        "service_name": "drive-thru",
        "span_id": 9065861974882008261,
        "trace_id": 7388113719532652444
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 22:19:42
success: True
trace_id: 7388113719532652444

Scan 6673403

duration: 0:00:14.112476

exit_message:

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

id: 6673403

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866224",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866224/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3817317676621852711,
        "service_name": "drive-thru",
        "span_id": 4893892980157553119,
        "trace_id": 7060704791651335595
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 22:14:09
success: True
trace_id: 7060704791651335595

Scan 6671840

duration: 0:00:14.113400

exit_message:

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

id: 6671840

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730785638",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-04/1730785638/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7062957205854869659,
        "service_name": "drive-thru",
        "span_id": 17100889454080904696,
        "trace_id": 7270709947567513211
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 04:12:43
success: True
trace_id: 7270709947567513211

Scan 6671108

duration: 0:00:14.104493

exit_message:

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

id: 6671108

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730785075",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-04/1730785075/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1002752362821030984,
        "service_name": "drive-thru",
        "span_id": 4257646349147272916,
        "trace_id": 867286217157392440
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 03:42:05
success: True
trace_id: 867286217157392440

Scan 6670208

duration: 0:00:11.512061

exit_message:

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

id: 6670208

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730784770",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-04/1730784770/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4438941136642184602,
        "service_name": "drive-thru",
        "span_id": 2213973987555430668,
        "trace_id": 12801751009694551965
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 03:17:49
success: True
trace_id: 12801751009694551965

Scan 6669465

duration: 0:00:11.426314

exit_message:

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

id: 6669465

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730784167",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-04/1730784167/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9841364992511935394,
        "service_name": "drive-thru",
        "span_id": 15120089263161314746,
        "trace_id": 14091030302947076567
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 02:57:49
success: True
trace_id: 14091030302947076567

Scan 6669094

duration: 0:00:11.548894

exit_message:

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

id: 6669094

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730784004",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-04/1730784004/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2495117922862110266,
        "service_name": "drive-thru",
        "span_id": 11083517469206204716,
        "trace_id": 2964206380086011305
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 02:48:12
success: True
trace_id: 2964206380086011305

Scan 6668354

duration: 0:00:11.434747

exit_message:

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

id: 6668354

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783861",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783861/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11818954872028701728,
        "service_name": "drive-thru",
        "span_id": 2232688970258649957,
        "trace_id": 1015843586594646291
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 02:28:36
success: True
trace_id: 1015843586594646291

Scan 6667554

duration: 0:00:13.993166

exit_message:

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

id: 6667554

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783717",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783717/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6907629861212305232,
        "service_name": "drive-thru",
        "span_id": 15724214187832348880,
        "trace_id": 225663564358132976
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 02:07:32
success: True
trace_id: 225663564358132976

Scan 6666969

duration: 0:00:13.842836

exit_message:

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

id: 6666969

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783627",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783627/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3384575927195761401,
        "service_name": "drive-thru",
        "span_id": 1426424028758662942,
        "trace_id": 16372273879243353207
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 01:51:47
success: True
trace_id: 16372273879243353207

Scan 6665929

duration: 0:00:11.427284

exit_message:

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

id: 6665929

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783473",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783473/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13764632371658229972,
        "service_name": "drive-thru",
        "span_id": 1356201860842353445,
        "trace_id": 9235591343692273409
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 01:24:29
success: True
trace_id: 9235591343692273409

Scan 6665328

duration: 0:00:11.415426

exit_message:

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

id: 6665328

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783254",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-04/1730783254/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 63152766829932190,
        "service_name": "drive-thru",
        "span_id": 4859942421552783349,
        "trace_id": 7133285680753543884
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 01:08:40
success: True
trace_id: 7133285680753543884

Scan 6664388

duration: 0:00:11.375757

exit_message:

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

id: 6664388

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730782856",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-04/1730782856/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3800833853027685666,
        "service_name": "drive-thru",
        "span_id": 2214281815807334066,
        "trace_id": 246732919567578931
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 00:43:40
success: True
trace_id: 246732919567578931

Scan 6663627

duration: 0:00:13.870326

exit_message:

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

id: 6663627

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-04/1730782738",
        "key": "raw/newbookdev_newbookaccommodation_features/2024-11-04/1730782738/accommodation_features.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccommodation_features",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9270660277308553137,
        "service_name": "drive-thru",
        "span_id": 12971801352446280002,
        "trace_id": 15410909908560544690
    }
}

running: False
schema_name_id: 2403
start_time: 2024-11-05 00:23:51
success: True
trace_id: 15410909908560544690

Partitions:

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

Schema:

attributes:

{
    "id": "string",
    "name": "string",
    "newbook_online_icon": "string",
    "newbook_online_quantity": "string",
    "newbook_region": "string",
    "tenant": "string",
    "used_in_search": "string"
}

created: 2024-11-05 22:33:14

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866346'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-10-08 17:36:27",
        "disabled": false,
        "format": "raw",
        "id": 2403,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookaccommodation_features"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "id": "string",
            "name": "string",
            "newbook_online_icon": "string",
            "newbook_online_quantity": "string",
            "newbook_region": "string",
            "tenant": "string",
            "used_in_search": "string"
        },
        "created": "2024-11-05 22:33:14",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `newbook_online_icon`  string , `newbook_online_quantity`  string , `used_in_search`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccommodation_features/2024-11-05/1730866346'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccommodation_features`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccommodation_features"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}