Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items

created: 2024-10-08 17:52:47
disabled: False
format: raw
id: 2628
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748651

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-05/1730866486'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-05/1730866486
id: 4748651
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6674683
updated: 2024-11-05 22:55:16

Version 4748125

created: 2024-11-05 22:35:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-05/1730866401'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-05/1730866401
id: 4748125
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6674156
updated: 2024-11-05 22:35:50

Version 4747578

created: 2024-11-05 22:20:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-05/1730866289'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-05/1730866289
id: 4747578
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6673609
updated: 2024-11-05 22:20:43

Version 4746852

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-04/1730785707'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730785707
id: 4746852
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6672082
updated: 2024-11-05 04:28:09

Version 4746169

created: 2024-11-05 03:51:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-04/1730785117'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730785117
id: 4746169
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6671389
updated: 2024-11-05 03:51:56

Version 4745818

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-04/1730784812'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730784812
id: 4745818
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6671035
updated: 2024-11-05 03:40:02

Version 4744696

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-04/1730784208'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730784208
id: 4744696
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6669913
updated: 2024-11-05 03:10:12

Version 4743956

created: 2024-11-05 02:50:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-04/1730784046'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730784046
id: 4743956
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6669173
updated: 2024-11-05 02:50:28

Version 4743108

created: 2024-11-05 02:27:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-04/1730783842'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730783842
id: 4743108
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6668325
updated: 2024-11-05 02:28:06

Version 4741969

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-04/1730783759'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730783759
id: 4741969
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6667185
updated: 2024-11-05 01:57:45

Version 4741962

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-04/1730783658'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730783658
id: 4741962
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6667179
updated: 2024-11-05 01:57:33

Version 4741050

created: 2024-11-05 01:33:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-04/1730783515'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730783515
id: 4741050
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6666267
updated: 2024-11-05 01:33:40

Version 4740401

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-04/1730783297'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730783297
id: 4740401
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6665618
updated: 2024-11-05 01:16:30

Version 4739425

created: 2024-11-05 00:50:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-04/1730782898'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730782898
id: 4739425
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6664640
updated: 2024-11-05 00:50:31

Version 4738629

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-04/1730782799'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730782799
id: 4738629
processed: 1

raw_data:

{
    "adults": 5,
    "amount": 22,
    "animals": 8,
    "children": 6,
    "daysofweek": 19,
    "daytype": 13,
    "description": 12,
    "disburse_to_owners": 33,
    "discounts_apply": 34,
    "event_id": 3,
    "gl_account_id": 11,
    "gl_category_id": 10,
    "guest_visible": 29,
    "id": 2,
    "ignore_period_from": 20,
    "ignore_period_to": 21,
    "include_in_deposit": 32,
    "include_in_stay_cost": 31,
    "infants": 7,
    "interval": 16,
    "interval_limit": 18,
    "interval_multiplier": 17,
    "inventory_item_id": 9,
    "match_occupants": 4,
    "newbook_region": 0,
    "per_adult": 23,
    "per_animal": 26,
    "per_child": 24,
    "per_infant": 25,
    "period_from": 14,
    "period_to": 15,
    "qty": 27,
    "refundable": 35,
    "removed_by": 40,
    "removed_when": 39,
    "set_id": 36,
    "set_name": 37,
    "set_visible": 38,
    "tax_free": 28,
    "tenant": 1,
    "travel_agent_commission": 30
}

schema_attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

schema_name_id: 2628
schema_scan_id: 6663841
updated: 2024-11-05 00:29:35

Schema Scans: 15

Last at 2024-11-05 22:55:04

Scan 6674683

duration: 0:00:12.720580

exit_message:

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

id: 6674683

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_newbookevents_inventory_items/2024-11-05/1730866486",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-05/1730866486/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13706975162934202007,
        "service_name": "drive-thru",
        "span_id": 15647247366158857901,
        "trace_id": 5183454321159541420
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 22:55:04
success: True
trace_id: 5183454321159541420

Scan 6674156

duration: 0:00:15.040443

exit_message:

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

id: 6674156

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_newbookevents_inventory_items/2024-11-05/1730866401",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-05/1730866401/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12127341294853844040,
        "service_name": "drive-thru",
        "span_id": 3091807919694953721,
        "trace_id": 6523319771183111587
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 22:35:35
success: True
trace_id: 6523319771183111587

