impala-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matthew Mulder (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IMPALA-5114) Impala waits until it's finished loading data the wrong way to warn that it doesn't recognize a hint
Date Fri, 24 Mar 2017 17:57:41 GMT
Matthew Mulder created IMPALA-5114:
--------------------------------------

             Summary: Impala waits until it's finished loading data the wrong way to warn
that it doesn't recognize a hint
                 Key: IMPALA-5114
                 URL: https://issues.apache.org/jira/browse/IMPALA-5114
             Project: IMPALA
          Issue Type: Bug
    Affects Versions: Impala 2.9.0
            Reporter: Matthew Mulder
            Priority: Minor


It's a bad user experience to be warned at the end of a half-hour data load that Impala didn't
recognize a hint. If the warning had been given immediately, I would have canceled the load
and tried a different way. An error would be even better so that I wouldn't have to cancel
the load and clean up the partial load.{code}> create table store_sales_denorm_part_store_sort_sold_time
partitioned by (ss_store_sk) stored as parquet as select /* +sortby(ss_sold_time_sk) */ ss_sold_time_sk,
ss_item_sk, ss_customer_sk, ss_cdemo_sk, ss_hdemo_sk, ss_addr_sk, ss_promo_sk, ss_ticket_number,
ss_quantity, ss_wholesale_cost, ss_list_price, ss_sales_price, ss_ext_discount_amt, ss_ext_sales_price,
ss_ext_wholesale_cost, ss_ext_list_price, ss_ext_tax, ss_coupon_amt, ss_net_paid, ss_net_paid_inc_tax,
ss_net_profit, ss_sold_date_sk, d_date, t_time, t_hour, t_minute, customer_name, ss_store_sk
from store_sales_denorm_base;
Query: create table store_sales_denorm_part_store_sort_sold_time partitioned by (ss_store_sk)
stored as parquet as select /* +sortby(ss_sold_time_sk) */ ss_sold_time_sk, ss_item_sk, ss_customer_sk,
ss_cdemo_sk, ss_hdemo_sk, ss_addr_sk, ss_promo_sk, ss_ticket_number, ss_quantity, ss_wholesale_cost,
ss_list_price, ss_sales_price, ss_ext_discount_amt, ss_ext_sales_price, ss_ext_wholesale_cost,
ss_ext_list_price, ss_ext_tax, ss_coupon_amt, ss_net_paid, ss_net_paid_inc_tax, ss_net_profit,
ss_sold_date_sk, d_date, t_time, t_hour, t_minute, customer_name, ss_store_sk from store_sales_denorm_base
Query submitted at: 2017-03-23 17:57:22 (Coordinator: http://localhost:25000)
Query progress can be monitored at: http://localhost:25000/query_plan?query_id=3d472937805a436b:345e931500000000
+----------------------------+
| summary                    |
+----------------------------+
| Inserted 2653186612 row(s) |
+----------------------------+
WARNINGS: PLAN hint not recognized: sortby(ss_sold_time_sk)
Fetched 1 row(s) in 1964.82s{code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message