Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions

created: 2024-10-08 18:20:51
disabled: False
format: raw
id: 2922
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749130

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-05/1730866582'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-05/1730866582
id: 4749130
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6675162
updated: 2024-11-05 23:22:38

Version 4749128

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-05/1730866523'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-05/1730866523
id: 4749128
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6675160
updated: 2024-11-05 23:22:26

Version 4748400

created: 2024-11-05 22:44:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-05/1730866398'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-05/1730866398
id: 4748400
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6674432
updated: 2024-11-05 22:45:10

Version 4747049

created: 2024-11-05 04:44:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-04/1730785778'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730785778
id: 4747049
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6672281
updated: 2024-11-05 04:45:04

Version 4746426

created: 2024-11-05 04:02:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-04/1730785156'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730785156
id: 4746426
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6671647
updated: 2024-11-05 04:02:47

Version 4745646

created: 2024-11-05 03:34:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-04/1730784851'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730784851
id: 4745646
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6670863
updated: 2024-11-05 03:35:07

Version 4744819

created: 2024-11-05 03:13:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-04/1730784247'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730784247
id: 4744819
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6670036
updated: 2024-11-05 03:13:25

Version 4744245

created: 2024-11-05 02:57:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-04/1730784085'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730784085
id: 4744245
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6669462
updated: 2024-11-05 02:57:59

Version 4743167

created: 2024-11-05 02:29:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-04/1730783852'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730783852
id: 4743167
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6668384
updated: 2024-11-05 02:29:34

Version 4742736

created: 2024-11-05 02:18:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-04/1730783799'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730783799
id: 4742736
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6667953
updated: 2024-11-05 02:18:20

Version 4742066

created: 2024-11-05 02:00:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-04/1730783688'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730783688
id: 4742066
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6667283
updated: 2024-11-05 02:00:21

Version 4740843

created: 2024-11-05 01:27:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-04/1730783556'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730783556
id: 4740843
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6666060
updated: 2024-11-05 01:28:11

Version 4740516

created: 2024-11-05 01:19:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-04/1730783337'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730783337
id: 4740516
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6665733
updated: 2024-11-05 01:19:33

Version 4739846

created: 2024-11-05 01:01:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-04/1730782936'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730782936
id: 4739846
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6665063
updated: 2024-11-05 01:01:44

Version 4739116

created: 2024-11-05 00:42:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-04/1730782828'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730782828
id: 4739116
processed: 1

raw_data:

{
    "for": 4,
    "for_id": 5,
    "id": 2,
    "newbook_region": 0,
    "payment_plans_setup_id": 3,
    "tenant": 1
}

schema_attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

schema_name_id: 2922
schema_scan_id: 6664331
updated: 2024-11-05 00:42:29

Schema Scans: 15

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

Scan 6675162

duration: 0:00:11.546501

exit_message:

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

id: 6675162

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_newbookpayment_plans_setup_restrictions/2024-11-05/1730866582",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-05/1730866582/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17827960880399395899,
        "service_name": "drive-thru",
        "span_id": 18197392585272684372,
        "trace_id": 6523200682603833332
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 23:22:27
success: True
trace_id: 6523200682603833332

Scan 6675160

duration: 0:00:11.592196

exit_message:

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

id: 6675160

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_newbookpayment_plans_setup_restrictions/2024-11-05/1730866523",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-05/1730866523/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6639647540303362255,
        "service_name": "drive-thru",
        "span_id": 15808515383165862775,
        "trace_id": 13358764414649992515
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 23:22:15
success: True
trace_id: 13358764414649992515

Scan 6674432

duration: 0:00:11.501652

exit_message:

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

id: 6674432

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_newbookpayment_plans_setup_restrictions/2024-11-05/1730866398",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-05/1730866398/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14995910026907409671,
        "service_name": "drive-thru",
        "span_id": 12897498445204674250,
        "trace_id": 8354303505842576343
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 22:44:59
success: True
trace_id: 8354303505842576343

Scan 6672281

duration: 0:00:11.526972

exit_message:

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

id: 6672281

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_newbookpayment_plans_setup_restrictions/2024-11-04/1730785778",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730785778/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6484861828573845366,
        "service_name": "drive-thru",
        "span_id": 3582981869487507867,
        "trace_id": 14229518589176799046
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 04:44:52
success: True
trace_id: 14229518589176799046

Scan 6671647

duration: 0:00:11.542226

exit_message:

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

id: 6671647

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_newbookpayment_plans_setup_restrictions/2024-11-04/1730785156",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730785156/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18435344468173083220,
        "service_name": "drive-thru",
        "span_id": 11621003219130392401,
        "trace_id": 7281925223245586927
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 04:02:35
success: True
trace_id: 7281925223245586927

Scan 6670863

