Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link

created: 2024-10-08 18:32:41
disabled: False
format: raw
id: 3032
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_drivethru",
    "table": "newbookdev_newbooktasks_linen_link"
}

type: drivethrucsv

Schema Versions: 15

Version 4749304

created: 2024-11-05 23:36:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-05/1730866617'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-05/1730866617
id: 4749304
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6675336
updated: 2024-11-05 23:36:34

Version 4749110

created: 2024-11-05 23:20:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-05/1730866573'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-05/1730866573
id: 4749110
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6675142
updated: 2024-11-05 23:21:11

Version 4748658

created: 2024-11-05 22:55:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-05/1730866471'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-05/1730866471
id: 4748658
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6674690
updated: 2024-11-05 22:55:36

Version 4747251

created: 2024-11-05 05:07:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-04/1730785815'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730785815
id: 4747251
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6672521
updated: 2024-11-05 05:07:39

Version 4746749

created: 2024-11-05 04:20:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-04/1730785177'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730785177
id: 4746749
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6671974
updated: 2024-11-05 04:20:41

Version 4745803

created: 2024-11-05 03:39:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-04/1730784871'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730784871
id: 4745803
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6671020
updated: 2024-11-05 03:39:35

Version 4744960

created: 2024-11-05 03:16:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-04/1730784268'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730784268
id: 4744960
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6670177
updated: 2024-11-05 03:17:12

Version 4744593

created: 2024-11-05 03:07:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-04/1730784107'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730784107
id: 4744593
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6669810
updated: 2024-11-05 03:07:26

Version 4743628

created: 2024-11-05 02:41:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-04/1730783939'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730783939
id: 4743628
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6668845
updated: 2024-11-05 02:41:51

Version 4742812

created: 2024-11-05 02:20:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-04/1730783820'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730783820
id: 4742812
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6668029
updated: 2024-11-05 02:20:15

Version 4741742

created: 2024-11-05 01:51:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-04/1730783623'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730783623
id: 4741742
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6666959
updated: 2024-11-05 01:51:47

Version 4741353

created: 2024-11-05 01:41:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-04/1730783576'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730783576
id: 4741353
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6666570
updated: 2024-11-05 01:41:36

Version 4740691

created: 2024-11-05 01:24:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-04/1730783358'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730783358
id: 4740691
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6665909
updated: 2024-11-05 01:24:14

Version 4739643

created: 2024-11-05 00:56:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-04/1730782956'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730782956
id: 4739643
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6664860
updated: 2024-11-05 00:56:14

Version 4739105

created: 2024-11-05 00:41:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-04/1730782844'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730782844
id: 4739105
processed: 1

raw_data:

