Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration
- created: 2024-10-08 18:22:04
- disabled: False
- format: raw
- id: 2933
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookpage_column_configuration" } - type: drivethrucsv
Schema Versions: 15
-
Version 4749364
- created: 2024-11-05 23:42:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-05/1730866577'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-05/1730866577
- id: 4749364
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6675398
- updated: 2024-11-05 23:42:54
-
Version 4749063
- created: 2024-11-05 23:17:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-05/1730866519'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-05/1730866519
- id: 4749063
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6675095
- updated: 2024-11-05 23:17:46
-
Version 4748212
- created: 2024-11-05 22:38:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-05/1730866392'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-05/1730866392
- id: 4748212
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6674244
- updated: 2024-11-05 22:38:28
-
Version 4747056
- created: 2024-11-05 04:45:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-04/1730785774'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730785774
- id: 4747056
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6672288
- updated: 2024-11-05 04:45:53
-
Version 4746378
- created: 2024-11-05 04:00:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-04/1730785154'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730785154
- id: 4746378
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6671599
- updated: 2024-11-05 04:00:40
-
Version 4744945
- created: 2024-11-05 03:16:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-04/1730784849'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730784849
- id: 4744945
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6670162
- updated: 2024-11-05 03:16:47
-
Version 4744860
- created: 2024-11-05 03:14:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-04/1730784246'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730784246
- id: 4744860
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6670077
- updated: 2024-11-05 03:14:30
-
Version 4744578
- created: 2024-11-05 03:06:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-04/1730784083'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730784083
- id: 4744578
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6669795
- updated: 2024-11-05 03:07:03
-
Version 4743679
- created: 2024-11-05 02:43:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-04/1730783921'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783921
- id: 4743679
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6668896
- updated: 2024-11-05 02:43:11
-
Version 4742860
- created: 2024-11-05 02:21:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-04/1730783797'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783797
- id: 4742860
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6668077
- updated: 2024-11-05 02:21:31
-
Version 4741895
- created: 2024-11-05 01:55:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-04/1730783687'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783687
- id: 4741895
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6667112
- updated: 2024-11-05 01:55:48
-
Version 4741264
- created: 2024-11-05 01:39:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-04/1730783554'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783554
- id: 4741264
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6666481
- updated: 2024-11-05 01:39:18
-
Version 4740423
- created: 2024-11-05 01:16:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-04/1730783335'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783335
- id: 4740423
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6665640
- updated: 2024-11-05 01:17:09
-
Version 4740084
- created: 2024-11-05 01:07:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-04/1730782967'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730782967
- id: 4740084
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6665301
- updated: 2024-11-05 01:08:12
-
Version 4738964
- created: 2024-11-05 00:38:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-04/1730782827'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730782827
- id: 4738964
- processed: 1
- raw_data:
{ "action_id": 4, "id": 2, "interface": 5, "key": 6, "newbook_region": 0, "tenant": 1, "user_id": 3, "value": 7 } - schema_attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - schema_name_id: 2933
- schema_scan_id: 6664178
- updated: 2024-11-05 00:38:27
Schema Scans: 15
Last at 2024-11-05 23:42:43
-
Scan 6675398
- duration: 0:00:11.649552
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675398
- 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_newbookpage_column_configuration/2024-11-05/1730866577", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-05/1730866577/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4951945496110798722, "service_name": "drive-thru", "span_id": 2914821749916539308, "trace_id": 6090913616273385793 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 23:42:43
- success: True
- trace_id: 6090913616273385793
-
Scan 6675095
- duration: 0:00:14.124014
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675095
- 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_newbookpage_column_configuration/2024-11-05/1730866519", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-05/1730866519/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3342272937640063781, "service_name": "drive-thru", "span_id": 14937255868758666687, "trace_id": 6549087419141673069 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 23:17:32
- success: True
- trace_id: 6549087419141673069
-
Scan 6674244
- duration: 0:00:11.548511
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674244
- 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_newbookpage_column_configuration/2024-11-05/1730866392", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-05/1730866392/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3663121706678028334, "service_name": "drive-thru", "span_id": 13954124758675461381, "trace_id": 1291129420372408982 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 22:38:16
- success: True
- trace_id: 1291129420372408982
-
Scan 6672288
- duration: 0:00:11.628454
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6672288
- 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_newbookpage_column_configuration/2024-11-04/1730785774", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730785774/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2656889096048256196, "service_name": "drive-thru", "span_id": 7772572209246979763, "trace_id": 4716591765036055200 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 04:45:41
- success: True
- trace_id: 4716591765036055200
-
Scan 6671599
- duration: 0:00:11.597454
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671599
- 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_newbookpage_column_configuration/2024-11-04/1730785154", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730785154/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4916540657039976764, "service_name": "drive-thru", "span_id": 6599188638266364503, "trace_id": 12673274469647678496 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 04:00:28
- success: True
- trace_id: 12673274469647678496
-
Scan 6670162
- duration: 0:00:11.491447
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670162
- 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_newbookpage_column_configuration/2024-11-04/1730784849", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730784849/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10585962618295967341, "service_name": "drive-thru", "span_id": 10843464006418873963, "trace_id": 13314776947550392899 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 03:16:36
- success: True
- trace_id: 13314776947550392899
-
Scan 6670077
- duration: 0:00:13.917163
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670077
- 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_newbookpage_column_configuration/2024-11-04/1730784246", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730784246/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17716445027622603654, "service_name": "drive-thru", "span_id": 11132083557654801931, "trace_id": 8644383144444283434 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 03:14:16
- success: True
- trace_id: 8644383144444283434
-
Scan 6669795
- duration: 0:00:13.963805
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669795
- 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_newbookpage_column_configuration/2024-11-04/1730784083", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730784083/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6289618420958583407, "service_name": "drive-thru", "span_id": 5950491220721226731, "trace_id": 1231780964140500177 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 03:06:50
- success: True
- trace_id: 1231780964140500177
-
Scan 6668896
- duration: 0:00:11.683534
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668896
- 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_newbookpage_column_configuration/2024-11-04/1730783921", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783921/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17759373998467335221, "service_name": "drive-thru", "span_id": 14814160957166884348, "trace_id": 4263395216790680843 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 02:43:00
- success: True
- trace_id: 4263395216790680843
-
Scan 6668077
- duration: 0:00:11.638564
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668077
- 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_newbookpage_column_configuration/2024-11-04/1730783797", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783797/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11318764312779911499, "service_name": "drive-thru", "span_id": 16823934637320655644, "trace_id": 7754307454324687110 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 02:21:19
- success: True
- trace_id: 7754307454324687110
-
Scan 6667112
- duration: 0:00:11.479005
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667112
- 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_newbookpage_column_configuration/2024-11-04/1730783687", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783687/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15394334121801147124, "service_name": "drive-thru", "span_id": 6010502558900462608, "trace_id": 15296617728992636004 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 01:55:36
- success: True
- trace_id: 15296617728992636004
-
Scan 6666481
- duration: 0:00:13.909233
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666481
- 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_newbookpage_column_configuration/2024-11-04/1730783554", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783554/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13335642811701008414, "service_name": "drive-thru", "span_id": 13142905676694958037, "trace_id": 6821959300194290156 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 01:39:04
- success: True
- trace_id: 6821959300194290156
-
Scan 6665640
- duration: 0:00:13.949289
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665640
- 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_newbookpage_column_configuration/2024-11-04/1730783335", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783335/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14815987385426308325, "service_name": "drive-thru", "span_id": 14048512863628704558, "trace_id": 15068183085994487637 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 01:16:55
- success: True
- trace_id: 15068183085994487637
-
Scan 6665301
- duration: 0:00:14.031445
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665301
- 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_newbookpage_column_configuration/2024-11-04/1730782967", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730782967/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5519343585527388365, "service_name": "drive-thru", "span_id": 18005545414990122007, "trace_id": 8801656660562777857 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 01:07:58
- success: True
- trace_id: 8801656660562777857
-
Scan 6664178
- duration: 0:00:11.492181
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664178
- 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_newbookpage_column_configuration/2024-11-04/1730782827", "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730782827/page_column_configuration.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7012296377416804651, "service_name": "drive-thru", "span_id": 11190691207532732733, "trace_id": 14967098925527899019 } } - running: False
- schema_name_id: 2933
- start_time: 2024-11-05 00:38:15
- success: True
- trace_id: 14967098925527899019
- attributes:
{ "action_id": "string", "id": "string", "interface": "string", "key": "string", "newbook_region": "string", "tenant": "string", "user_id": "string", "value": "string" } - created: 2024-11-05 23:42:43
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-05/1730866577'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2024-10-08 18:22:04",
"disabled": false,
"format": "raw",
"id": 2933,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookpage_column_configuration"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"action_id": "string",
"id": "string",
"interface": "string",
"key": "string",
"newbook_region": "string",
"tenant": "string",
"user_id": "string",
"value": "string"
},
"created": "2024-11-05 23:42:43",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `action_id` string , `interface` string , `key` string , `value` 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_newbookpage_column_configuration/2024-11-05/1730866577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}