Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookchecklists
- created: 2024-10-08 17:46:57
- disabled: False
- format: raw
- id: 2546
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookchecklists" } - type: drivethrucsv
Schema Versions: 15
-
Version 4748264
- created: 2024-11-05 22:40:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-05/1730866404'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-05/1730866404
- id: 4748264
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6674296
- updated: 2024-11-05 22:40:21
-
Version 4747892
- created: 2024-11-05 22:28:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-05/1730866331'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-05/1730866331
- id: 4747892
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6673925
- updated: 2024-11-05 22:28:55
-
Version 4747412
- created: 2024-11-05 22:15:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-05/1730866249'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-05/1730866249
- id: 4747412
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6673444
- updated: 2024-11-05 22:16:05
-
Version 4746204
- created: 2024-11-05 03:53:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-04/1730785094'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-04/1730785094
- id: 4746204
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6671425
- updated: 2024-11-05 03:53:11
-
Version 4746005
- created: 2024-11-05 03:45:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-04/1730785668'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-04/1730785668
- id: 4746005
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6671226
- updated: 2024-11-05 03:45:59
-
Version 4745122
- created: 2024-11-05 03:21:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-04/1730784788'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-04/1730784788
- id: 4745122
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6670339
- updated: 2024-11-05 03:21:23
-
Version 4744380
- created: 2024-11-05 03:01:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-04/1730784185'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-04/1730784185
- id: 4744380
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6669597
- updated: 2024-11-05 03:01:40
-
Version 4743720
- created: 2024-11-05 02:44:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-04/1730784022'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-04/1730784022
- id: 4743720
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6668937
- updated: 2024-11-05 02:44:17
-
Version 4743118
- created: 2024-11-05 02:28:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-04/1730783875'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-04/1730783875
- id: 4743118
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6668335
- updated: 2024-11-05 02:28:19
-
Version 4742247
- created: 2024-11-05 02:05:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-04/1730783735'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-04/1730783735
- id: 4742247
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6667464
- updated: 2024-11-05 02:05:18
-
Version 4741249
- created: 2024-11-05 01:38:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-04/1730783641'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-04/1730783641
- id: 4741249
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6666466
- updated: 2024-11-05 01:38:51
-
Version 4741002
- created: 2024-11-05 01:32:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-04/1730783491'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-04/1730783491
- id: 4741002
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6666219
- updated: 2024-11-05 01:32:23
-
Version 4739857
- created: 2024-11-05 01:01:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-04/1730783272'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-04/1730783272
- id: 4739857
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6665074
- updated: 2024-11-05 01:02:01
-
Version 4739132
- created: 2024-11-05 00:42:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-04/1730782875'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-04/1730782875
- id: 4739132
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6664347
- updated: 2024-11-05 00:42:52
-
Version 4738874
- created: 2024-11-05 00:35:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-04/1730782781'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookchecklists/2024-11-04/1730782781
- id: 4738874
- processed: 1
- raw_data:
{ "action_id": 3, "active": 4, "id": 2, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2546
- schema_scan_id: 6664087
- updated: 2024-11-05 00:36:05
Schema Scans: 15
Last at 2024-11-05 22:40:07
-
Scan 6674296
- duration: 0:00:14.030060
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674296
- 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_newbookchecklists/2024-11-05/1730866404", "key": "raw/newbookdev_newbookchecklists/2024-11-05/1730866404/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1850492511090372739, "service_name": "drive-thru", "span_id": 8868863043531493088, "trace_id": 327507654037975661 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 22:40:07
- success: True
- trace_id: 327507654037975661
-
Scan 6673925
- duration: 0:00:11.369220
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673925
- 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_newbookchecklists/2024-11-05/1730866331", "key": "raw/newbookdev_newbookchecklists/2024-11-05/1730866331/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1496810508390426522, "service_name": "drive-thru", "span_id": 6305803841423108122, "trace_id": 4046664053222966854 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 22:28:44
- success: True
- trace_id: 4046664053222966854
-
Scan 6673444
- duration: 0:00:11.451414
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673444
- 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_newbookchecklists/2024-11-05/1730866249", "key": "raw/newbookdev_newbookchecklists/2024-11-05/1730866249/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13530931521491550756, "service_name": "drive-thru", "span_id": 3648885160483195000, "trace_id": 3698447861470325853 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 22:15:54
- success: True
- trace_id: 3698447861470325853
-
Scan 6671425
- duration: 0:00:11.761849
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671425
- 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_newbookchecklists/2024-11-04/1730785094", "key": "raw/newbookdev_newbookchecklists/2024-11-04/1730785094/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11627969528674204626, "service_name": "drive-thru", "span_id": 14138959149528188596, "trace_id": 3684343690640194692 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 03:52:59
- success: True
- trace_id: 3684343690640194692
-
Scan 6671226
- duration: 0:00:11.457851
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671226
- 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_newbookchecklists/2024-11-04/1730785668", "key": "raw/newbookdev_newbookchecklists/2024-11-04/1730785668/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15529745752418704365, "service_name": "drive-thru", "span_id": 8366653841353785497, "trace_id": 4341674470992822002 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 03:45:48
- success: True
- trace_id: 4341674470992822002
-
Scan 6670339
- duration: 0:00:11.349707
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670339
- 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_newbookchecklists/2024-11-04/1730784788", "key": "raw/newbookdev_newbookchecklists/2024-11-04/1730784788/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10103086725598890494, "service_name": "drive-thru", "span_id": 2463624294436837727, "trace_id": 5387770464689216087 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 03:21:12
- success: True
- trace_id: 5387770464689216087
-
Scan 6669597
- duration: 0:00:13.859492
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669597
- 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_newbookchecklists/2024-11-04/1730784185", "key": "raw/newbookdev_newbookchecklists/2024-11-04/1730784185/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6512306115612098681, "service_name": "drive-thru", "span_id": 13764354298267890401, "trace_id": 9836244129278656165 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 03:01:26
- success: True
- trace_id: 9836244129278656165
-
Scan 6668937
- duration: 0:00:13.915991
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668937
- 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_newbookchecklists/2024-11-04/1730784022", "key": "raw/newbookdev_newbookchecklists/2024-11-04/1730784022/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9908875759597057829, "service_name": "drive-thru", "span_id": 1102836331206270665, "trace_id": 5086275179174635900 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 02:44:03
- success: True
- trace_id: 5086275179174635900
-
Scan 6668335
- duration: 0:00:11.294148
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668335
- 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_newbookchecklists/2024-11-04/1730783875", "key": "raw/newbookdev_newbookchecklists/2024-11-04/1730783875/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11491300864632717820, "service_name": "drive-thru", "span_id": 9106216487675112457, "trace_id": 16651512362360471780 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 02:28:08
- success: True
- trace_id: 16651512362360471780
-
Scan 6667464
- duration: 0:00:13.842944
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667464
- 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_newbookchecklists/2024-11-04/1730783735", "key": "raw/newbookdev_newbookchecklists/2024-11-04/1730783735/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2063417955578799092, "service_name": "drive-thru", "span_id": 9363643936271246162, "trace_id": 9065994436549728015 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 02:05:04
- success: True
- trace_id: 9065994436549728015
-
Scan 6666466
- duration: 0:00:11.345330
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666466
- 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_newbookchecklists/2024-11-04/1730783641", "key": "raw/newbookdev_newbookchecklists/2024-11-04/1730783641/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5598736790908090545, "service_name": "drive-thru", "span_id": 8312878036290860277, "trace_id": 5049147407887370720 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 01:38:40
- success: True
- trace_id: 5049147407887370720
-
Scan 6666219
- duration: 0:00:13.827446
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666219
- 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_newbookchecklists/2024-11-04/1730783491", "key": "raw/newbookdev_newbookchecklists/2024-11-04/1730783491/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15024276844053648553, "service_name": "drive-thru", "span_id": 16788047191569008694, "trace_id": 2244875773320260948 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 01:32:09
- success: True
- trace_id: 2244875773320260948
-
Scan 6665074
- duration: 0:00:13.893634
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665074
- 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_newbookchecklists/2024-11-04/1730783272", "key": "raw/newbookdev_newbookchecklists/2024-11-04/1730783272/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 909492800222169312, "service_name": "drive-thru", "span_id": 13509387714071632148, "trace_id": 16870733637472602368 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 01:01:47
- success: True
- trace_id: 16870733637472602368
-
Scan 6664347
- duration: 0:00:11.345328
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664347
- 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_newbookchecklists/2024-11-04/1730782875", "key": "raw/newbookdev_newbookchecklists/2024-11-04/1730782875/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15034845367326010968, "service_name": "drive-thru", "span_id": 3037804907234936595, "trace_id": 10523382715778543890 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 00:42:40
- success: True
- trace_id: 10523382715778543890
-
Scan 6664087
- duration: 0:00:11.309776
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664087
- 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_newbookchecklists/2024-11-04/1730782781", "key": "raw/newbookdev_newbookchecklists/2024-11-04/1730782781/checklists.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookchecklists", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18110609646133481029, "service_name": "drive-thru", "span_id": 3349043805090519145, "trace_id": 18240276214730678197 } } - running: False
- schema_name_id: 2546
- start_time: 2024-11-05 00:35:54
- success: True
- trace_id: 18240276214730678197
- attributes:
{ "action_id": "string", "active": "string", "id": "string", "newbook_region": "string", "tenant": "string" } - created: 2024-11-05 22:40:07
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-05/1730866404'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists" }
- 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 17:46:57",
"disabled": false,
"format": "raw",
"id": 2546,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookchecklists"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"action_id": "string",
"active": "string",
"id": "string",
"newbook_region": "string",
"tenant": "string"
},
"created": "2024-11-05 22:40:07",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookchecklists`\n(\n `newbook_region` string , `tenant` string , `id` string , `action_id` string , `active` 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_newbookchecklists/2024-11-05/1730866404'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookchecklists`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookchecklists"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}