Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations
- created: 2024-10-08 18:07:44
- disabled: False
- format: raw
- id: 2801
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookinstances_default_translations" } - type: drivethrucsv
Schema Versions: 15
-
Version 4748789
- created: 2024-11-05 23:01:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-05/1730866512'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-05/1730866512
- id: 4748789
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6674821
- updated: 2024-11-05 23:01:48
-
Version 4748507
- created: 2024-11-05 22:48:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-05/1730866436'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-05/1730866436
- id: 4748507
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6674539
- updated: 2024-11-05 22:49:06
-
Version 4747701
- created: 2024-11-05 22:23:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-05/1730866314'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-05/1730866314
- id: 4747701
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6673733
- updated: 2024-11-05 22:23:56
-
Version 4746770
- created: 2024-11-05 04:21:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-04/1730785724'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730785724
- id: 4746770
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6671998
- updated: 2024-11-05 04:22:10
-
Version 4746219
- created: 2024-11-05 03:53:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-04/1730785127'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730785127
- id: 4746219
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6671440
- updated: 2024-11-05 03:53:50
-
Version 4744755
- created: 2024-11-05 03:11:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-04/1730784821'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730784821
- id: 4744755
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6669972
- updated: 2024-11-05 03:11:44
-
Version 4744132
- created: 2024-11-05 02:54:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-04/1730784218'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730784218
- id: 4744132
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6669349
- updated: 2024-11-05 02:55:04
-
Version 4743974
- created: 2024-11-05 02:50:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-04/1730784055'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730784055
- id: 4743974
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6669191
- updated: 2024-11-05 02:50:56
-
Version 4743644
- created: 2024-11-05 02:42:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-04/1730783900'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730783900
- id: 4743644
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6668862
- updated: 2024-11-05 02:42:16
-
Version 4742630
- created: 2024-11-05 02:15:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-04/1730783769'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730783769
- id: 4742630
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6667847
- updated: 2024-11-05 02:15:28
-
Version 4741662
- created: 2024-11-05 01:49:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-04/1730783610'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730783610
- id: 4741662
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6666879
- updated: 2024-11-05 01:49:42
-
Version 4741248
- created: 2024-11-05 01:38:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-04/1730783525'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730783525
- id: 4741248
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6666465
- updated: 2024-11-05 01:38:50
-
Version 4740339
- created: 2024-11-05 01:14:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-04/1730783307'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730783307
- id: 4740339
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6665556
- updated: 2024-11-05 01:14:54
-
Version 4739615
- created: 2024-11-05 00:55:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-04/1730782908'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730782908
- id: 4739615
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6664832
- updated: 2024-11-05 00:55:32
-
Version 4738968
- created: 2024-11-05 00:38:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-04/1730782807'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730782807
- id: 4738968
- processed: 1
- raw_data:
{ "default_value": 4, "id": 2, "newbook_region": 0, "replace_phrase": 3, "tenant": 1 } - schema_attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - schema_name_id: 2801
- schema_scan_id: 6664182
- updated: 2024-11-05 00:38:36
Schema Scans: 15
Last at 2024-11-05 23:01:34
-
Scan 6674821
- duration: 0:00:14.093844
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674821
- 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_newbookinstances_default_translations/2024-11-05/1730866512", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-05/1730866512/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2379656567852108937, "service_name": "drive-thru", "span_id": 7732725917507360364, "trace_id": 17427871303236505634 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 23:01:34
- success: True
- trace_id: 17427871303236505634
-
Scan 6674539
- duration: 0:00:11.494194
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674539
- 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_newbookinstances_default_translations/2024-11-05/1730866436", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-05/1730866436/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 606350530462505977, "service_name": "drive-thru", "span_id": 1928946034478919445, "trace_id": 8045970718055765122 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 22:48:54
- success: True
- trace_id: 8045970718055765122
-
Scan 6673733
- duration: 0:00:11.429843
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673733
- 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_newbookinstances_default_translations/2024-11-05/1730866314", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-05/1730866314/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9205930678523718114, "service_name": "drive-thru", "span_id": 807973878644538349, "trace_id": 7917810245922317078 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 22:23:45
- success: True
- trace_id: 7917810245922317078
-
Scan 6671998
- duration: 0:00:11.404822
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671998
- 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_newbookinstances_default_translations/2024-11-04/1730785724", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730785724/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13979861535054831565, "service_name": "drive-thru", "span_id": 12395658560912143885, "trace_id": 9014090804562884049 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 04:21:59
- success: True
- trace_id: 9014090804562884049
-
Scan 6671440
- duration: 0:00:14.108470
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671440
- 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_newbookinstances_default_translations/2024-11-04/1730785127", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730785127/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16207570734588906708, "service_name": "drive-thru", "span_id": 8193187244638841916, "trace_id": 2393877310756255938 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 03:53:36
- success: True
- trace_id: 2393877310756255938
-
Scan 6669972
- duration: 0:00:11.349356
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669972
- 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_newbookinstances_default_translations/2024-11-04/1730784821", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730784821/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 36819786963896093, "service_name": "drive-thru", "span_id": 732040163238742607, "trace_id": 15093756189534382032 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 03:11:33
- success: True
- trace_id: 15093756189534382032
-
Scan 6669349
- duration: 0:00:13.908816
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669349
- 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_newbookinstances_default_translations/2024-11-04/1730784218", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730784218/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 467223370798890276, "service_name": "drive-thru", "span_id": 2016632064762154929, "trace_id": 7619632173779168851 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 02:54:51
- success: True
- trace_id: 7619632173779168851
-
Scan 6669191
- duration: 0:00:11.233408
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669191
- 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_newbookinstances_default_translations/2024-11-04/1730784055", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730784055/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6803733533093449017, "service_name": "drive-thru", "span_id": 15431499156018580176, "trace_id": 3894100888804474347 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 02:50:45
- success: True
- trace_id: 3894100888804474347
-
Scan 6668862
- duration: 0:00:11.286437
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668862
- 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_newbookinstances_default_translations/2024-11-04/1730783900", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730783900/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15707308281776395048, "service_name": "drive-thru", "span_id": 9178969258024747824, "trace_id": 14652096362844568516 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 02:42:05
- success: True
- trace_id: 14652096362844568516
-
Scan 6667847
- duration: 0:00:11.118505
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667847
- 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_newbookinstances_default_translations/2024-11-04/1730783769", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730783769/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15997523000378030862, "service_name": "drive-thru", "span_id": 7440364726358317171, "trace_id": 9892255815166938173 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 02:15:16
- success: True
- trace_id: 9892255815166938173
-
Scan 6666879
- duration: 0:00:11.377122
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666879
- 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_newbookinstances_default_translations/2024-11-04/1730783610", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730783610/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8839680821913839127, "service_name": "drive-thru", "span_id": 2476897122346851147, "trace_id": 14276493974779407115 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 01:49:30
- success: True
- trace_id: 14276493974779407115
-
Scan 6666465
- duration: 0:00:11.493415
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666465
- 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_newbookinstances_default_translations/2024-11-04/1730783525", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730783525/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5436645677490331185, "service_name": "drive-thru", "span_id": 11905219468460198144, "trace_id": 4557497499602316565 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 01:38:38
- success: True
- trace_id: 4557497499602316565
-
Scan 6665556
- duration: 0:00:11.374475
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665556
- 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_newbookinstances_default_translations/2024-11-04/1730783307", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730783307/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18269471816207807253, "service_name": "drive-thru", "span_id": 17553028036928506222, "trace_id": 13550923756301408518 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 01:14:43
- success: True
- trace_id: 13550923756301408518
-
Scan 6664832
- duration: 0:00:13.820224
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664832
- 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_newbookinstances_default_translations/2024-11-04/1730782908", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730782908/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11430551166646733909, "service_name": "drive-thru", "span_id": 6262970120968001184, "trace_id": 385566613926250883 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 00:55:19
- success: True
- trace_id: 385566613926250883
-
Scan 6664182
- duration: 0:00:13.964101
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664182
- 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_newbookinstances_default_translations/2024-11-04/1730782807", "key": "raw/newbookdev_newbookinstances_default_translations/2024-11-04/1730782807/instances_default_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6624107355841021961, "service_name": "drive-thru", "span_id": 11344471731249909706, "trace_id": 16338306146233218871 } } - running: False
- schema_name_id: 2801
- start_time: 2024-11-05 00:38:22
- success: True
- trace_id: 16338306146233218871
- attributes:
{ "default_value": "string", "id": "string", "newbook_region": "string", "replace_phrase": "string", "tenant": "string" } - created: 2024-11-05 23:01:34
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-05/1730866512'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations" }
- 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:07:44",
"disabled": false,
"format": "raw",
"id": 2801,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookinstances_default_translations"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"default_value": "string",
"id": "string",
"newbook_region": "string",
"replace_phrase": "string",
"tenant": "string"
},
"created": "2024-11-05 23:01:34",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `replace_phrase` string , `default_value` 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_newbookinstances_default_translations/2024-11-05/1730866512'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_default_translations"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}