[HIVE-27151] Revert "HIVE-21685 Wrong simplification in query with multiple IN clauses"

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.2.0
• Labels: pull-request-available
• Assignee: Aman Raj
• Reporter: Aman Raj
• Created: 19/Mar/23 16:43
• Updated: 24/Mar/23 19:16
• Resolved: 23/Mar/23 18:01

Description

The multi_in_clause.q fails because Hive is not able to parse 
explain cbo
select * from very_simple_table_for_in_test where name IN('g','r') AND name IN('a','b')
If we want this to work, I am able to do it in my local. We have 2 options :
a. Either revert HIVE-21685 since this scenario was not validated back then before adding this test.
b. 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. But after cherry picking these we have other failures to fix.
 
I am reverting this ticket for now.

Exception stacktrace :

2023-03-16 12:33:11 Completed running task attempt: attempt_1678994907903_0001_185_01_000000_02023-03-16 12:33:11 Completed Dag: dag_1678994907903_0001_185TRACE 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) 

Issue Links

• links to: GitHub Pull Request #4125