Scan 6673609

duration: 0:00:15.014104

exit_message:

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

id: 6673609

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_newbookevents_inventory_items/2024-11-05/1730866289",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-05/1730866289/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12756871133241483334,
        "service_name": "drive-thru",
        "span_id": 7631823238845853474,
        "trace_id": 18122190074102611395
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 22:20:28
success: True
trace_id: 18122190074102611395

Scan 6672082

duration: 0:00:15.018950

exit_message:

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

id: 6672082

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_newbookevents_inventory_items/2024-11-04/1730785707",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730785707/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4487952920437410342,
        "service_name": "drive-thru",
        "span_id": 4380356923440371312,
        "trace_id": 7922687492192903706
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 04:27:54
success: True
trace_id: 7922687492192903706

Scan 6671389

duration: 0:00:15.257740

exit_message:

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

id: 6671389

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_newbookevents_inventory_items/2024-11-04/1730785117",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730785117/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5043749584850182712,
        "service_name": "drive-thru",
        "span_id": 8761351385755274503,
        "trace_id": 5916922207551088146
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 03:51:41
success: True
trace_id: 5916922207551088146

Scan 6671035

duration: 0:00:12.537788

exit_message:

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

id: 6671035

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_newbookevents_inventory_items/2024-11-04/1730784812",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730784812/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17654467880755989914,
        "service_name": "drive-thru",
        "span_id": 18094273346880988411,
        "trace_id": 10722299272788248960
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 03:39:50
success: True
trace_id: 10722299272788248960

Scan 6669913

duration: 0:00:14.877743

exit_message:

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

id: 6669913

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_newbookevents_inventory_items/2024-11-04/1730784208",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730784208/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3683319777847897850,
        "service_name": "drive-thru",
        "span_id": 3908595060321116943,
        "trace_id": 1768015747325192298
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 03:09:57
success: True
trace_id: 1768015747325192298

Scan 6669173

duration: 0:00:12.418264

exit_message:

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

id: 6669173

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_newbookevents_inventory_items/2024-11-04/1730784046",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730784046/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13145741060956855203,
        "service_name": "drive-thru",
        "span_id": 17857360149292457704,
        "trace_id": 4980832701971496667
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 02:50:16
success: True
trace_id: 4980832701971496667

Scan 6668325

duration: 0:00:14.887879

exit_message:

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

id: 6668325

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_newbookevents_inventory_items/2024-11-04/1730783842",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730783842/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15450379667209061489,
        "service_name": "drive-thru",
        "span_id": 12550231366918423299,
        "trace_id": 3707017230671487200
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 02:27:51
success: True
trace_id: 3707017230671487200

Scan 6667185

duration: 0:00:15.005068

exit_message:

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

id: 6667185

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_newbookevents_inventory_items/2024-11-04/1730783759",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730783759/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 525057006200397,
        "service_name": "drive-thru",
        "span_id": 17361333696457905744,
        "trace_id": 18223429260365403390
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 01:57:30
success: True
trace_id: 18223429260365403390

Scan 6667179

duration: 0:00:14.961419

exit_message:

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

id: 6667179

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_newbookevents_inventory_items/2024-11-04/1730783658",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730783658/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2801178792956174958,
        "service_name": "drive-thru",
        "span_id": 12164200389609123458,
        "trace_id": 9841310299758931688
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 01:57:19
success: True
trace_id: 9841310299758931688

Scan 6666267

duration: 0:00:12.447824

exit_message:

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

id: 6666267

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_newbookevents_inventory_items/2024-11-04/1730783515",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730783515/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 862714098393550057,
        "service_name": "drive-thru",
        "span_id": 2672489094416665447,
        "trace_id": 655419744785700159
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 01:33:28
success: True
trace_id: 655419744785700159

Scan 6665618

duration: 0:00:12.267880

exit_message:

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

id: 6665618

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_newbookevents_inventory_items/2024-11-04/1730783297",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730783297/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13651741601504152026,
        "service_name": "drive-thru",
        "span_id": 8495161376500434591,
        "trace_id": 5094928301224350771
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 01:16:17
success: True
trace_id: 5094928301224350771

Scan 6664640

duration: 0:00:14.895255

exit_message:

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

