package.jdo needs to be updated to conform with HIVE-20221 changes

CREATE TABLE `alterPartTbl`(
   `po_header_id` bigint,
   `vendor_num` string,
   `requester_name` string,
   `approver_name` string,
   `buyer_name` string,
   `preparer_name` string,
   `po_requisition_number` string,
   `po_requisition_id` bigint,
   `po_requisition_desc` string,
   `rate_type` string,
   `rate_date` date,
   `rate` double,
   `blanket_total_amount` double,
   `authorization_status` string,
   `revision_num` bigint,
   `revised_date` date,
   `approved_flag` string,
   `approved_date` timestamp,
   `amount_limit` double,
   `note_to_authorizer` string,
   `note_to_vendor` string,
   `note_to_receiver` string,
   `vendor_order_num` string,
   `comments` string,
   `acceptance_required_flag` string,
   `acceptance_due_date` date,
   `closed_date` timestamp,
   `user_hold_flag` string,
   `approval_required_flag` string,
   `cancel_flag` string,
   `firm_status_lookup_code` string,
   `firm_date` date,
   `frozen_flag` string,
   `closed_code` string,
   `org_id` bigint,
   `reference_num` string,
   `wf_item_type` string,
   `wf_item_key` string,
   `submit_date` date,
   `sap_company_code` string,
   `sap_fiscal_year` bigint,
   `po_number` string,
   `sap_line_item` bigint,
   `closed_status_flag` string,
   `balancing_segment` string,
   `cost_center_segment` string,
   `base_amount_limit` double,
   `base_blanket_total_amount` double,
   `base_open_amount` double,
   `base_ordered_amount` double,
   `cancel_date` timestamp,
   `cbc_accounting_date` date,
   `change_requested_by` string,
   `change_summary` string,
   `confirming_order_flag` string,
   `document_creation_method` string,
   `edi_processed_flag` string,
   `edi_processed_status` string,
   `enabled_flag` string,
   `encumbrance_required_flag` string,
   `end_date` date,
   `end_date_active` date,
   `from_header_id` bigint,
   `from_type_lookup_code` string,
   `global_agreement_flag` string,
   `government_context` string,
   `interface_source_code` string,
   `ledger_currency_code` string,
   `open_amount` double,
   `ordered_amount` double,
   `pay_on_code` string,
   `payment_term_name` string,
   `pending_signature_flag` string,
   `po_revision_num` double,
   `preparer_id` bigint,
   `price_update_tolerance` double,
   `print_count` double,
   `printed_date` date,
   `reply_date` date,
   `reply_method_lookup_code` string,
   `rfq_close_date` date,
   `segment2` string,
   `segment3` string,
   `segment4` string,
   `segment5` string,
   `shipping_control` string,
   `start_date` date,
   `start_date_active` date,
   `summary_flag` string,
   `supply_agreement_flag` string,
   `usd_amount_limit` double,
   `usd_blanket_total_amount` double,
   `usd_exchange_rate` double,
   `usd_open_amount` double,
   `usd_order_amount` double,
   `ussgl_transaction_code` string,
   `xml_flag` string,
   `purchasing_organization_id` bigint,
   `purchasing_group_code` string,
   `last_updated_by_name` string,
   `created_by_name` string,
   `incoterms_1` string,
   `incoterms_2` string,
   `ame_approval_id` double,
   `ame_transaction_type` string,
   `auto_sourcing_flag` string,
   `cat_admin_auth_enabled_flag` string,
   `clm_document_number` string,
   `comm_rev_num` double,
   `consigned_consumption_flag` string,
   `consume_req_demand_flag` string,
   `conterms_articles_upd_date` timestamp,
   `conterms_deliv_upd_date` timestamp,
   `conterms_exist_flag` string,
   `cpa_reference` double,
   `created_language` string,
   `email_address` string,
   `enable_all_sites` string,
   `fax` string,
   `lock_owner_role` string,
   `lock_owner_user_id` double,
   `min_release_amount` double,
   `mrc_rate` string,
   `mrc_rate_date` string,
   `mrc_rate_type` string,
   `otm_recovery_flag` string,
   `otm_status_code` string,
   `pay_when_paid` string,
   `pcard_id` bigint,
   `program_update_date` timestamp,
   `quotation_class_code` string,
   `quote_type_lookup_code` string,
   `quote_vendor_quote_number` string,
   `quote_warning_delay` double,
   `quote_warning_delay_unit` string,
   `retro_price_apply_updates_flag` string,
   `retro_price_comm_updates_flag` string,
   `style_id` double,
   `supplier_auth_enabled_flag` string,
   `supplier_notif_method` string,
   `tax_attribute_update_code` string,
   `update_sourcing_rules_flag` string,
   `xml_change_send_date` timestamp,
   `xml_send_date` timestamp,
   `primary_po_distribution_id` bigint,
   `primary_dist_code_combination_id` bigint,
   `group_requisitions` string,
   `group_requisition_lines` string,
   `use_need_by_date` string,
   `use_ship_to` string,
   `document_status` string,
   `prc_bu_id` bigint,
   `req_bu_id` bigint,
   `default_taxation_country` string,
   `tax_document_subtype` string,
   `del_flag` int)
 PARTITIONED BY (
   `source_system_name` string);

alter table alterPartTbl add partition(source_system_name='CCL');

drop table alterPartTbl;