Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookusers_languages
- created: 2024-10-08 18:39:13
- disabled: False
- format: raw
- id: 3090
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookusers_languages" } - type: drivethrucsv
Schema Versions: 15
-
Version 4749340
- created: 2024-11-05 23:40:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-05/1730866629'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-05/1730866629
- id: 4749340
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6675372
- updated: 2024-11-05 23:40:25
-
Version 4749157
- created: 2024-11-05 23:24:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-05/1730866590'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-05/1730866590
- id: 4749157
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6675189
- updated: 2024-11-05 23:24:36
-
Version 4748840
- created: 2024-11-05 23:04:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-05/1730866495'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-05/1730866495
- id: 4748840
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6674872
- updated: 2024-11-05 23:04:35
-
Version 4747192
- created: 2024-11-05 05:00:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-04/1730785829'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-04/1730785829
- id: 4747192
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6672424
- updated: 2024-11-05 05:00:28
-
Version 4746567
- created: 2024-11-05 04:09:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-04/1730785185'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-04/1730785185
- id: 4746567
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6671790
- updated: 2024-11-05 04:10:08
-
Version 4746052
- created: 2024-11-05 03:47:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-04/1730784878'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-04/1730784878
- id: 4746052
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6671273
- updated: 2024-11-05 03:47:47
-
Version 4745289
- created: 2024-11-05 03:25:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-04/1730784276'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-04/1730784276
- id: 4745289
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6670506
- updated: 2024-11-05 03:25:44
-
Version 4744795
- created: 2024-11-05 03:12:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-04/1730784114'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-04/1730784114
- id: 4744795
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6670012
- updated: 2024-11-05 03:12:43
-
Version 4743867
- created: 2024-11-05 02:47:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-04/1730783944'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-04/1730783944
- id: 4743867
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6669084
- updated: 2024-11-05 02:48:10
-
Version 4742839
- created: 2024-11-05 02:20:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-04/1730783827'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-04/1730783827
- id: 4742839
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6668056
- updated: 2024-11-05 02:20:59
-
Version 4741591
- created: 2024-11-05 01:47:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-04/1730783585'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-04/1730783585
- id: 4741591
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6666808
- updated: 2024-11-05 01:47:50
-
Version 4741530
- created: 2024-11-05 01:46:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-04/1730783625'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-04/1730783625
- id: 4741530
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6666747
- updated: 2024-11-05 01:46:11
-
Version 4740638
- created: 2024-11-05 01:22:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-04/1730783366'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-04/1730783366
- id: 4740638
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6665855
- updated: 2024-11-05 01:22:46
-
Version 4739912
- created: 2024-11-05 01:03:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-04/1730782963'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-04/1730782963
- id: 4739912
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6665129
- updated: 2024-11-05 01:03:31
-
Version 4739208
- created: 2024-11-05 00:44:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-04/1730782850'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_languages/2024-11-04/1730782850
- id: 4739208
- processed: 1
- raw_data:
{ "id": 2, "language": 4, "newbook_region": 0, "tenant": 1, "user_id": 3 } - schema_attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - schema_name_id: 3090
- schema_scan_id: 6664423
- updated: 2024-11-05 00:44:50
Schema Scans: 15
Last at 2024-11-05 23:40:13
-
Scan 6675372
- duration: 0:00:11.564826
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675372
- 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_newbookusers_languages/2024-11-05/1730866629", "key": "raw/newbookdev_newbookusers_languages/2024-11-05/1730866629/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9507422244956638383, "service_name": "drive-thru", "span_id": 5952424523104694726, "trace_id": 3551310392312776311 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 23:40:13
- success: True
- trace_id: 3551310392312776311
-
Scan 6675189
- duration: 0:00:14.033348
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675189
- 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_newbookusers_languages/2024-11-05/1730866590", "key": "raw/newbookdev_newbookusers_languages/2024-11-05/1730866590/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13146623594676297616, "service_name": "drive-thru", "span_id": 9295008294592227436, "trace_id": 12489526745475922036 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 23:24:22
- success: True
- trace_id: 12489526745475922036
-
Scan 6674872
- duration: 0:00:13.990928
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674872
- 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_newbookusers_languages/2024-11-05/1730866495", "key": "raw/newbookdev_newbookusers_languages/2024-11-05/1730866495/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12149040341566651465, "service_name": "drive-thru", "span_id": 9414278041898727187, "trace_id": 16995805202857997100 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 23:04:21
- success: True
- trace_id: 16995805202857997100
-
Scan 6672424
- duration: 0:00:14.029170
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6672424
- 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_newbookusers_languages/2024-11-04/1730785829", "key": "raw/newbookdev_newbookusers_languages/2024-11-04/1730785829/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14715226080751470617, "service_name": "drive-thru", "span_id": 11728345106740450698, "trace_id": 2578629693703337015 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 05:00:14
- success: True
- trace_id: 2578629693703337015
-
Scan 6671790
- duration: 0:00:13.933078
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671790
- 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_newbookusers_languages/2024-11-04/1730785185", "key": "raw/newbookdev_newbookusers_languages/2024-11-04/1730785185/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10303862499769312417, "service_name": "drive-thru", "span_id": 8946493446378764044, "trace_id": 10803084385185476709 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 04:09:54
- success: True
- trace_id: 10803084385185476709
-
Scan 6671273
- duration: 0:00:11.457148
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671273
- 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_newbookusers_languages/2024-11-04/1730784878", "key": "raw/newbookdev_newbookusers_languages/2024-11-04/1730784878/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14013187889267140059, "service_name": "drive-thru", "span_id": 8940843584214646891, "trace_id": 13730165657583967482 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 03:47:35
- success: True
- trace_id: 13730165657583967482
-
Scan 6670506
- duration: 0:00:11.328076
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670506
- 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_newbookusers_languages/2024-11-04/1730784276", "key": "raw/newbookdev_newbookusers_languages/2024-11-04/1730784276/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15438531115922959299, "service_name": "drive-thru", "span_id": 3857775863474001719, "trace_id": 5396548422447569540 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 03:25:33
- success: True
- trace_id: 5396548422447569540
-
Scan 6670012
- duration: 0:00:11.376244
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670012
- 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_newbookusers_languages/2024-11-04/1730784114", "key": "raw/newbookdev_newbookusers_languages/2024-11-04/1730784114/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6090083349201221843, "service_name": "drive-thru", "span_id": 16687716976851921753, "trace_id": 2582845005940481708 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 03:12:32
- success: True
- trace_id: 2582845005940481708
-
Scan 6669084
- duration: 0:00:13.999366
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669084
- 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_newbookusers_languages/2024-11-04/1730783944", "key": "raw/newbookdev_newbookusers_languages/2024-11-04/1730783944/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11650707685556922439, "service_name": "drive-thru", "span_id": 13866632051050589950, "trace_id": 9601534051316167904 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 02:47:56
- success: True
- trace_id: 9601534051316167904
-
Scan 6668056
- duration: 0:00:13.946501
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668056
- 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_newbookusers_languages/2024-11-04/1730783827", "key": "raw/newbookdev_newbookusers_languages/2024-11-04/1730783827/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11675484163088619041, "service_name": "drive-thru", "span_id": 8468272733585296153, "trace_id": 671458046756487938 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 02:20:45
- success: True
- trace_id: 671458046756487938
-
Scan 6666808
- duration: 0:00:11.494312
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666808
- 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_newbookusers_languages/2024-11-04/1730783585", "key": "raw/newbookdev_newbookusers_languages/2024-11-04/1730783585/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17669576799665757007, "service_name": "drive-thru", "span_id": 13986759775334064281, "trace_id": 5935915111732131133 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 01:47:38
- success: True
- trace_id: 5935915111732131133
-
Scan 6666747
- duration: 0:00:11.309223
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666747
- 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_newbookusers_languages/2024-11-04/1730783625", "key": "raw/newbookdev_newbookusers_languages/2024-11-04/1730783625/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16538568688619156611, "service_name": "drive-thru", "span_id": 4709285268383854567, "trace_id": 14802892994497964965 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 01:46:00
- success: True
- trace_id: 14802892994497964965
-
Scan 6665855
- duration: 0:00:11.383924
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665855
- 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_newbookusers_languages/2024-11-04/1730783366", "key": "raw/newbookdev_newbookusers_languages/2024-11-04/1730783366/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6469819600914874341, "service_name": "drive-thru", "span_id": 11994313775907493677, "trace_id": 17265142799617810191 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 01:22:35
- success: True
- trace_id: 17265142799617810191
-
Scan 6665129
- duration: 0:00:13.882198
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665129
- 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_newbookusers_languages/2024-11-04/1730782963", "key": "raw/newbookdev_newbookusers_languages/2024-11-04/1730782963/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18424780456804203877, "service_name": "drive-thru", "span_id": 18408488914588978921, "trace_id": 1339089189123739123 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 01:03:17
- success: True
- trace_id: 1339089189123739123
-
Scan 6664423
- duration: 0:00:11.296992
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664423
- 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_newbookusers_languages/2024-11-04/1730782850", "key": "raw/newbookdev_newbookusers_languages/2024-11-04/1730782850/users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookusers_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4018967241591229684, "service_name": "drive-thru", "span_id": 9509897813684374860, "trace_id": 8730684989206119185 } } - running: False
- schema_name_id: 3090
- start_time: 2024-11-05 00:44:39
- success: True
- trace_id: 8730684989206119185
- attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - created: 2024-11-05 23:40:14
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-05/1730866629'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages" }
- 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:39:13",
"disabled": false,
"format": "raw",
"id": 3090,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookusers_languages"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"id": "string",
"language": "string",
"newbook_region": "string",
"tenant": "string",
"user_id": "string"
},
"created": "2024-11-05 23:40:14",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookusers_languages`\n(\n `newbook_region` string , `tenant` string , `id` string , `user_id` string , `language` 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_newbookusers_languages/2024-11-05/1730866629'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookusers_languages`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookusers_languages"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}