[jira] [Created] (TRAFODION-1872) Compiler may loop when compiling a query referring to bucketed hive tables with more than one bucketing column

["Qifan Chen (JIRA)" <ji...@apache.org>]

Qifan Chen created TRAFODION-1872:
-------------------------------------

             Summary: Compiler may loop when compiling a query referring to bucketed hive tables with more than one bucketing column
                 Key: TRAFODION-1872
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1872
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Qifan Chen
            Assignee: Qifan Chen


The compilation of the following DML will loop until the memory is exhausted. 

prepare xx from select count(*) from store_sales_orc

The hive table  is defined as follows. 

create table store_sales_orc
(
ss_sold_date_sk           int,
ss_sold_time_sk           int,
ss_item_sk                int,
ss_customer_sk            int,
ss_cdemo_sk               int,
ss_hdemo_sk               int,
ss_addr_sk                int,
ss_store_sk               int,
ss_promo_sk               int,
ss_ticket_number          int,
ss_quantity               int,
ss_wholesale_cost         float,
ss_list_price             float,
ss_sales_price            float,
ss_ext_discount_amt       float,
ss_ext_sales_price        float,
ss_ext_wholesale_cost     float,
ss_ext_list_price         float,
ss_ext_tax                float,
ss_coupon_amt             float,
ss_net_paid               float,
ss_net_paid_inc_tax       float,
ss_net_profit             float
)
clustered by (ss_item_sk,ss_ticket_number) sorted by (ss_item_sk,ss_ticket_number) into 8 buckets
stored as ORC tblproperties ("orc.stripe.size"="67108864");



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)