Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbooktranslation_templates
- created: 2024-10-08 18:35:42
- disabled: False
- format: raw
- id: 3058
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbooktranslation_templates" } - type: drivethrucsv
Schema Versions: 15
-
Version 4749393
- created: 2024-11-05 23:45:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-05/1730866584'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-05/1730866584
- id: 4749393
- 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: 3058
- schema_scan_id: 6675431
- updated: 2024-11-05 23:46:10
-
Version 4749285
- created: 2024-11-05 23:34:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-05/1730866624'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-05/1730866624
- id: 4749285
- 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: 3058
- schema_scan_id: 6675317
- updated: 2024-11-05 23:34:38
-
Version 4748772
- created: 2024-11-05 23:00:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-05/1730866486'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-05/1730866486
- id: 4748772
- 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: 3058
- schema_scan_id: 6674805
- updated: 2024-11-05 23:00:51
-
Version 4747203
- created: 2024-11-05 05:01:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730785823'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730785823
- id: 4747203
- 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: 3058
- schema_scan_id: 6672435
- updated: 2024-11-05 05:01:36
-
Version 4746524
- created: 2024-11-05 04:07:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730785181'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730785181
- id: 4746524
- 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: 3058
- schema_scan_id: 6671746
- updated: 2024-11-05 04:07:47
-
Version 4746074
- created: 2024-11-05 03:48:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730784879'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730784879
- id: 4746074
- 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: 3058
- schema_scan_id: 6671295
- updated: 2024-11-05 03:48:34
-
Version 4745271
- created: 2024-11-05 03:25:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730784272'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730784272
- id: 4745271
- 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: 3058
- schema_scan_id: 6670488
- updated: 2024-11-05 03:25:19
-
Version 4744634
- created: 2024-11-05 03:08:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730784111'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730784111
- id: 4744634
- 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: 3058
- schema_scan_id: 6669851
- updated: 2024-11-05 03:08:34
-
Version 4743843
- created: 2024-11-05 02:47:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730783942'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783942
- id: 4743843
- 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: 3058
- schema_scan_id: 6669060
- updated: 2024-11-05 02:47:31
-
Version 4742922
- created: 2024-11-05 02:22:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730783824'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783824
- id: 4742922
- 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: 3058
- schema_scan_id: 6668139
- updated: 2024-11-05 02:23:09
-
Version 4742102
- created: 2024-11-05 02:01:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730783708'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783708
- id: 4742102
- 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: 3058
- schema_scan_id: 6667319
- updated: 2024-11-05 02:01:21
-
Version 4741361
- created: 2024-11-05 01:41:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730783582'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783582
- id: 4741361
- 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: 3058
- schema_scan_id: 6666578
- updated: 2024-11-05 01:41:47
-
Version 4740603
- created: 2024-11-05 01:21:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730783363'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783363
- id: 4740603
- 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: 3058
- schema_scan_id: 6665820
- updated: 2024-11-05 01:21:52
-
Version 4739900
- created: 2024-11-05 01:02:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730782961'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730782961
- id: 4739900
- 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: 3058
- schema_scan_id: 6665117
- updated: 2024-11-05 01:03:11
-
Version 4738713
- created: 2024-11-05 00:31:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730782765'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730782765
- id: 4738713
- 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: 3058
- schema_scan_id: 6663926
- updated: 2024-11-05 00:31:51
Schema Scans: 15
Last at 2024-11-05 23:45:58
-
Scan 6675431
- duration: 0:00:11.590388
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675431
- 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_newbooktranslation_templates/2024-11-05/1730866584", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-05/1730866584/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7296421043572741387, "service_name": "drive-thru", "span_id": 17549184335037864203, "trace_id": 5670918255666073051 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 23:45:58
- success: True
- trace_id: 5670918255666073051
-
Scan 6675317
- duration: 0:00:13.929084
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675317
- 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_newbooktranslation_templates/2024-11-05/1730866624", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-05/1730866624/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11969781092632443138, "service_name": "drive-thru", "span_id": 7207704882735088757, "trace_id": 5446833868923525684 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 23:34:24
- success: True
- trace_id: 5446833868923525684
-
Scan 6674805
- duration: 0:00:11.540930
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674805
- 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_newbooktranslation_templates/2024-11-05/1730866486", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-05/1730866486/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17290890336955042466, "service_name": "drive-thru", "span_id": 16115292283348800570, "trace_id": 17790901561305302193 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 23:00:39
- success: True
- trace_id: 17790901561305302193
-
Scan 6672435
- duration: 0:00:14.063500
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6672435
- 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_newbooktranslation_templates/2024-11-04/1730785823", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730785823/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4008993278038816215, "service_name": "drive-thru", "span_id": 10588681931218882458, "trace_id": 6070773168757378111 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 05:01:22
- success: True
- trace_id: 6070773168757378111
-
Scan 6671746
- duration: 0:00:11.461068
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671746
- 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_newbooktranslation_templates/2024-11-04/1730785181", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730785181/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17964640893793180539, "service_name": "drive-thru", "span_id": 5522013205405302751, "trace_id": 9976318523370755528 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 04:07:35
- success: True
- trace_id: 9976318523370755528
-
Scan 6671295
- duration: 0:00:14.161319
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671295
- 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_newbooktranslation_templates/2024-11-04/1730784879", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730784879/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13429330651621527423, "service_name": "drive-thru", "span_id": 10545058922341851861, "trace_id": 5650997328090528138 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 03:48:20
- success: True
- trace_id: 5650997328090528138
-
Scan 6670488
- duration: 0:00:13.794510
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670488
- 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_newbooktranslation_templates/2024-11-04/1730784272", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730784272/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16479558836998372455, "service_name": "drive-thru", "span_id": 8286002374291574599, "trace_id": 7585161861779425452 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 03:25:05
- success: True
- trace_id: 7585161861779425452
-
Scan 6669851
- duration: 0:00:13.820388
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669851
- 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_newbooktranslation_templates/2024-11-04/1730784111", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730784111/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13858113904816442732, "service_name": "drive-thru", "span_id": 5496621206522528438, "trace_id": 17570705134914983905 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 03:08:20
- success: True
- trace_id: 17570705134914983905
-
Scan 6669060
- duration: 0:00:11.392871
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669060
- 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_newbooktranslation_templates/2024-11-04/1730783942", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783942/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2693944057277481223, "service_name": "drive-thru", "span_id": 4801829903409464581, "trace_id": 5047022726311170963 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 02:47:19
- success: True
- trace_id: 5047022726311170963
-
Scan 6668139
- duration: 0:00:11.298591
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668139
- 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_newbooktranslation_templates/2024-11-04/1730783824", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783824/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8948111195466504198, "service_name": "drive-thru", "span_id": 17982067256328156337, "trace_id": 10911065026570987978 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 02:22:57
- success: True
- trace_id: 10911065026570987978
-
Scan 6667319
- duration: 0:00:13.908942
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667319
- 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_newbooktranslation_templates/2024-11-04/1730783708", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783708/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14731119679495074952, "service_name": "drive-thru", "span_id": 12166630763751584451, "trace_id": 4891611588019637486 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 02:01:07
- success: True
- trace_id: 4891611588019637486
-
Scan 6666578
- duration: 0:00:11.369718
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666578
- 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_newbooktranslation_templates/2024-11-04/1730783582", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783582/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12716862183796268104, "service_name": "drive-thru", "span_id": 6012849188182910784, "trace_id": 14122701719558677647 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 01:41:36
- success: True
- trace_id: 14122701719558677647
-
Scan 6665820
- duration: 0:00:11.393784
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665820
- 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_newbooktranslation_templates/2024-11-04/1730783363", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783363/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13963168623437136879, "service_name": "drive-thru", "span_id": 19185624630016794, "trace_id": 11759628768486327282 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 01:21:40
- success: True
- trace_id: 11759628768486327282
-
Scan 6665117
- duration: 0:00:13.959338
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665117
- 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_newbooktranslation_templates/2024-11-04/1730782961", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730782961/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3486961487465397203, "service_name": "drive-thru", "span_id": 10539102935228984968, "trace_id": 12288614858484512972 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 01:02:57
- success: True
- trace_id: 12288614858484512972
-
Scan 6663926
- duration: 0:00:13.933858
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6663926
- 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_newbooktranslation_templates/2024-11-04/1730782765", "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730782765/translation_templates.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1445917647383269488, "service_name": "drive-thru", "span_id": 15864485448885595410, "trace_id": 6710808848308317496 } } - running: False
- schema_name_id: 3058
- start_time: 2024-11-05 00:31:37
- success: True
- trace_id: 6710808848308317496
- attributes:
{ "active": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - created: 2024-11-05 23:45:59
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-05/1730866584'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates" }
- 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:35:42",
"disabled": false,
"format": "raw",
"id": 3058,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbooktranslation_templates"
},
"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:45:59",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-05/1730866584'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}