[HIVE-27008] Fix multi_in_clause.q and current_date_timestamp tests in branch-3

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: pull-request-available
• Target Version/s: 3.2.0
• Assignee: Aman Raj
• Reporter: Aman Raj
• Created: 31/Jan/23 17:45
• Updated: 06/Apr/23 09:00

Description

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.

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) 

Issue Links

• requires: HIVE-17040 Join elimination in the presence of FK relationship
• requires: HIVE-20718 Add perf cli driver with constraints
• links to: GitHub Pull Request #4004