[
https://issues.apache.org/jira/browse/HIVE-20833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vineet Garg updated HIVE-20833:
-------------------------------
Status: Patch Available (was: Open)
> 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
> Assignee: Vineet Garg
> Priority: Major
> Attachments: HIVE-20833.1.patch, HIVE-20833.2.patch
>
>
> 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)
