Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookcron_groups
- created: 2024-10-08 17:55:15
- disabled: False
- format: raw
- id: 2662
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookcron_groups" } - type: drivethrucsv
Schema Versions: 15
-
Version 4748420
- created: 2024-11-05 22:45:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-05/1730866443'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-05/1730866443
- id: 4748420
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6674452
- updated: 2024-11-05 22:45:49
-
Version 4748145
- created: 2024-11-05 22:36:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-05/1730866359'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-05/1730866359
- id: 4748145
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6674177
- updated: 2024-11-05 22:36:28
-
Version 4747526
- created: 2024-11-05 22:19:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-05/1730866265'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-05/1730866265
- id: 4747526
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6673559
- updated: 2024-11-05 22:19:25
-
Version 4746966
- created: 2024-11-05 04:36:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-04/1730785685'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730785685
- id: 4746966
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6672197
- updated: 2024-11-05 04:36:15
-
Version 4745532
- created: 2024-11-05 03:31:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-04/1730784799'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730784799
- id: 4745532
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6670749
- updated: 2024-11-05 03:32:06
-
Version 4745348
- created: 2024-11-05 03:27:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-04/1730785104'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730785104
- id: 4745348
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6670565
- updated: 2024-11-05 03:27:16
-
Version 4744622
- created: 2024-11-05 03:08:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-04/1730784195'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730784195
- id: 4744622
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6669838
- updated: 2024-11-05 03:08:11
-
Version 4743889
- created: 2024-11-05 02:48:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-04/1730784033'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730784033
- id: 4743889
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6669106
- updated: 2024-11-05 02:48:44
-
Version 4742895
- created: 2024-11-05 02:22:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-04/1730783838'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730783838
- id: 4742895
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6668112
- updated: 2024-11-05 02:22:26
-
Version 4742456
- created: 2024-11-05 02:10:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-04/1730783746'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730783746
- id: 4742456
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6667673
- updated: 2024-11-05 02:10:56
-
Version 4741910
- created: 2024-11-05 01:56:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-04/1730783648'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730783648
- id: 4741910
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6667127
- updated: 2024-11-05 01:56:13
-
Version 4740854
- created: 2024-11-05 01:28:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-04/1730783501'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730783501
- id: 4740854
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6666071
- updated: 2024-11-05 01:28:25
-
Version 4740167
- created: 2024-11-05 01:10:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-04/1730783283'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730783283
- id: 4740167
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6665384
- updated: 2024-11-05 01:10:22
-
Version 4739423
- created: 2024-11-05 00:50:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-04/1730782885'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730782885
- id: 4739423
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6664638
- updated: 2024-11-05 00:50:28
-
Version 4738954
- created: 2024-11-05 00:37:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-04/1730782789'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730782789
- id: 4738954
- processed: 1
- raw_data:
{ "active": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2662
- schema_scan_id: 6664168
- updated: 2024-11-05 00:38:12
Schema Scans: 15
Last at 2024-11-05 22:45:38
-
Scan 6674452
- duration: 0:00:11.453590
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674452
- 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_newbookcron_groups/2024-11-05/1730866443", "key": "raw/newbookdev_newbookcron_groups/2024-11-05/1730866443/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10202547156752889685, "service_name": "drive-thru", "span_id": 6003346034653314252, "trace_id": 15213388337891409019 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 22:45:38
- success: True
- trace_id: 15213388337891409019
-
Scan 6674177
- duration: 0:00:14.072753
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674177
- 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_newbookcron_groups/2024-11-05/1730866359", "key": "raw/newbookdev_newbookcron_groups/2024-11-05/1730866359/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11753370187474110620, "service_name": "drive-thru", "span_id": 9976621758584398550, "trace_id": 14571768262587622161 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 22:36:14
- success: True
- trace_id: 14571768262587622161
-
Scan 6673559
- duration: 0:00:13.943001
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673559
- 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_newbookcron_groups/2024-11-05/1730866265", "key": "raw/newbookdev_newbookcron_groups/2024-11-05/1730866265/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 904784488931449517, "service_name": "drive-thru", "span_id": 13713821019905119850, "trace_id": 4253407188841811800 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 22:19:11
- success: True
- trace_id: 4253407188841811800
-
Scan 6672197
- duration: 0:00:11.467062
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6672197
- 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_newbookcron_groups/2024-11-04/1730785685", "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730785685/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17919084176327438832, "service_name": "drive-thru", "span_id": 2700760431162194410, "trace_id": 8250959019862382069 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 04:36:03
- success: True
- trace_id: 8250959019862382069
-
Scan 6670749
- duration: 0:00:11.285960
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670749
- 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_newbookcron_groups/2024-11-04/1730784799", "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730784799/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 884732358057335571, "service_name": "drive-thru", "span_id": 2467589885176436266, "trace_id": 14582226826813001730 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 03:31:54
- success: True
- trace_id: 14582226826813001730
-
Scan 6670565
- duration: 0:00:11.384682
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670565
- 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_newbookcron_groups/2024-11-04/1730785104", "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730785104/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3895380340456262604, "service_name": "drive-thru", "span_id": 16195116364892398738, "trace_id": 6509607808683124129 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 03:27:04
- success: True
- trace_id: 6509607808683124129
-
Scan 6669838
- duration: 0:00:11.489148
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669838
- 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_newbookcron_groups/2024-11-04/1730784195", "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730784195/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2785938378903184120, "service_name": "drive-thru", "span_id": 1498425498535573373, "trace_id": 14197324315116471139 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 03:07:59
- success: True
- trace_id: 14197324315116471139
-
Scan 6669106
- duration: 0:00:11.276374
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669106
- 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_newbookcron_groups/2024-11-04/1730784033", "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730784033/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8902893435583625827, "service_name": "drive-thru", "span_id": 1425809463117641069, "trace_id": 16238532974906689213 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 02:48:33
- success: True
- trace_id: 16238532974906689213
-
Scan 6668112
- duration: 0:00:11.399960
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668112
- 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_newbookcron_groups/2024-11-04/1730783838", "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730783838/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10931350069842010473, "service_name": "drive-thru", "span_id": 9750232394575460027, "trace_id": 5137734337634825856 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 02:22:15
- success: True
- trace_id: 5137734337634825856
-
Scan 6667673
- duration: 0:00:13.808715
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667673
- 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_newbookcron_groups/2024-11-04/1730783746", "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730783746/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1004704639434737123, "service_name": "drive-thru", "span_id": 9787136455498300545, "trace_id": 289712329329191951 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 02:10:42
- success: True
- trace_id: 289712329329191951
-
Scan 6667127
- duration: 0:00:14.114337
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667127
- 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_newbookcron_groups/2024-11-04/1730783648", "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730783648/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6249496144516236981, "service_name": "drive-thru", "span_id": 14420466865673645692, "trace_id": 1517881153352413232 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 01:55:59
- success: True
- trace_id: 1517881153352413232
-
Scan 6666071
- duration: 0:00:11.285608
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666071
- 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_newbookcron_groups/2024-11-04/1730783501", "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730783501/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17222131711330697539, "service_name": "drive-thru", "span_id": 7717573246969708988, "trace_id": 1813575423464180620 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 01:28:14
- success: True
- trace_id: 1813575423464180620
-
Scan 6665384
- duration: 0:00:11.523176
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665384
- 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_newbookcron_groups/2024-11-04/1730783283", "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730783283/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8690698761977584924, "service_name": "drive-thru", "span_id": 16642615676471357908, "trace_id": 15572195921357732069 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 01:10:10
- success: True
- trace_id: 15572195921357732069
-
Scan 6664638
- duration: 0:00:13.841909
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664638
- 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_newbookcron_groups/2024-11-04/1730782885", "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730782885/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12954466282601755205, "service_name": "drive-thru", "span_id": 13837352709265852170, "trace_id": 14601589422628963504 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 00:50:14
- success: True
- trace_id: 14601589422628963504
-
Scan 6664168
- duration: 0:00:13.943218
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664168
- 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_newbookcron_groups/2024-11-04/1730782789", "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730782789/cron_groups.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1097721626891348847, "service_name": "drive-thru", "span_id": 16042026431862516876, "trace_id": 12468067301675288814 } } - running: False
- schema_name_id: 2662
- start_time: 2024-11-05 00:37:58
- success: True
- trace_id: 12468067301675288814
- attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - created: 2024-11-05 22:45:38
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-05/1730866443'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups" }
- 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:55:15",
"disabled": false,
"format": "raw",
"id": 2662,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookcron_groups"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"active": "string",
"id": "string",
"name": "string",
"newbook_region": "string",
"tenant": "string"
},
"created": "2024-11-05 22:45:38",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` 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_newbookcron_groups/2024-11-05/1730866443'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}