Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbooklinen_types
- created: 2024-10-08 18:02:57
- disabled: False
- format: raw
- id: 2758
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbooklinen_types" } - type: drivethrucsv
Schema Versions: 15
-
Version 4749226
- created: 2024-11-05 23:29:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-05/1730866543'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-05/1730866543
- id: 4749226
- 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: 2758
- schema_scan_id: 6675258
- updated: 2024-11-05 23:29:21
-
Version 4748671
- created: 2024-11-05 22:55:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-05/1730866483'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-05/1730866483
- id: 4748671
- 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: 2758
- schema_scan_id: 6674703
- updated: 2024-11-05 22:56:04
-
Version 4748059
- created: 2024-11-05 22:33:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-05/1730866349'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-05/1730866349
- id: 4748059
- 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: 2758
- schema_scan_id: 6674091
- updated: 2024-11-05 22:33:48
-
Version 4746986
- created: 2024-11-05 04:38:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-04/1730785750'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-04/1730785750
- id: 4746986
- 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: 2758
- schema_scan_id: 6672217
- updated: 2024-11-05 04:38:12
-
Version 4746336
- created: 2024-11-05 03:58:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-04/1730785140'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-04/1730785140
- id: 4746336
- 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: 2758
- schema_scan_id: 6671557
- updated: 2024-11-05 03:58:54
-
Version 4744842
- created: 2024-11-05 03:13:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-04/1730784835'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-04/1730784835
- id: 4744842
- 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: 2758
- schema_scan_id: 6670059
- updated: 2024-11-05 03:13:58
-
Version 4744191
- created: 2024-11-05 02:56:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-04/1730784231'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-04/1730784231
- id: 4744191
- 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: 2758
- schema_scan_id: 6669409
- updated: 2024-11-05 02:56:33
-
Version 4744135
- created: 2024-11-05 02:54:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-04/1730784069'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-04/1730784069
- id: 4744135
- 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: 2758
- schema_scan_id: 6669352
- updated: 2024-11-05 02:55:07
-
Version 4743708
- created: 2024-11-05 02:43:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-04/1730783911'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-04/1730783911
- id: 4743708
- 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: 2758
- schema_scan_id: 6668925
- updated: 2024-11-05 02:43:57
-
Version 4742768
- created: 2024-11-05 02:18:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-04/1730783783'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-04/1730783783
- id: 4742768
- 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: 2758
- schema_scan_id: 6667985
- updated: 2024-11-05 02:19:10
-
Version 4741986
- created: 2024-11-05 01:58:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-04/1730783677'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-04/1730783677
- id: 4741986
- 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: 2758
- schema_scan_id: 6667203
- updated: 2024-11-05 01:58:11
-
Version 4740746
- created: 2024-11-05 01:25:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-04/1730783540'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-04/1730783540
- id: 4740746
- 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: 2758
- schema_scan_id: 6665963
- updated: 2024-11-05 01:25:38
-
Version 4740522
- created: 2024-11-05 01:19:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-04/1730783321'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-04/1730783321
- id: 4740522
- 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: 2758
- schema_scan_id: 6665739
- updated: 2024-11-05 01:19:40
-
Version 4739696
- created: 2024-11-05 00:57:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-04/1730782922'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-04/1730782922
- id: 4739696
- 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: 2758
- schema_scan_id: 6664913
- updated: 2024-11-05 00:57:35
-
Version 4738574
- created: 2024-11-05 00:28:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-04/1730782755'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklinen_types/2024-11-04/1730782755
- id: 4738574
- 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: 2758
- schema_scan_id: 6663787
- updated: 2024-11-05 00:28:11
Schema Scans: 15
Last at 2024-11-05 23:29:09
-
Scan 6675258
- duration: 0:00:11.459789
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675258
- 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_newbooklinen_types/2024-11-05/1730866543", "key": "raw/newbookdev_newbooklinen_types/2024-11-05/1730866543/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9859493272102655727, "service_name": "drive-thru", "span_id": 9936105802973861985, "trace_id": 5859376891284017342 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 23:29:09
- success: True
- trace_id: 5859376891284017342
-
Scan 6674703
- duration: 0:00:11.488089
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674703
- 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_newbooklinen_types/2024-11-05/1730866483", "key": "raw/newbookdev_newbooklinen_types/2024-11-05/1730866483/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6815283714108290870, "service_name": "drive-thru", "span_id": 16338242060068428176, "trace_id": 9994325084074440559 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 22:55:53
- success: True
- trace_id: 9994325084074440559
-
Scan 6674091
- duration: 0:00:13.969258
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674091
- 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_newbooklinen_types/2024-11-05/1730866349", "key": "raw/newbookdev_newbooklinen_types/2024-11-05/1730866349/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5656777345516854025, "service_name": "drive-thru", "span_id": 15631883889493992431, "trace_id": 9819859990654447043 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 22:33:34
- success: True
- trace_id: 9819859990654447043
-
Scan 6672217
- duration: 0:00:11.476584
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6672217
- 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_newbooklinen_types/2024-11-04/1730785750", "key": "raw/newbookdev_newbooklinen_types/2024-11-04/1730785750/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11224726706187857467, "service_name": "drive-thru", "span_id": 11885209077612696069, "trace_id": 7916656364815818105 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 04:38:01
- success: True
- trace_id: 7916656364815818105
-
Scan 6671557
- duration: 0:00:13.960642
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671557
- 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_newbooklinen_types/2024-11-04/1730785140", "key": "raw/newbookdev_newbooklinen_types/2024-11-04/1730785140/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10231931974150302442, "service_name": "drive-thru", "span_id": 18167363741721798600, "trace_id": 17864635879540670796 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 03:58:40
- success: True
- trace_id: 17864635879540670796
-
Scan 6670059
- duration: 0:00:11.289083
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670059
- 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_newbooklinen_types/2024-11-04/1730784835", "key": "raw/newbookdev_newbooklinen_types/2024-11-04/1730784835/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6599591186074614017, "service_name": "drive-thru", "span_id": 1595337721243789692, "trace_id": 16583665724357459096 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 03:13:47
- success: True
- trace_id: 16583665724357459096
-
Scan 6669409
- duration: 0:00:11.333269
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669409
- 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_newbooklinen_types/2024-11-04/1730784231", "key": "raw/newbookdev_newbooklinen_types/2024-11-04/1730784231/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12201772875998834624, "service_name": "drive-thru", "span_id": 14599428965644840885, "trace_id": 6826578943331740497 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 02:56:22
- success: True
- trace_id: 6826578943331740497
-
Scan 6669352
- duration: 0:00:13.856211
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669352
- 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_newbooklinen_types/2024-11-04/1730784069", "key": "raw/newbookdev_newbooklinen_types/2024-11-04/1730784069/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9632629914272068439, "service_name": "drive-thru", "span_id": 6238457097917604611, "trace_id": 8480249539441227271 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 02:54:53
- success: True
- trace_id: 8480249539441227271
-
Scan 6668925
- duration: 0:00:11.472975
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668925
- 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_newbooklinen_types/2024-11-04/1730783911", "key": "raw/newbookdev_newbooklinen_types/2024-11-04/1730783911/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3091684158603265200, "service_name": "drive-thru", "span_id": 7115701273411478836, "trace_id": 17883279657994875442 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 02:43:46
- success: True
- trace_id: 17883279657994875442
-
Scan 6667985
- duration: 0:00:13.815961
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667985
- 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_newbooklinen_types/2024-11-04/1730783783", "key": "raw/newbookdev_newbooklinen_types/2024-11-04/1730783783/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16859731016214855686, "service_name": "drive-thru", "span_id": 16944157713304076560, "trace_id": 3077334146220658069 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 02:18:56
- success: True
- trace_id: 3077334146220658069
-
Scan 6667203
- duration: 0:00:11.405380
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667203
- 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_newbooklinen_types/2024-11-04/1730783677", "key": "raw/newbookdev_newbooklinen_types/2024-11-04/1730783677/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6596473456491861438, "service_name": "drive-thru", "span_id": 1112488596725299014, "trace_id": 10331840351067622684 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 01:58:00
- success: True
- trace_id: 10331840351067622684
-
Scan 6665963
- duration: 0:00:11.379180
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665963
- 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_newbooklinen_types/2024-11-04/1730783540", "key": "raw/newbookdev_newbooklinen_types/2024-11-04/1730783540/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7403409113529854919, "service_name": "drive-thru", "span_id": 1639973697746595814, "trace_id": 2526575537864467845 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 01:25:27
- success: True
- trace_id: 2526575537864467845
-
Scan 6665739
- duration: 0:00:11.518724
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665739
- 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_newbooklinen_types/2024-11-04/1730783321", "key": "raw/newbookdev_newbooklinen_types/2024-11-04/1730783321/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16423078656599872077, "service_name": "drive-thru", "span_id": 4753102109502612975, "trace_id": 938240638394850067 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 01:19:29
- success: True
- trace_id: 938240638394850067
-
Scan 6664913
- duration: 0:00:11.388324
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664913
- 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_newbooklinen_types/2024-11-04/1730782922", "key": "raw/newbookdev_newbooklinen_types/2024-11-04/1730782922/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16781936217209989912, "service_name": "drive-thru", "span_id": 9899621587587010538, "trace_id": 16636637212657830661 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 00:57:24
- success: True
- trace_id: 16636637212657830661
-
Scan 6663787
- duration: 0:00:11.576097
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6663787
- 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_newbooklinen_types/2024-11-04/1730782755", "key": "raw/newbookdev_newbooklinen_types/2024-11-04/1730782755/linen_types.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooklinen_types", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10076758755907226728, "service_name": "drive-thru", "span_id": 15119346473713059648, "trace_id": 7431023750030709051 } } - running: False
- schema_name_id: 2758
- start_time: 2024-11-05 00:27:59
- success: True
- trace_id: 7431023750030709051
- attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - created: 2024-11-05 23:29:10
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-05/1730866543'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types" }
- 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:02:57",
"disabled": false,
"format": "raw",
"id": 2758,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbooklinen_types"
},
"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 23:29:10",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklinen_types`\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_newbooklinen_types/2024-11-05/1730866543'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklinen_types`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklinen_types"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}