[
https://issues.apache.org/jira/browse/IMPALA-5114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16673568#comment-16673568
]
Tim Armstrong commented on IMPALA-5114:
---------------------------------------
Maybe impala-shell could fetch the error log earlier?
> 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
> Components: Clients
> Affects Versions: Impala 2.9.0
> Reporter: Matthew Mulder
> Priority: Minor
> Labels: usability
>
> 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
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
