You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "libo (Jira)" <ji...@apache.org> on 2020/10/28 10:55:00 UTC
[jira] [Updated] (HIVE-24318) When GlobalLimit is efficient, query
will run twice with "Retry query with a different approach..."
[ https://issues.apache.org/jira/browse/HIVE-24318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
libo updated HIVE-24318:
------------------------
Attachment: HIVE-24318.patch
Assignee: libo
Status: Patch Available (was: Open)
> When GlobalLimit is efficient, query will run twice with "Retry query with a different approach..."
> ---------------------------------------------------------------------------------------------------
>
> Key: HIVE-24318
> URL: https://issues.apache.org/jira/browse/HIVE-24318
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: 2.0.1
> Environment: Hadoop 2.6.0
> Hive-2.0.1
> Reporter: libo
> Assignee: libo
> Priority: Minor
> Attachments: HIVE-24318.patch
>
>
> hive.limit.optimize.enable=true
> hive.limit.row.max.size=10000000
> hive.limit.optimize.fetch.max=1000
> hive.fetch.task.conversion.threshold=25600000000
> hive.fetch.task.conversion=more
>
> *sql eg:*
> select db_name,concat(tb_name,'test') from (select * from test1.t3 where dt='0909' limit 10)t1;
> (only partitioned table)
> *console information:*
> Retry query with a different approach...
>
> *exception stack:*
> org.apache.hadoop.hive.ql.CommandNeedRetryException
> at org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:147)
> at org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:2022)
> at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:317)
> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:232)
> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:475)
> at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:855)
> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:794)
> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:721)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.apache.hadoop.util.RunJar.run(RunJar.java:323)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:236)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)