hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nemon Lou (JIRA)" <>
Subject [jira] [Created] (HIVE-14390) Wrong Table alias when CBO is on
Date Sat, 30 Jul 2016 08:19:20 GMT
Nemon Lou created HIVE-14390:

             Summary: Wrong Table alias when CBO is on
                 Key: HIVE-14390
             Project: Hive
          Issue Type: Bug
          Components: CBO
    Affects Versions: 1.2.1
            Reporter: Nemon Lou
            Priority: Minor

There are 5 web_sales references in query95 of tpcds ,with alias ws1-ws5.
But the query plan only has ws1 when CBO is on.
query95 :
SELECT count(distinct ws1.ws_order_number) as order_count,
               sum(ws1.ws_ext_ship_cost) as total_shipping_cost,
               sum(ws1.ws_net_profit) as total_net_profit
FROM web_sales ws1
JOIN customer_address ca ON (ws1.ws_ship_addr_sk = ca.ca_address_sk)
JOIN web_site s ON (ws1.ws_web_site_sk = s.web_site_sk)
JOIN date_dim d ON (ws1.ws_ship_date_sk = d.d_date_sk)
LEFT SEMI JOIN (SELECT ws2.ws_order_number as ws_order_number
                               FROM web_sales ws2 JOIN web_sales ws3
                               ON (ws2.ws_order_number = ws3.ws_order_number)
                               WHERE ws2.ws_warehouse_sk <> ws3.ws_warehouse_sk
                        ) ws_wh1
ON (ws1.ws_order_number = ws_wh1.ws_order_number)
LEFT SEMI JOIN (SELECT wr_order_number
                               FROM web_returns wr
                               JOIN (SELECT ws4.ws_order_number as ws_order_number
                                          FROM web_sales ws4 JOIN web_sales ws5
                                          ON (ws4.ws_order_number = ws5.ws_order_number)
                                         WHERE ws4.ws_warehouse_sk <> ws5.ws_warehouse_sk
                                ) ws_wh2
                               ON (wr.wr_order_number = ws_wh2.ws_order_number)) tmp1
ON (ws1.ws_order_number = tmp1.wr_order_number)
WHERE d.d_date between '2002-05-01' and '2002-06-30' and
               ca.ca_state = 'GA' and
               s.web_company_name = 'pri';

This message was sent by Atlassian JIRA

View raw message