Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookassets_categories
- created: 2024-10-08 17:38:34
- disabled: False
- format: raw
- id: 2431
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookassets_categories" } - type: drivethrucsv
Schema Versions: 15
-
Version 4748179
- created: 2024-11-05 22:37:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-05/1730866362'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-05/1730866362
- id: 4748179
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6674211
- updated: 2024-11-05 22:37:24
-
Version 4747714
- created: 2024-11-05 22:24:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-05/1730866298'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-05/1730866298
- id: 4747714
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6673746
- updated: 2024-11-05 22:24:16
-
Version 4747382
- created: 2024-11-05 22:14:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-05/1730866229'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-05/1730866229
- id: 4747382
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6673414
- updated: 2024-11-05 22:14:57
-
Version 4746133
- created: 2024-11-05 03:50:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-04/1730785081'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-04/1730785081
- id: 4746133
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6671354
- updated: 2024-11-05 03:50:40
-
Version 4745938
- created: 2024-11-05 03:43:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-04/1730785647'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-04/1730785647
- id: 4745938
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6671158
- updated: 2024-11-05 03:43:47
-
Version 4745032
- created: 2024-11-05 03:18:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-04/1730784775'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-04/1730784775
- id: 4745032
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6670249
- updated: 2024-11-05 03:19:04
-
Version 4744014
- created: 2024-11-05 02:51:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-04/1730784010'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-04/1730784010
- id: 4744014
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6669231
- updated: 2024-11-05 02:51:57
-
Version 4743893
- created: 2024-11-05 02:48:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-04/1730784172'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-04/1730784172
- id: 4743893
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6669110
- updated: 2024-11-05 02:48:50
-
Version 4743410
- created: 2024-11-05 02:35:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-04/1730783865'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-04/1730783865
- id: 4743410
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6668627
- updated: 2024-11-05 02:36:03
-
Version 4742158
- created: 2024-11-05 02:02:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-04/1730783722'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-04/1730783722
- id: 4742158
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6667375
- updated: 2024-11-05 02:02:52
-
Version 4741587
- created: 2024-11-05 01:47:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-04/1730783631'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-04/1730783631
- id: 4741587
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6666804
- updated: 2024-11-05 01:47:39
-
Version 4740752
- created: 2024-11-05 01:25:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-04/1730783478'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-04/1730783478
- id: 4740752
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6665969
- updated: 2024-11-05 01:25:46
-
Version 4740014
- created: 2024-11-05 01:06:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-04/1730783259'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-04/1730783259
- id: 4740014
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6665231
- updated: 2024-11-05 01:06:14
-
Version 4739228
- created: 2024-11-05 00:45:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-04/1730782862'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-04/1730782862
- id: 4739228
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6664443
- updated: 2024-11-05 00:45:19
-
Version 4738841
- created: 2024-11-05 00:35:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-04/1730782771'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookassets_categories/2024-11-04/1730782771
- id: 4738841
- processed: 1
- raw_data:
{ "description": 4, "id": 2, "name": 3, "newbook_region": 0, "tenant": 1 } - schema_attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - schema_name_id: 2431
- schema_scan_id: 6664054
- updated: 2024-11-05 00:35:11
Schema Scans: 15
Last at 2024-11-05 22:37:13
-
Scan 6674211
- duration: 0:00:11.373335
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674211
- 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_newbookassets_categories/2024-11-05/1730866362", "key": "raw/newbookdev_newbookassets_categories/2024-11-05/1730866362/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7815620741119300762, "service_name": "drive-thru", "span_id": 5357076406018839228, "trace_id": 18312207365674609280 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 22:37:13
- success: True
- trace_id: 18312207365674609280
-
Scan 6673746
- duration: 0:00:13.786935
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673746
- 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_newbookassets_categories/2024-11-05/1730866298", "key": "raw/newbookdev_newbookassets_categories/2024-11-05/1730866298/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6228993005373563608, "service_name": "drive-thru", "span_id": 17553852196787536636, "trace_id": 1416072511618337442 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 22:24:02
- success: True
- trace_id: 1416072511618337442
-
Scan 6673414
- duration: 0:00:14.090166
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673414
- 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_newbookassets_categories/2024-11-05/1730866229", "key": "raw/newbookdev_newbookassets_categories/2024-11-05/1730866229/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14018920924580526344, "service_name": "drive-thru", "span_id": 5664802819342863621, "trace_id": 15440275532437888082 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 22:14:43
- success: True
- trace_id: 15440275532437888082
-
Scan 6671354
- duration: 0:00:11.463707
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671354
- 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_newbookassets_categories/2024-11-04/1730785081", "key": "raw/newbookdev_newbookassets_categories/2024-11-04/1730785081/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2709153420889268109, "service_name": "drive-thru", "span_id": 4753306516436619325, "trace_id": 3252146964247044444 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 03:50:28
- success: True
- trace_id: 3252146964247044444
-
Scan 6671158
- duration: 0:00:14.040868
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671158
- 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_newbookassets_categories/2024-11-04/1730785647", "key": "raw/newbookdev_newbookassets_categories/2024-11-04/1730785647/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15571585418919852792, "service_name": "drive-thru", "span_id": 7066191740417303738, "trace_id": 17452413078890390585 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 03:43:33
- success: True
- trace_id: 17452413078890390585
-
Scan 6670249
- duration: 0:00:11.250498
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670249
- 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_newbookassets_categories/2024-11-04/1730784775", "key": "raw/newbookdev_newbookassets_categories/2024-11-04/1730784775/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11100659320026072619, "service_name": "drive-thru", "span_id": 12864015986450405872, "trace_id": 907842071981966193 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 03:18:53
- success: True
- trace_id: 907842071981966193
-
Scan 6669231
- duration: 0:00:11.433573
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669231
- 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_newbookassets_categories/2024-11-04/1730784010", "key": "raw/newbookdev_newbookassets_categories/2024-11-04/1730784010/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13834406337822622412, "service_name": "drive-thru", "span_id": 1157484120610171220, "trace_id": 5150378599695299368 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 02:51:45
- success: True
- trace_id: 5150378599695299368
-
Scan 6669110
- duration: 0:00:13.820717
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669110
- 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_newbookassets_categories/2024-11-04/1730784172", "key": "raw/newbookdev_newbookassets_categories/2024-11-04/1730784172/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4952049598835585761, "service_name": "drive-thru", "span_id": 3062730926013736033, "trace_id": 15980275455019313495 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 02:48:36
- success: True
- trace_id: 15980275455019313495
-
Scan 6668627
- duration: 0:00:11.247806
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668627
- 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_newbookassets_categories/2024-11-04/1730783865", "key": "raw/newbookdev_newbookassets_categories/2024-11-04/1730783865/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16411150026596505008, "service_name": "drive-thru", "span_id": 8140624756677948063, "trace_id": 2865136388711193174 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 02:35:52
- success: True
- trace_id: 2865136388711193174
-
Scan 6667375
- duration: 0:00:13.803358
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667375
- 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_newbookassets_categories/2024-11-04/1730783722", "key": "raw/newbookdev_newbookassets_categories/2024-11-04/1730783722/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17883724202659109320, "service_name": "drive-thru", "span_id": 13171061729274813677, "trace_id": 8261544425797964521 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 02:02:38
- success: True
- trace_id: 8261544425797964521
-
Scan 6666804
- duration: 0:00:11.367624
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666804
- 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_newbookassets_categories/2024-11-04/1730783631", "key": "raw/newbookdev_newbookassets_categories/2024-11-04/1730783631/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17026949060650694123, "service_name": "drive-thru", "span_id": 16670248092507965289, "trace_id": 9229429432200323190 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 01:47:28
- success: True
- trace_id: 9229429432200323190
-
Scan 6665969
- duration: 0:00:13.816455
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665969
- 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_newbookassets_categories/2024-11-04/1730783478", "key": "raw/newbookdev_newbookassets_categories/2024-11-04/1730783478/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5135491844210347494, "service_name": "drive-thru", "span_id": 8260321392086610133, "trace_id": 17288334591870443994 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 01:25:32
- success: True
- trace_id: 17288334591870443994
-
Scan 6665231
- duration: 0:00:11.371310
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665231
- 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_newbookassets_categories/2024-11-04/1730783259", "key": "raw/newbookdev_newbookassets_categories/2024-11-04/1730783259/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11311410647920977510, "service_name": "drive-thru", "span_id": 928851829371948513, "trace_id": 12861372696682363876 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 01:06:03
- success: True
- trace_id: 12861372696682363876
-
Scan 6664443
- duration: 0:00:11.353605
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664443
- 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_newbookassets_categories/2024-11-04/1730782862", "key": "raw/newbookdev_newbookassets_categories/2024-11-04/1730782862/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2742929335597062514, "service_name": "drive-thru", "span_id": 17234927479159893495, "trace_id": 14484506322826384915 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 00:45:07
- success: True
- trace_id: 14484506322826384915
-
Scan 6664054
- duration: 0:00:11.247545
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664054
- 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_newbookassets_categories/2024-11-04/1730782771", "key": "raw/newbookdev_newbookassets_categories/2024-11-04/1730782771/assets_categories.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookassets_categories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5000480798159026464, "service_name": "drive-thru", "span_id": 8684681774888378621, "trace_id": 904148673221385841 } } - running: False
- schema_name_id: 2431
- start_time: 2024-11-05 00:35:00
- success: True
- trace_id: 904148673221385841
- attributes:
{ "description": "string", "id": "string", "name": "string", "newbook_region": "string", "tenant": "string" } - created: 2024-11-05 22:37:13
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-05/1730866362'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories" }
- 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:38:34",
"disabled": false,
"format": "raw",
"id": 2431,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookassets_categories"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"description": "string",
"id": "string",
"name": "string",
"newbook_region": "string",
"tenant": "string"
},
"created": "2024-11-05 22:37:13",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookassets_categories`\n(\n `newbook_region` string , `tenant` string , `id` string , `name` string , `description` 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_newbookassets_categories/2024-11-05/1730866362'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookassets_categories`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookassets_categories"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}