libo created HIVE-24318:
---------------------------
Summary: 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
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)
