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)
