[jira] [Work started] (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>]

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

Work on TRAFODION-1872 started by Qifan Chen.
---------------------------------------------
> 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)