Vineet Garg created HIVE-20833:
----------------------------------
Summary: package.jdo needs to be updated to conform with
HIVE-20221 changes
Key: HIVE-20833
URL: https://issues.apache.org/jira/browse/HIVE-20833
Project: Hive
Issue Type: Bug
Affects Versions: 4.0.0
Reporter: Vineet Garg
Following test if run with TestMiniLlapLocalCliDriver will fail:
{code:sql}
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;
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
