Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookquotes_packages
- created: 2024-10-08 18:23:51
- disabled: False
- format: raw
- id: 2950
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookquotes_packages" } - type: drivethrucsv
Schema Versions: 15
-
Version 4749193
- created: 2024-11-05 23:26:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-05/1730866588'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866588
- id: 4749193
- 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: 2950
- schema_scan_id: 6675225
- updated: 2024-11-05 23:27:06
-
Version 4749167
- created: 2024-11-05 23:25:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-05/1730866530'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866530
- id: 4749167
- 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: 2950
- schema_scan_id: 6675199
- updated: 2024-11-05 23:25:16
-
Version 4748365
- created: 2024-11-05 22:43:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-05/1730866408'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866408
- id: 4748365
- 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: 2950
- schema_scan_id: 6674398
- updated: 2024-11-05 22:43:59
-
Version 4747067
- created: 2024-11-05 04:46:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-04/1730785783'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730785783
- id: 4747067
- 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: 2950
- schema_scan_id: 6672299
- updated: 2024-11-05 04:46:59
-
Version 4746401
- created: 2024-11-05 04:01:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-04/1730785159'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730785159
- id: 4746401
- 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: 2950
- schema_scan_id: 6671622
- updated: 2024-11-05 04:01:40
-
Version 4745603
- created: 2024-11-05 03:33:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-04/1730784854'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730784854
- id: 4745603
- 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: 2950
- schema_scan_id: 6670820
- updated: 2024-11-05 03:33:59
-
Version 4744830
- created: 2024-11-05 03:13:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-04/1730784250'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730784250
- id: 4744830
- 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: 2950
- schema_scan_id: 6670047
- updated: 2024-11-05 03:13:39
-
Version 4744097
- created: 2024-11-05 02:53:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-04/1730784088'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730784088
- id: 4744097
- 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: 2950
- schema_scan_id: 6669314
- updated: 2024-11-05 02:54:05
-
Version 4742876
- created: 2024-11-05 02:21:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-04/1730783925'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783925
- id: 4742876
- 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: 2950
- schema_scan_id: 6668093
- updated: 2024-11-05 02:21:58
-
Version 4742714
- created: 2024-11-05 02:17:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-04/1730783802'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783802
- id: 4742714
- 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: 2950
- schema_scan_id: 6667931
- updated: 2024-11-05 02:17:46
-
Version 4742144
- created: 2024-11-05 02:02:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-04/1730783691'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783691
- id: 4742144
- 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: 2950
- schema_scan_id: 6667361
- updated: 2024-11-05 02:02:26
-
Version 4741277
- created: 2024-11-05 01:39:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-04/1730783559'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783559
- id: 4741277
- 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: 2950
- schema_scan_id: 6666494
- updated: 2024-11-05 01:39:37
-
Version 4740558
- created: 2024-11-05 01:20:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-04/1730783340'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783340
- id: 4740558
- 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: 2950
- schema_scan_id: 6665776
- updated: 2024-11-05 01:20:39
-
Version 4739705
- created: 2024-11-05 00:57:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-04/1730782939'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730782939
- id: 4739705
- 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: 2950
- schema_scan_id: 6664922
- updated: 2024-11-05 00:57:54
-
Version 4738755
- created: 2024-11-05 00:32:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-04/1730782759'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730782759
- id: 4738755
- 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: 2950
- schema_scan_id: 6663968
- updated: 2024-11-05 00:33:03
Schema Scans: 15
Last at 2024-11-05 23:26:55
-
Scan 6675225
- duration: 0:00:11.586985
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675225
- 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_newbookquotes_packages/2024-11-05/1730866588", "key": "raw/newbookdev_newbookquotes_packages/2024-11-05/1730866588/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8507851357973221881, "service_name": "drive-thru", "span_id": 4536609228681138105, "trace_id": 3982931988190795355 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 23:26:55
- success: True
- trace_id: 3982931988190795355
-
Scan 6675199
- duration: 0:00:11.493925
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675199
- 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_newbookquotes_packages/2024-11-05/1730866530", "key": "raw/newbookdev_newbookquotes_packages/2024-11-05/1730866530/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17642351787782331503, "service_name": "drive-thru", "span_id": 16072116185774699035, "trace_id": 15293296964826195781 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 23:25:04
- success: True
- trace_id: 15293296964826195781
-
Scan 6674398
- duration: 0:00:13.968582
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674398
- 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_newbookquotes_packages/2024-11-05/1730866408", "key": "raw/newbookdev_newbookquotes_packages/2024-11-05/1730866408/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15122910732430887275, "service_name": "drive-thru", "span_id": 8199989532705653814, "trace_id": 18089493501052803571 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 22:43:46
- success: True
- trace_id: 18089493501052803571
-
Scan 6672299
- duration: 0:00:11.442055
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6672299
- 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_newbookquotes_packages/2024-11-04/1730785783", "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730785783/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15505710183354547960, "service_name": "drive-thru", "span_id": 5621350435170425845, "trace_id": 14697142920409590716 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 04:46:48
- success: True
- trace_id: 14697142920409590716
-
Scan 6671622
- duration: 0:00:11.421251
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671622
- 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_newbookquotes_packages/2024-11-04/1730785159", "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730785159/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14023538040468708219, "service_name": "drive-thru", "span_id": 15705334119986096830, "trace_id": 15758236794801576211 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 04:01:29
- success: True
- trace_id: 15758236794801576211
-
Scan 6670820
- duration: 0:00:11.433054
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670820
- 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_newbookquotes_packages/2024-11-04/1730784854", "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730784854/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13046590013063349783, "service_name": "drive-thru", "span_id": 719686739159128975, "trace_id": 483376029824777942 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 03:33:47
- success: True
- trace_id: 483376029824777942
-
Scan 6670047
- duration: 0:00:13.850518
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670047
- 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_newbookquotes_packages/2024-11-04/1730784250", "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730784250/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7378386793801562848, "service_name": "drive-thru", "span_id": 1636522456859031912, "trace_id": 9635782382809231097 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 03:13:25
- success: True
- trace_id: 9635782382809231097
-
Scan 6669314
- duration: 0:00:11.308165
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669314
- 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_newbookquotes_packages/2024-11-04/1730784088", "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730784088/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12721886624383373797, "service_name": "drive-thru", "span_id": 10390040039081485041, "trace_id": 4842586341328388924 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 02:53:54
- success: True
- trace_id: 4842586341328388924
-
Scan 6668093
- duration: 0:00:13.850701
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668093
- 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_newbookquotes_packages/2024-11-04/1730783925", "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730783925/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 928618225782057883, "service_name": "drive-thru", "span_id": 3387832516476416543, "trace_id": 338420804686770689 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 02:21:44
- success: True
- trace_id: 338420804686770689
-
Scan 6667931
- duration: 0:00:13.911450
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667931
- 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_newbookquotes_packages/2024-11-04/1730783802", "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730783802/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8312124966552102614, "service_name": "drive-thru", "span_id": 14360255237317494510, "trace_id": 14310674479911546455 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 02:17:32
- success: True
- trace_id: 14310674479911546455
-
Scan 6667361
- duration: 0:00:11.382054
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667361
- 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_newbookquotes_packages/2024-11-04/1730783691", "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730783691/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12062356242810368260, "service_name": "drive-thru", "span_id": 13220794365785673938, "trace_id": 17650202138800760799 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 02:02:14
- success: True
- trace_id: 17650202138800760799
-
Scan 6666494
- duration: 0:00:13.829052
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666494
- 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_newbookquotes_packages/2024-11-04/1730783559", "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730783559/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14295493447039461855, "service_name": "drive-thru", "span_id": 5868322387838330249, "trace_id": 6809815603643544733 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 01:39:24
- success: True
- trace_id: 6809815603643544733
-
Scan 6665776
- duration: 0:00:11.338317
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665776
- 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_newbookquotes_packages/2024-11-04/1730783340", "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730783340/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13298473264729833137, "service_name": "drive-thru", "span_id": 11312530166734830093, "trace_id": 382203736835780735 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 01:20:27
- success: True
- trace_id: 382203736835780735
-
Scan 6664922
- duration: 0:00:11.335366
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664922
- 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_newbookquotes_packages/2024-11-04/1730782939", "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730782939/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6747131268630163917, "service_name": "drive-thru", "span_id": 4396908818366226394, "trace_id": 532066434500025130 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 00:57:42
- success: True
- trace_id: 532066434500025130
-
Scan 6663968
- duration: 0:00:13.948012
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6663968
- 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_newbookquotes_packages/2024-11-04/1730782759", "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730782759/quotes_packages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17557378892340802484, "service_name": "drive-thru", "span_id": 7169731147492951014, "trace_id": 14253766606841499026 } } - running: False
- schema_name_id: 2950
- start_time: 2024-11-05 00:32:49
- success: True
- trace_id: 14253766606841499026
- attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - created: 2024-11-05 23:26:55
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-05/1730866588'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages" }
- 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:23:51",
"disabled": false,
"format": "raw",
"id": 2950,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookquotes_packages"
},
"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:26:55",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\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_newbookquotes_packages/2024-11-05/1730866588'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}