You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/11/02 19:14:00 UTC
[jira] [Commented] (IMPALA-5114) Impala waits until it's finished
loading data the wrong way to warn that it doesn't recognize a hint
[ 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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org