[ 
https://issues.apache.org/jira/browse/HIVE-20833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vineet Garg updated HIVE-20833:
-------------------------------
    Status: Open  (was: Patch Available)

> 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, 
> HIVE-20833.3.patch, HIVE-20833.4.patch, HIVE-20833.5.patch, HIVE-20833.6.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)

Reply via email to