id: 6664640

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_newbookevents_inventory_items/2024-11-04/1730782898",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730782898/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15086529336644646964,
        "service_name": "drive-thru",
        "span_id": 14826203543428936795,
        "trace_id": 11959946880470863840
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 00:50:16
success: True
trace_id: 11959946880470863840

Scan 6663841

duration: 0:00:12.333009

exit_message:

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

id: 6663841

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_newbookevents_inventory_items/2024-11-04/1730782799",
        "key": "raw/newbookdev_newbookevents_inventory_items/2024-11-04/1730782799/events_inventory_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8266128039294240099,
        "service_name": "drive-thru",
        "span_id": 11300804494588045618,
        "trace_id": 5100151823920505364
    }
}

running: False
schema_name_id: 2628
start_time: 2024-11-05 00:29:23
success: True
trace_id: 5100151823920505364

Partitions:

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

Schema:

attributes:

{
    "adults": "string",
    "amount": "string",
    "animals": "string",
    "children": "string",
    "daysofweek": "string",
    "daytype": "string",
    "description": "string",
    "disburse_to_owners": "string",
    "discounts_apply": "string",
    "event_id": "string",
    "gl_account_id": "string",
    "gl_category_id": "string",
    "guest_visible": "string",
    "id": "string",
    "ignore_period_from": "string",
    "ignore_period_to": "string",
    "include_in_deposit": "string",
    "include_in_stay_cost": "string",
    "infants": "string",
    "interval": "string",
    "interval_limit": "string",
    "interval_multiplier": "string",
    "inventory_item_id": "string",
    "match_occupants": "string",
    "newbook_region": "string",
    "per_adult": "string",
    "per_animal": "string",
    "per_child": "string",
    "per_infant": "string",
    "period_from": "string",
    "period_to": "string",
    "qty": "string",
    "refundable": "string",
    "removed_by": "string",
    "removed_when": "string",
    "set_id": "string",
    "set_name": "string",
    "set_visible": "string",
    "tax_free": "string",
    "tenant": "string",
    "travel_agent_commission": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-05/1730866486'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
}

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 17:52:47",
        "disabled": false,
        "format": "raw",
        "id": 2628,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookevents_inventory_items"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "adults": "string",
            "amount": "string",
            "animals": "string",
            "children": "string",
            "daysofweek": "string",
            "daytype": "string",
            "description": "string",
            "disburse_to_owners": "string",
            "discounts_apply": "string",
            "event_id": "string",
            "gl_account_id": "string",
            "gl_category_id": "string",
            "guest_visible": "string",
            "id": "string",
            "ignore_period_from": "string",
            "ignore_period_to": "string",
            "include_in_deposit": "string",
            "include_in_stay_cost": "string",
            "infants": "string",
            "interval": "string",
            "interval_limit": "string",
            "interval_multiplier": "string",
            "inventory_item_id": "string",
            "match_occupants": "string",
            "newbook_region": "string",
            "per_adult": "string",
            "per_animal": "string",
            "per_child": "string",
            "per_infant": "string",
            "period_from": "string",
            "period_to": "string",
            "qty": "string",
            "refundable": "string",
            "removed_by": "string",
            "removed_when": "string",
            "set_id": "string",
            "set_name": "string",
            "set_visible": "string",
            "tax_free": "string",
            "tenant": "string",
            "travel_agent_commission": "string"
        },
        "created": "2024-11-05 22:55:05",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `event_id`  string , `match_occupants`  string , `adults`  string , `children`  string , `infants`  string , `animals`  string , `inventory_item_id`  string , `gl_category_id`  string , `gl_account_id`  string , `description`  string , `daytype`  string , `period_from`  string , `period_to`  string , `interval`  string , `interval_multiplier`  string , `interval_limit`  string , `daysofweek`  string , `ignore_period_from`  string , `ignore_period_to`  string , `amount`  string , `per_adult`  string , `per_child`  string , `per_infant`  string , `per_animal`  string , `qty`  string , `tax_free`  string , `guest_visible`  string , `travel_agent_commission`  string , `include_in_stay_cost`  string , `include_in_deposit`  string , `disburse_to_owners`  string , `discounts_apply`  string , `refundable`  string , `set_id`  string , `set_name`  string , `set_visible`  string , `removed_when`  string , `removed_by`  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_newbookevents_inventory_items/2024-11-05/1730866486'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookevents_inventory_items"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}