Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookshared_users_languages
- created: 2024-10-08 18:28:46
- disabled: False
- format: raw
- id: 2996
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookshared_users_languages" } - type: drivethrucsv
Schema Versions: 15
-
Version 4749244
- created: 2024-11-05 23:30:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-05/1730866600'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-05/1730866600
- id: 4749244
- 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: 2996
- schema_scan_id: 6675276
- updated: 2024-11-05 23:30:39
-
Version 4748974
- created: 2024-11-05 23:11:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-05/1730866544'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-05/1730866544
- id: 4748974
- 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: 2996
- schema_scan_id: 6675006
- updated: 2024-11-05 23:12:00
-
Version 4748412
- created: 2024-11-05 22:45:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-05/1730866432'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-05/1730866432
- id: 4748412
- 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: 2996
- schema_scan_id: 6674444
- updated: 2024-11-05 22:45:34
-
Version 4747087
- created: 2024-11-05 04:48:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-04/1730785794'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730785794
- id: 4747087
- 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: 2996
- schema_scan_id: 6672319
- updated: 2024-11-05 04:49:07
-
Version 4746456
- created: 2024-11-05 04:03:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-04/1730785165'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730785165
- id: 4746456
- 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: 2996
- schema_scan_id: 6671677
- updated: 2024-11-05 04:04:06
-
Version 4745725
- created: 2024-11-05 03:36:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-04/1730784860'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730784860
- id: 4745725
- 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: 2996
- schema_scan_id: 6670942
- updated: 2024-11-05 03:37:10
-
Version 4745154
- created: 2024-11-05 03:22:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-04/1730784257'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730784257
- id: 4745154
- 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: 2996
- schema_scan_id: 6670371
- updated: 2024-11-05 03:22:14
-
Version 4744122
- created: 2024-11-05 02:54:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-04/1730784094'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730784094
- id: 4744122
- 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: 2996
- schema_scan_id: 6669339
- updated: 2024-11-05 02:54:47
-
Version 4743324
- created: 2024-11-05 02:33:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-04/1730783854'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783854
- id: 4743324
- 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: 2996
- schema_scan_id: 6668541
- updated: 2024-11-05 02:33:48
-
Version 4742802
- created: 2024-11-05 02:19:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-04/1730783808'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783808
- id: 4742802
- 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: 2996
- schema_scan_id: 6668019
- updated: 2024-11-05 02:19:58
-
Version 4741971
- created: 2024-11-05 01:57:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-04/1730783696'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783696
- id: 4741971
- 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: 2996
- schema_scan_id: 6667189
- updated: 2024-11-05 01:57:51
-
Version 4741427
- created: 2024-11-05 01:43:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-04/1730783565'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783565
- id: 4741427
- 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: 2996
- schema_scan_id: 6666644
- updated: 2024-11-05 01:43:28
-
Version 4740577
- created: 2024-11-05 01:20:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-04/1730783347'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783347
- id: 4740577
- 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: 2996
- schema_scan_id: 6665794
- updated: 2024-11-05 01:21:09
-
Version 4739936
- created: 2024-11-05 01:03:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-04/1730782945'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730782945
- id: 4739936
- 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: 2996
- schema_scan_id: 6665153
- updated: 2024-11-05 01:04:08
-
Version 4739229
- created: 2024-11-05 00:45:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-04/1730782835'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730782835
- id: 4739229
- 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: 2996
- schema_scan_id: 6664444
- updated: 2024-11-05 00:45:23
Schema Scans: 15
Last at 2024-11-05 23:30:25
-
Scan 6675276
- duration: 0:00:13.971906
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675276
- 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_newbookshared_users_languages/2024-11-05/1730866600", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-05/1730866600/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 76718932560108382, "service_name": "drive-thru", "span_id": 10038316750168123940, "trace_id": 2606899075581882186 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 23:30:25
- success: True
- trace_id: 2606899075581882186
-
Scan 6675006
- duration: 0:00:11.562198
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6675006
- 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_newbookshared_users_languages/2024-11-05/1730866544", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-05/1730866544/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 896801120540723298, "service_name": "drive-thru", "span_id": 11292312060665675536, "trace_id": 6045288204799049135 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 23:11:48
- success: True
- trace_id: 6045288204799049135
-
Scan 6674444
- duration: 0:00:11.566281
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674444
- 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_newbookshared_users_languages/2024-11-05/1730866432", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-05/1730866432/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9860557920861136167, "service_name": "drive-thru", "span_id": 4871776726690175638, "trace_id": 8101783153852190567 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 22:45:22
- success: True
- trace_id: 8101783153852190567
-
Scan 6672319
- duration: 0:00:11.477299
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6672319
- 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_newbookshared_users_languages/2024-11-04/1730785794", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730785794/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10544695955698142983, "service_name": "drive-thru", "span_id": 9406921278004541843, "trace_id": 3944632050860660874 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 04:48:55
- success: True
- trace_id: 3944632050860660874
-
Scan 6671677
- duration: 0:00:13.972571
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671677
- 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_newbookshared_users_languages/2024-11-04/1730785165", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730785165/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1877552700000777277, "service_name": "drive-thru", "span_id": 8733810423907563136, "trace_id": 225325754367466246 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 04:03:52
- success: True
- trace_id: 225325754367466246
-
Scan 6670942
- duration: 0:00:11.468555
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670942
- 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_newbookshared_users_languages/2024-11-04/1730784860", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730784860/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12093958476564804313, "service_name": "drive-thru", "span_id": 12711177329239844997, "trace_id": 7502590339562783389 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 03:36:59
- success: True
- trace_id: 7502590339562783389
-
Scan 6670371
- duration: 0:00:13.790548
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670371
- 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_newbookshared_users_languages/2024-11-04/1730784257", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730784257/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1593395170421792576, "service_name": "drive-thru", "span_id": 13974965661230639533, "trace_id": 5113398631693793278 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 03:22:00
- success: True
- trace_id: 5113398631693793278
-
Scan 6669339
- duration: 0:00:11.309656
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669339
- 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_newbookshared_users_languages/2024-11-04/1730784094", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730784094/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10457861046031968864, "service_name": "drive-thru", "span_id": 13950557316411656843, "trace_id": 9950463031630365421 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 02:54:35
- success: True
- trace_id: 9950463031630365421
-
Scan 6668541
- duration: 0:00:11.314991
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668541
- 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_newbookshared_users_languages/2024-11-04/1730783854", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783854/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14313837391367488260, "service_name": "drive-thru", "span_id": 9184435653339323334, "trace_id": 17606883292160286044 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 02:33:37
- success: True
- trace_id: 17606883292160286044
-
Scan 6668019
- duration: 0:00:11.336248
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668019
- 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_newbookshared_users_languages/2024-11-04/1730783808", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783808/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4894379153801442349, "service_name": "drive-thru", "span_id": 811121064665299027, "trace_id": 10088338728994779071 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 02:19:46
- success: True
- trace_id: 10088338728994779071
-
Scan 6667189
- duration: 0:00:11.309023
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667189
- 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_newbookshared_users_languages/2024-11-04/1730783696", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783696/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3135641593649842609, "service_name": "drive-thru", "span_id": 5921935427815469626, "trace_id": 7184316977427636136 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 01:57:40
- success: True
- trace_id: 7184316977427636136
-
Scan 6666644
- duration: 0:00:11.315479
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666644
- 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_newbookshared_users_languages/2024-11-04/1730783565", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783565/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2143775026534750243, "service_name": "drive-thru", "span_id": 15262695148951156638, "trace_id": 18370723210537456970 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 01:43:17
- success: True
- trace_id: 18370723210537456970
-
Scan 6665794
- duration: 0:00:11.271561
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665794
- 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_newbookshared_users_languages/2024-11-04/1730783347", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783347/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11577091195831825267, "service_name": "drive-thru", "span_id": 5664341362383745488, "trace_id": 6131438907111101928 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 01:20:58
- success: True
- trace_id: 6131438907111101928
-
Scan 6665153
- duration: 0:00:11.443457
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665153
- 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_newbookshared_users_languages/2024-11-04/1730782945", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730782945/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4750537793963115743, "service_name": "drive-thru", "span_id": 13554678989410495131, "trace_id": 7233663085561297128 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 01:03:57
- success: True
- trace_id: 7233663085561297128
-
Scan 6664444
- duration: 0:00:13.891297
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664444
- 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_newbookshared_users_languages/2024-11-04/1730782835", "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730782835/shared_users_languages.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18401072333125949027, "service_name": "drive-thru", "span_id": 16892171919697510932, "trace_id": 10700777675726767062 } } - running: False
- schema_name_id: 2996
- start_time: 2024-11-05 00:45:09
- success: True
- trace_id: 10700777675726767062
- attributes:
{ "id": "string", "language": "string", "newbook_region": "string", "tenant": "string", "user_id": "string" } - created: 2024-11-05 23:30:25
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-05/1730866600'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_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:28:46",
"disabled": false,
"format": "raw",
"id": 2996,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookshared_users_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:30:25",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_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_newbookshared_users_languages/2024-11-05/1730866600'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}