[
https://issues.apache.org/jira/browse/HIVE-27151?focusedWorklogId=851652&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-851652
]
ASF GitHub Bot logged work on HIVE-27151:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 19/Mar/23 16:46
Start Date: 19/Mar/23 16:46
Worklog Time Spent: 10m
Work Description: amanraj2520 opened a new pull request, #4125:
URL: https://github.com/apache/hive/pull/4125
JIRA : https://issues.apache.org/jira/browse/HIVE-27151
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](https://issues.apache.org/jira/browse/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](https://issues.apache.org/jira/browse/HIVE-20718) has a lot of
merge conflicts with
[HIVE-17040](https://issues.apache.org/jira/browse/HIVE-17040). But after
cherry picking these we have other failures to fix.
I am reverting this ticket for now.
This reverts commit fdaa342534f9ccfac9f1a7b53ef367003366fce8.
Issue Time Tracking
-------------------
Worklog Id: (was: 851652)
Remaining Estimate: 0h
Time Spent: 10m
> Revert "HIVE-21685 Wrong simplification in query with multiple IN clauses"
> --------------------------------------------------------------------------
>
> Key: HIVE-27151
> URL: https://issues.apache.org/jira/browse/HIVE-27151
> Project: Hive
> Issue Type: Sub-task
> Reporter: Aman Raj
> Assignee: Aman Raj
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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 :
> {code:java}
> 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)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
