Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookinstances_translations
- created: 2024-10-08 17:53:02
- disabled: False
- format: raw
- id: 2631
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookinstances_translations" } - type: drivethrucsv
Schema Versions: 15
-
Version 4749039
- created: 2024-11-05 23:15:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-05/1730866515'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-05/1730866515
- id: 4749039
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6675071
- updated: 2024-11-05 23:16:05
-
Version 4748458
- created: 2024-11-05 22:47:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-05/1730866441'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-05/1730866441
- id: 4748458
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6674491
- updated: 2024-11-05 22:47:14
-
Version 4747799
- created: 2024-11-05 22:26:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-05/1730866318'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-05/1730866318
- id: 4747799
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6673831
- updated: 2024-11-05 22:26:27
-
Version 4746779
- created: 2024-11-05 04:22:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-04/1730785727'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730785727
- id: 4746779
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6672007
- updated: 2024-11-05 04:22:48
-
Version 4746163
- created: 2024-11-05 03:51:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-04/1730785128'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730785128
- id: 4746163
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6671384
- updated: 2024-11-05 03:51:41
-
Version 4744756
- created: 2024-11-05 03:11:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-04/1730784823'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730784823
- id: 4744756
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6669973
- updated: 2024-11-05 03:11:45
-
Version 4744133
- created: 2024-11-05 02:54:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-04/1730784219'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730784219
- id: 4744133
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6669350
- updated: 2024-11-05 02:55:03
-
Version 4743413
- created: 2024-11-05 02:35:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-04/1730784057'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730784057
- id: 4743413
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6668630
- updated: 2024-11-05 02:36:12
-
Version 4743248
- created: 2024-11-05 02:31:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-04/1730783902'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730783902
- id: 4743248
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6668465
- updated: 2024-11-05 02:31:42
-
Version 4742640
- created: 2024-11-05 02:15:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-04/1730783770'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730783770
- id: 4742640
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6667857
- updated: 2024-11-05 02:15:43
-
Version 4742023
- created: 2024-11-05 01:58:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-04/1730783667'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730783667
- id: 4742023
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6667240
- updated: 2024-11-05 01:59:09
-
Version 4741111
- created: 2024-11-05 01:35:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-04/1730783526'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730783526
- id: 4741111
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6666328
- updated: 2024-11-05 01:35:19
-
Version 4740355
- created: 2024-11-05 01:15:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-04/1730783308'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730783308
- id: 4740355
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6665572
- updated: 2024-11-05 01:15:20
-
Version 4739713
- created: 2024-11-05 00:57:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-04/1730782909'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730782909
- id: 4739713
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6664930
- updated: 2024-11-05 00:58:05
-
Version 4738488
- created: 2024-11-05 00:25:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-04/1730782751'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730782751
- id: 4738488
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "translation": 5, "translation_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - schema_name_id: 2631
- schema_scan_id: 6663699
- updated: 2024-11-05 00:25:55
Schema Scans: 15
Last at 2024-11-05 23:15:53
-
Scan 6675071
- duration: 0:00:11.515492
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675071
- 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_translations/2024-11-05/1730866515", "key": "raw/newbookdev_newbookinstances_translations/2024-11-05/1730866515/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8393188081948868094, "service_name": "drive-thru", "span_id": 10469764498413264416, "trace_id": 10668399111388730339 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 23:15:53
- success: True
- trace_id: 10668399111388730339
-
Scan 6674491
- duration: 0:00:14.220997
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674491
- 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_translations/2024-11-05/1730866441", "key": "raw/newbookdev_newbookinstances_translations/2024-11-05/1730866441/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16741394016058277142, "service_name": "drive-thru", "span_id": 5479303057284120276, "trace_id": 7802529925720591562 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 22:47:00
- success: True
- trace_id: 7802529925720591562
-
Scan 6673831
- duration: 0:00:11.322293
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673831
- 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_translations/2024-11-05/1730866318", "key": "raw/newbookdev_newbookinstances_translations/2024-11-05/1730866318/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7129902242861098845, "service_name": "drive-thru", "span_id": 7558076193149357350, "trace_id": 2795314866899258121 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 22:26:16
- success: True
- trace_id: 2795314866899258121
-
Scan 6672007
- duration: 0:00:14.105344
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6672007
- 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_translations/2024-11-04/1730785727", "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730785727/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1353014249515687257, "service_name": "drive-thru", "span_id": 10030008479929256467, "trace_id": 10108491912101921161 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 04:22:33
- success: True
- trace_id: 10108491912101921161
-
Scan 6671384
- duration: 0:00:11.492376
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671384
- 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_translations/2024-11-04/1730785128", "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730785128/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17227399200106191369, "service_name": "drive-thru", "span_id": 12003906389013918706, "trace_id": 4618399055748640684 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 03:51:30
- success: True
- trace_id: 4618399055748640684
-
Scan 6669973
- duration: 0:00:11.297753
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669973
- 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_translations/2024-11-04/1730784823", "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730784823/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4457225609222862642, "service_name": "drive-thru", "span_id": 5918350494344447999, "trace_id": 13861074293971509889 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 03:11:34
- success: True
- trace_id: 13861074293971509889
-
Scan 6669350
- duration: 0:00:11.319396
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669350
- 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_translations/2024-11-04/1730784219", "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730784219/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14341539751438207641, "service_name": "drive-thru", "span_id": 1738561346449248709, "trace_id": 18143322292403069006 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 02:54:51
- success: True
- trace_id: 18143322292403069006
-
Scan 6668630
- duration: 0:00:13.805858
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668630
- 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_translations/2024-11-04/1730784057", "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730784057/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1615172074032088091, "service_name": "drive-thru", "span_id": 17824887089413649163, "trace_id": 5839076315612489042 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 02:35:58
- success: True
- trace_id: 5839076315612489042
-
Scan 6668465
- duration: 0:00:11.413184
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668465
- 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_translations/2024-11-04/1730783902", "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730783902/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7745898207405977380, "service_name": "drive-thru", "span_id": 4456643560334648342, "trace_id": 16800980608415883087 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 02:31:30
- success: True
- trace_id: 16800980608415883087
-
Scan 6667857
- duration: 0:00:11.376399
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667857
- 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_translations/2024-11-04/1730783770", "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730783770/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3114619244275056226, "service_name": "drive-thru", "span_id": 9355928795384019544, "trace_id": 15087656473528336629 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 02:15:32
- success: True
- trace_id: 15087656473528336629
-
Scan 6667240
- duration: 0:00:11.376825
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667240
- 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_translations/2024-11-04/1730783667", "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730783667/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6836996998850000047, "service_name": "drive-thru", "span_id": 10670208959415374175, "trace_id": 11377842824458766187 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 01:58:57
- success: True
- trace_id: 11377842824458766187
-
Scan 6666328
- duration: 0:00:13.875555
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666328
- 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_translations/2024-11-04/1730783526", "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730783526/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15158171759081745862, "service_name": "drive-thru", "span_id": 8607084539412830060, "trace_id": 4554466568030342607 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 01:35:05
- success: True
- trace_id: 4554466568030342607
-
Scan 6665572
- duration: 0:00:13.881823
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665572
- 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_translations/2024-11-04/1730783308", "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730783308/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4614111959811433374, "service_name": "drive-thru", "span_id": 1927805147088607367, "trace_id": 10156767912832287073 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 01:15:06
- success: True
- trace_id: 10156767912832287073
-
Scan 6664930
- duration: 0:00:11.435055
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664930
- 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_translations/2024-11-04/1730782909", "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730782909/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6084343231526593547, "service_name": "drive-thru", "span_id": 14993178745863132653, "trace_id": 17137119832659810486 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 00:57:54
- success: True
- trace_id: 17137119832659810486
-
Scan 6663699
- duration: 0:00:11.441900
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6663699
- 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_translations/2024-11-04/1730782751", "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730782751/instances_translations.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17957472998700866718, "service_name": "drive-thru", "span_id": 7495377526640131824, "trace_id": 17159419368213498100 } } - running: False
- schema_name_id: 2631
- start_time: 2024-11-05 00:25:44
- success: True
- trace_id: 17159419368213498100
- attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "translation": "string", "translation_id": "string" } - created: 2024-11-05 23:15:54
- 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_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-05/1730866515'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_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 17:53:02",
"disabled": false,
"format": "raw",
"id": 2631,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookinstances_translations"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"id": "string",
"language": "string",
"newbook_region": "string",
"tenant": "string",
"translation": "string",
"translation_id": "string"
},
"created": "2024-11-05 23:15:54",
"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_translations`\n(\n `newbook_region` string , `tenant` string , `id` string , `translation_id` string , `language` string , `translation` 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_translations/2024-11-05/1730866515'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}