{
    "category_id": 4,
    "id": 2,
    "linen_type_id": 5,
    "newbook_region": 0,
    "quantity": 6,
    "task_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

schema_name_id: 3032
schema_scan_id: 6664320
updated: 2024-11-05 00:42:10

Schema Scans: 15

Last at 2024-11-05 23:36:22

Scan 6675336

duration: 0:00:11.493667

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6675336

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_newbooktasks_linen_link/2024-11-05/1730866617",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-05/1730866617/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9839235596984513625,
        "service_name": "drive-thru",
        "span_id": 14135063715656530875,
        "trace_id": 8907740468535539440
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 23:36:22
success: True
trace_id: 8907740468535539440

Scan 6675142

duration: 0:00:14.118576

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6675142

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_newbooktasks_linen_link/2024-11-05/1730866573",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-05/1730866573/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12999867528429227764,
        "service_name": "drive-thru",
        "span_id": 11799586088540881501,
        "trace_id": 1871148883258680564
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 23:20:57
success: True
trace_id: 1871148883258680564

Scan 6674690

duration: 0:00:14.065243

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6674690

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_newbooktasks_linen_link/2024-11-05/1730866471",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-05/1730866471/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9115571834925446947,
        "service_name": "drive-thru",
        "span_id": 5682897560456223846,
        "trace_id": 9017730629371294029
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 22:55:22
success: True
trace_id: 9017730629371294029

Scan 6672521

duration: 0:00:14.063560

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6672521

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_newbooktasks_linen_link/2024-11-04/1730785815",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730785815/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 577115116314332133,
        "service_name": "drive-thru",
        "span_id": 3127886921136890377,
        "trace_id": 9908864337917578971
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 05:07:25
success: True
trace_id: 9908864337917578971

Scan 6671974

duration: 0:00:14.096536

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6671974

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_newbooktasks_linen_link/2024-11-04/1730785177",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730785177/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3613234751946603285,
        "service_name": "drive-thru",
        "span_id": 16423524055160246775,
        "trace_id": 11327514670853311498
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 04:20:27
success: True
trace_id: 11327514670853311498

Scan 6671020

duration: 0:00:11.555275

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6671020

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_newbooktasks_linen_link/2024-11-04/1730784871",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730784871/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17391206749607102303,
        "service_name": "drive-thru",
        "span_id": 8683356869187335080,
        "trace_id": 9003775268146542490
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 03:39:24
success: True
trace_id: 9003775268146542490

Scan 6670177

duration: 0:00:13.775684

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6670177

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_newbooktasks_linen_link/2024-11-04/1730784268",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730784268/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16235863520383793682,
        "service_name": "drive-thru",
        "span_id": 7023326279345110449,
        "trace_id": 8303362927062108016
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 03:16:59
success: True
trace_id: 8303362927062108016

Scan 6669810

duration: 0:00:11.400551

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6669810

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_newbooktasks_linen_link/2024-11-04/1730784107",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730784107/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11496835851007675661,
        "service_name": "drive-thru",
        "span_id": 10357048659267818976,
        "trace_id": 12807897460911750421
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 03:07:14
success: True
trace_id: 12807897460911750421

Scan 6668845

duration: 0:00:13.918410

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6668845

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_newbooktasks_linen_link/2024-11-04/1730783939",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730783939/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10262455975549119612,
        "service_name": "drive-thru",
        "span_id": 12674594804532048902,
        "trace_id": 15724958379862807323
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 02:41:37
success: True
trace_id: 15724958379862807323

Scan 6668029

duration: 0:00:11.468186

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6668029

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_newbooktasks_linen_link/2024-11-04/1730783820",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730783820/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1164256182029660035,
        "service_name": "drive-thru",
        "span_id": 6590761834208259871,
        "trace_id": 16853841779506466049
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 02:20:04
success: True
trace_id: 16853841779506466049

Scan 6666959

duration: 0:00:13.955283

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6666959

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_newbooktasks_linen_link/2024-11-04/1730783623",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730783623/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13368312199358418549,
        "service_name": "drive-thru",
        "span_id": 16343347781758959848,
        "trace_id": 7939227626628384264
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 01:51:33
success: True
trace_id: 7939227626628384264

Scan 6666570

duration: 0:00:11.328171

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6666570

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_newbooktasks_linen_link/2024-11-04/1730783576",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730783576/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14747194865116653767,
        "service_name": "drive-thru",
        "span_id": 6378942991537915248,
        "trace_id": 11612083869795226741
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 01:41:25
success: True
trace_id: 11612083869795226741

Scan 6665909

duration: 0:00:13.935330

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6665909

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_newbooktasks_linen_link/2024-11-04/1730783358",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730783358/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18150941492986885943,
        "service_name": "drive-thru",
        "span_id": 10367007954834588430,
        "trace_id": 2742549927644699693
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 01:24:00
success: True
trace_id: 2742549927644699693

Scan 6664860

duration: 0:00:13.783986

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6664860

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_newbooktasks_linen_link/2024-11-04/1730782956",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730782956/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1823502508539702323,
        "service_name": "drive-thru",
        "span_id": 5619986723983374814,
        "trace_id": 12520331579933997573
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 00:56:00
success: True
trace_id: 12520331579933997573

Scan 6664320

duration: 0:00:13.912339

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6664320

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_newbooktasks_linen_link/2024-11-04/1730782844",
        "key": "raw/newbookdev_newbooktasks_linen_link/2024-11-04/1730782844/tasks_linen_link.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10831175347077245887,
        "service_name": "drive-thru",
        "span_id": 12762113960060468718,
        "trace_id": 1697369720582942070
    }
}

running: False
schema_name_id: 3032
start_time: 2024-11-05 00:41:57
success: True
trace_id: 1697369720582942070

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "category_id": "string",
    "id": "string",
    "linen_type_id": "string",
    "newbook_region": "string",
    "quantity": "string",
    "task_id": "string",
    "tenant": "string"
}

created: 2024-11-05 23:36:23

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-05/1730866617'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-10-08 18:32:41",
        "disabled": false,
        "format": "raw",
        "id": 3032,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbooktasks_linen_link"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "category_id": "string",
            "id": "string",
            "linen_type_id": "string",
            "newbook_region": "string",
            "quantity": "string",
            "task_id": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:36:23",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `task_id`  string , `category_id`  string , `linen_type_id`  string , `quantity`  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_newbooktasks_linen_link/2024-11-05/1730866617'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktasks_linen_link"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}