Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items
- created: 2024-10-08 17:45:01
- disabled: False
- format: raw
- id: 2520
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookbookings_inventory_items" } - type: drivethrucsv
Schema Versions: 15
-
Version 4748276
- created: 2024-11-05 22:40:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-05/1730866381'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-05/1730866381
- id: 4748276
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6674307
- updated: 2024-11-05 22:40:46
-
Version 4747795
- created: 2024-11-05 22:26:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-05/1730866314'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-05/1730866314
- id: 4747795
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6673827
- updated: 2024-11-05 22:26:24
-
Version 4747449
- created: 2024-11-05 22:17:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-05/1730866238'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-05/1730866238
- id: 4747449
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6673480
- updated: 2024-11-05 22:17:18
-
Version 4746847
- created: 2024-11-05 04:27:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-04/1730785657'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730785657
- id: 4746847
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6672077
- updated: 2024-11-05 04:27:44
-
Version 4745716
- created: 2024-11-05 03:36:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-04/1730784781'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730784781
- id: 4745716
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6670932
- updated: 2024-11-05 03:36:56
-
Version 4745240
- created: 2024-11-05 03:24:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-04/1730785087'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730785087
- id: 4745240
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6670455
- updated: 2024-11-05 03:24:27
-
Version 4744345
- created: 2024-11-05 03:00:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-04/1730784178'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730784178
- id: 4744345
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6669562
- updated: 2024-11-05 03:00:43
-
Version 4743753
- created: 2024-11-05 02:44:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-04/1730784016'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730784016
- id: 4743753
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6668970
- updated: 2024-11-05 02:45:09
-
Version 4742999
- created: 2024-11-05 02:25:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-04/1730783834'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730783834
- id: 4742999
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6668215
- updated: 2024-11-05 02:25:13
-
Version 4741825
- created: 2024-11-05 01:53:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-04/1730783635'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730783635
- id: 4741825
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6667039
- updated: 2024-11-05 01:53:58
-
Version 4741792
- created: 2024-11-05 01:52:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-04/1730783728'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730783728
- id: 4741792
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6667009
- updated: 2024-11-05 01:53:05
-
Version 4740830
- created: 2024-11-05 01:27:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-04/1730783484'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730783484
- id: 4740830
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6666045
- updated: 2024-11-05 01:27:47
-
Version 4740046
- created: 2024-11-05 01:06:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-04/1730783265'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730783265
- id: 4740046
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6665262
- updated: 2024-11-05 01:07:06
-
Version 4739253
- created: 2024-11-05 00:45:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-04/1730782868'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730782868
- id: 4739253
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6664468
- updated: 2024-11-05 00:46:03
-
Version 4738853
- created: 2024-11-05 00:35:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-04/1730782776'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730782776
- id: 4738853
- processed: 1
- raw_data:
{ "account_id": 10, "adults": 5, "amount": 26, "animals": 8, "booking_id": 3, "calculation_type": 14, "children": 6, "daysofweek": 22, "daytype": 16, "description": 15, "disburse_to_owners": 38, "discounts_apply": 39, "from_type": 41, "from_type_id": 42, "gl_account_id": 12, "gl_category_id": 11, "guest_visible": 33, "id": 2, "ignore_other_tariffs": 23, "ignore_period_from": 24, "ignore_period_to": 25, "include_in_deposit": 36, "include_in_payment_plan": 37, "include_in_stay_cost": 35, "infants": 7, "interval": 19, "interval_limit": 21, "interval_multiplier": 20, "inventory_item_id": 9, "item_type": 13, "match_occupants": 4, "newbook_region": 0, "per_adult": 27, "per_animal": 30, "per_child": 28, "per_infant": 29, "period_from": 17, "period_to": 18, "qty": 31, "refundable": 40, "removed_by": 48, "removed_when": 47, "set_id": 43, "set_name": 44, "set_offset": 46, "set_visible": 45, "tax_free": 32, "tenant": 1, "travel_agent_commission": 34 } - schema_attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - schema_name_id: 2520
- schema_scan_id: 6664065
- updated: 2024-11-05 00:35:32
Schema Scans: 15
Last at 2024-11-05 22:40:33
-
Scan 6674307
- duration: 0:00:13.053229
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674307
- 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_newbookbookings_inventory_items/2024-11-05/1730866381", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-05/1730866381/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17186424924533706494, "service_name": "drive-thru", "span_id": 4814542898047010927, "trace_id": 1651408204647082560 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 22:40:33
- success: True
- trace_id: 1651408204647082560
-
Scan 6673827
- duration: 0:00:12.518423
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673827
- 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_newbookbookings_inventory_items/2024-11-05/1730866314", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-05/1730866314/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12664350910545355260, "service_name": "drive-thru", "span_id": 15958293926028464212, "trace_id": 10938929626296641963 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 22:26:12
- success: True
- trace_id: 10938929626296641963
-
Scan 6673480
- duration: 0:00:12.815944
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673480
- 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_newbookbookings_inventory_items/2024-11-05/1730866238", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-05/1730866238/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4257072894834374594, "service_name": "drive-thru", "span_id": 643715284053560893, "trace_id": 10174944629169821841 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 22:17:05
- success: True
- trace_id: 10174944629169821841
-
Scan 6672077
- duration: 0:00:15.363686
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6672077
- 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_newbookbookings_inventory_items/2024-11-04/1730785657", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730785657/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10058991291032600383, "service_name": "drive-thru", "span_id": 9333913622861653361, "trace_id": 13571449249046358337 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 04:27:29
- success: True
- trace_id: 13571449249046358337
-
Scan 6670932
- duration: 0:00:12.738132
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670932
- 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_newbookbookings_inventory_items/2024-11-04/1730784781", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730784781/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3352685798102077176, "service_name": "drive-thru", "span_id": 16956764454430406611, "trace_id": 1539761680051095443 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 03:36:43
- success: True
- trace_id: 1539761680051095443
-
Scan 6670455
- duration: 0:00:12.604261
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670455
- 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_newbookbookings_inventory_items/2024-11-04/1730785087", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730785087/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8736698468650622728, "service_name": "drive-thru", "span_id": 4178016959486364221, "trace_id": 17314996163420292035 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 03:24:14
- success: True
- trace_id: 17314996163420292035
-
Scan 6669562
- duration: 0:00:15.253474
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669562
- 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_newbookbookings_inventory_items/2024-11-04/1730784178", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730784178/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3041005960947187058, "service_name": "drive-thru", "span_id": 1557883377585913737, "trace_id": 681249105615990465 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 03:00:28
- success: True
- trace_id: 681249105615990465
-
Scan 6668970
- duration: 0:00:12.557584
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668970
- 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_newbookbookings_inventory_items/2024-11-04/1730784016", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730784016/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8656078937641152463, "service_name": "drive-thru", "span_id": 5618694927238881152, "trace_id": 2361843473068530857 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 02:44:57
- success: True
- trace_id: 2361843473068530857
-
Scan 6668215
- duration: 0:00:15.513078
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668215
- 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_newbookbookings_inventory_items/2024-11-04/1730783834", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730783834/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15024617495626466160, "service_name": "drive-thru", "span_id": 7622799810915243757, "trace_id": 9375997880916306104 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 02:24:58
- success: True
- trace_id: 9375997880916306104
-
Scan 6667039
- duration: 0:00:15.188787
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667039
- 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_newbookbookings_inventory_items/2024-11-04/1730783635", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730783635/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10420109362524617050, "service_name": "drive-thru", "span_id": 9025509726106381271, "trace_id": 14222100931273738210 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 01:53:43
- success: True
- trace_id: 14222100931273738210
-
Scan 6667009
- duration: 0:00:14.962274
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667009
- 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_newbookbookings_inventory_items/2024-11-04/1730783728", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730783728/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5137030958858607627, "service_name": "drive-thru", "span_id": 14907692408018355895, "trace_id": 4973831236257733298 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 01:52:50
- success: True
- trace_id: 4973831236257733298
-
Scan 6666045
- duration: 0:00:12.527687
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666045
- 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_newbookbookings_inventory_items/2024-11-04/1730783484", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730783484/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8343670569709818790, "service_name": "drive-thru", "span_id": 6836914522061871397, "trace_id": 11833389346379290426 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 01:27:34
- success: True
- trace_id: 11833389346379290426
-
Scan 6665262
- duration: 0:00:12.495842
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665262
- 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_newbookbookings_inventory_items/2024-11-04/1730783265", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730783265/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13994463987918046581, "service_name": "drive-thru", "span_id": 8781784281198728585, "trace_id": 7187363862064505747 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 01:06:54
- success: True
- trace_id: 7187363862064505747
-
Scan 6664468
- duration: 0:00:12.619518
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664468
- 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_newbookbookings_inventory_items/2024-11-04/1730782868", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730782868/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13429981844125927092, "service_name": "drive-thru", "span_id": 4144296909457440338, "trace_id": 1341871664402892929 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 00:45:50
- success: True
- trace_id: 1341871664402892929
-
Scan 6664065
- duration: 0:00:13.022075
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664065
- 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_newbookbookings_inventory_items/2024-11-04/1730782776", "key": "raw/newbookdev_newbookbookings_inventory_items/2024-11-04/1730782776/bookings_inventory_items.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9314372300265283496, "service_name": "drive-thru", "span_id": 4758276952673273733, "trace_id": 17885593904519421722 } } - running: False
- schema_name_id: 2520
- start_time: 2024-11-05 00:35:19
- success: True
- trace_id: 17885593904519421722
- attributes:
{ "account_id": "string", "adults": "string", "amount": "string", "animals": "string", "booking_id": "string", "calculation_type": "string", "children": "string", "daysofweek": "string", "daytype": "string", "description": "string", "disburse_to_owners": "string", "discounts_apply": "string", "from_type": "string", "from_type_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guest_visible": "string", "id": "string", "ignore_other_tariffs": "string", "ignore_period_from": "string", "ignore_period_to": "string", "include_in_deposit": "string", "include_in_payment_plan": "string", "include_in_stay_cost": "string", "infants": "string", "interval": "string", "interval_limit": "string", "interval_multiplier": "string", "inventory_item_id": "string", "item_type": "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_offset": "string", "set_visible": "string", "tax_free": "string", "tenant": "string", "travel_agent_commission": "string" } - created: 2024-11-05 22:40:35
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-05/1730866381'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2024-10-08 17:45:01",
"disabled": false,
"format": "raw",
"id": 2520,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookbookings_inventory_items"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"account_id": "string",
"adults": "string",
"amount": "string",
"animals": "string",
"booking_id": "string",
"calculation_type": "string",
"children": "string",
"daysofweek": "string",
"daytype": "string",
"description": "string",
"disburse_to_owners": "string",
"discounts_apply": "string",
"from_type": "string",
"from_type_id": "string",
"gl_account_id": "string",
"gl_category_id": "string",
"guest_visible": "string",
"id": "string",
"ignore_other_tariffs": "string",
"ignore_period_from": "string",
"ignore_period_to": "string",
"include_in_deposit": "string",
"include_in_payment_plan": "string",
"include_in_stay_cost": "string",
"infants": "string",
"interval": "string",
"interval_limit": "string",
"interval_multiplier": "string",
"inventory_item_id": "string",
"item_type": "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_offset": "string",
"set_visible": "string",
"tax_free": "string",
"tenant": "string",
"travel_agent_commission": "string"
},
"created": "2024-11-05 22:40:35",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`\n(\n `newbook_region` string , `tenant` string , `id` string , `booking_id` string , `match_occupants` string , `adults` string , `children` string , `infants` string , `animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `item_type` string , `calculation_type` string , `description` string , `daytype` string , `period_from` string , `period_to` string , `interval` string , `interval_multiplier` string , `interval_limit` string , `daysofweek` string , `ignore_other_tariffs` 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 , `include_in_payment_plan` string , `disburse_to_owners` string , `discounts_apply` string , `refundable` string , `from_type` string , `from_type_id` string , `set_id` string , `set_name` string , `set_visible` string , `set_offset` 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_newbookbookings_inventory_items/2024-11-05/1730866381'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookbookings_inventory_items"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}