duration: 0:00:11.359648

exit_message:

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

id: 6670863

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_newbookpayment_plans_setup_restrictions/2024-11-04/1730784851",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730784851/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11290074105404789540,
        "service_name": "drive-thru",
        "span_id": 16482294887762817778,
        "trace_id": 4728979648816287860
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 03:34:56
success: True
trace_id: 4728979648816287860

Scan 6670036

duration: 0:00:14.013915

exit_message:

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

id: 6670036

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_newbookpayment_plans_setup_restrictions/2024-11-04/1730784247",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730784247/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16236250221136323177,
        "service_name": "drive-thru",
        "span_id": 373538658627406628,
        "trace_id": 1203627770175746429
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 03:13:11
success: True
trace_id: 1203627770175746429

Scan 6669462

duration: 0:00:11.417425

exit_message:

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

id: 6669462

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_newbookpayment_plans_setup_restrictions/2024-11-04/1730784085",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730784085/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6706492834499992627,
        "service_name": "drive-thru",
        "span_id": 16017957941211314009,
        "trace_id": 11050978510099028224
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 02:57:47
success: True
trace_id: 11050978510099028224

Scan 6668384

duration: 0:00:11.381579

exit_message:

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

id: 6668384

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_newbookpayment_plans_setup_restrictions/2024-11-04/1730783852",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730783852/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3049716125805502758,
        "service_name": "drive-thru",
        "span_id": 6028796733569172806,
        "trace_id": 9149728588370719917
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 02:29:23
success: True
trace_id: 9149728588370719917

Scan 6667953

duration: 0:00:14.096063

exit_message:

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

id: 6667953

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_newbookpayment_plans_setup_restrictions/2024-11-04/1730783799",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730783799/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6131364053923377340,
        "service_name": "drive-thru",
        "span_id": 900745363197351301,
        "trace_id": 3685906547452537661
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 02:18:06
success: True
trace_id: 3685906547452537661

Scan 6667283

duration: 0:00:13.922058

exit_message:

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

id: 6667283

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_newbookpayment_plans_setup_restrictions/2024-11-04/1730783688",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730783688/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4508936774411554439,
        "service_name": "drive-thru",
        "span_id": 353354477151553874,
        "trace_id": 3349957740305997766
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 02:00:07
success: True
trace_id: 3349957740305997766

Scan 6666060

duration: 0:00:13.892819

exit_message:

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

id: 6666060

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_newbookpayment_plans_setup_restrictions/2024-11-04/1730783556",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730783556/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7240205398952371686,
        "service_name": "drive-thru",
        "span_id": 15604765189716700366,
        "trace_id": 11870807090219838860
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 01:27:58
success: True
trace_id: 11870807090219838860

Scan 6665733

duration: 0:00:11.715590

exit_message:

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

id: 6665733

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_newbookpayment_plans_setup_restrictions/2024-11-04/1730783337",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730783337/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3722953360890609163,
        "service_name": "drive-thru",
        "span_id": 9853240423634824087,
        "trace_id": 5373741624774097471
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 01:19:21
success: True
trace_id: 5373741624774097471

Scan 6665063

duration: 0:00:14.052618

exit_message:

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

id: 6665063

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_newbookpayment_plans_setup_restrictions/2024-11-04/1730782936",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730782936/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14684237367458680864,
        "service_name": "drive-thru",
        "span_id": 7191862116503488553,
        "trace_id": 1534765839861538389
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 01:01:30
success: True
trace_id: 1534765839861538389

Scan 6664331

duration: 0:00:14.002941

exit_message:

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

id: 6664331

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_newbookpayment_plans_setup_restrictions/2024-11-04/1730782828",
        "key": "raw/newbookdev_newbookpayment_plans_setup_restrictions/2024-11-04/1730782828/payment_plans_setup_restrictions.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17654334541987896071,
        "service_name": "drive-thru",
        "span_id": 7688156577175217743,
        "trace_id": 17445745882955343289
    }
}

running: False
schema_name_id: 2922
start_time: 2024-11-05 00:42:15
success: True
trace_id: 17445745882955343289

Partitions:

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

Schema:

attributes:

{
    "for": "string",
    "for_id": "string",
    "id": "string",
    "newbook_region": "string",
    "payment_plans_setup_id": "string",
    "tenant": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-05/1730866582'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
}

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:20:51",
        "disabled": false,
        "format": "raw",
        "id": 2922,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookpayment_plans_setup_restrictions"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "for": "string",
            "for_id": "string",
            "id": "string",
            "newbook_region": "string",
            "payment_plans_setup_id": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:22:27",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `payment_plans_setup_id`  string , `for`  string , `for_id`  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_newbookpayment_plans_setup_restrictions/2024-11-05/1730866582'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpayment_plans_setup_restrictions"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}