[
https://issues.apache.org/jira/browse/HIVE-27008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17701332#comment-17701332
]
Aman Raj commented on HIVE-27008:
---------------------------------
The issue is because Hive is not able to parse the following statements :
explain cbo
select * from very_simple_table_for_in_test where name IN('g','r') AND name
IN('a','b')
Therefore the HiveParser exception as pasted above.
This fix was present in https://issues.apache.org/jira/browse/HIVE-20718 but to
cherry pick this we need to cherry pick
https://issues.apache.org/jira/browse/HIVE-17040 since HIVE-20718 has a lot of
merge conflicts with HIVE-17040
[~vihangk1] I have tested cherry picking both these commits in my local. These
tests are resolved. Does this sound good?
> Fix multi_in_clause.q and current_date_timestamp tests in branch-3
> ------------------------------------------------------------------
>
> Key: HIVE-27008
> URL: https://issues.apache.org/jira/browse/HIVE-27008
> Project: Hive
> Issue Type: Sub-task
> Reporter: Aman Raj
> Assignee: Aman Raj
> Priority: Major
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> These tests are failing for branch-3 with the following exceptions :
> Client execution failed with error code = 40000 running "
> explain cbo
> select * from very_simple_table_for_in_test where name IN('g','r') AND name
> IN('a','b') " fname=multi_in_clause.q
> See ./ql/target/tmp/log/hive.log or ./itests/qtest/target/tmp/log/hive.log,
> or check ./ql/target/surefire-reports or
> ./itests/qtest/target/surefire-reports/ for specific test cases logs.
> {code:java}
> 2023-03-16 04:06:17 Completed running task attempt:
> attempt_1678964507586_0001_175_01_000000_02023-03-16 04:06:17 Completed Dag:
> dag_1678964507586_0001_175TRACE StatusLogger Log4jLoggerFactory.getContext()
> found anchor class org.apache.hadoop.hive.ql.exec.OperatorTRACE StatusLogger
> Log4jLoggerFactory.getContext() found anchor class
> org.apache.hadoop.hive.ql.stats.fs.FSStatsPublisherTRACE StatusLogger
> Log4jLoggerFactory.getContext() found anchor class
> org.apache.hadoop.hive.ql.stats.fs.FSStatsAggregatorNoViableAltException(24@[])
> at
> org.apache.hadoop.hive.ql.parse.HiveParser.explainStatement(HiveParser.java:1512)
> at
> org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1407)
> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:230)
> at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:79) at
> org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:72) at
> org.apache.hadoop.hive.ql.Driver.compile(Driver.java:617) at
> org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1854) at
> org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1801) at
> org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1796) at
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
> at
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:214)
> at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239)
> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:188) at
> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:402) at
> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:335) at
> org.apache.hadoop.hive.ql.QTestUtil.executeClientInternal(QTestUtil.java:1474)
> at
> org.apache.hadoop.hive.ql.QTestUtil.executeClient(QTestUtil.java:1448)
> at
> org.apache.hadoop.hive.cli.control.CoreCliDriver.runTest(CoreCliDriver.java:177)
> at
> org.apache.hadoop.hive.cli.control.CliAdapter.runTest(CliAdapter.java:104)
> at
> org.apache.hadoop.hive.cli.split12.TestMiniLlapLocalCliDriver.testCliDriver(TestMiniLlapLocalCliDriver.java:62)
> 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.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
> at
> org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
> at
> org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
> at
> org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
> at
> org.apache.hadoop.hive.cli.control.CliAdapter$2$1.evaluate(CliAdapter.java:92)
> at org.junit.rules.RunRules.evaluate(RunRules.java:20) {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
