Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Tue, 18 Apr 2017 09:14:42 +0000 (UTC)
From: "Jesus Camacho Rodriguez (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13045711.1487875841000.304142.1492506882047@Atlassian.JIRA>
In-Reply-To: <JIRA.13045711.1487875841000@Atlassian.JIRA>
References: <JIRA.13045711.1487875841000@Atlassian.JIRA> <JIRA.13045711.1487875841389@jira-lw-us.apache.org>
Subject: [jira] [Assigned] (HIVE-16025) Where IN clause throws exception
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 18 Apr 2017 09:14:47 -0000


     [ https://issues.apache.org/jira/browse/HIVE-16025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesus Camacho Rodriguez reassigned HIVE-16025:
----------------------------------------------

    Assignee: slim bouguerra

> Where IN clause throws exception
> --------------------------------
>
>                 Key: HIVE-16025
>                 URL: https://issues.apache.org/jira/browse/HIVE-16025
>             Project: Hive
>          Issue Type: Bug
>          Components: Druid integration
>            Reporter: slim bouguerra
>            Assignee: slim bouguerra
>            Priority: Critical
>             Fix For: 3.0.0
>
>
> {code}
> select * from login_druid where userid IN ("user1", "user2");
> Exception in thread "main" java.lang.AssertionError: cannot translate filter: IN($1, _UTF-16LE'user1', _UTF-16LE'user2')
> 	at org.apache.calcite.adapter.druid.DruidQuery$Translator.translateFilter(DruidQuery.java:886)
> 	at org.apache.calcite.adapter.druid.DruidQuery$Translator.access$000(DruidQuery.java:786)
> 	at org.apache.calcite.adapter.druid.DruidQuery.getQuery(DruidQuery.java:424)
> 	at org.apache.calcite.adapter.druid.DruidQuery.deriveQuerySpec(DruidQuery.java:402)
> 	at org.apache.calcite.adapter.druid.DruidQuery.getQuerySpec(DruidQuery.java:351)
> 	at org.apache.calcite.adapter.druid.DruidQuery.deriveRowType(DruidQuery.java:271)
> 	at org.apache.calcite.rel.AbstractRelNode.getRowType(AbstractRelNode.java:219)
> 	at org.apache.calcite.plan.RelOptUtil.verifyTypeEquivalence(RelOptUtil.java:343)
> 	at org.apache.calcite.plan.hep.HepRuleCall.transformTo(HepRuleCall.java:57)
> 	at org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:225)
> 	at org.apache.calcite.adapter.druid.DruidRules$DruidFilterRule.onMatch(DruidRules.java:142)
> 	at org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:314)
> 	at org.apache.calcite.plan.hep.HepPlanner.applyRule(HepPlanner.java:502)
> 	at org.apache.calcite.plan.hep.HepPlanner.applyRules(HepPlanner.java:381)
> 	at org.apache.calcite.plan.hep.HepPlanner.executeInstruction(HepPlanner.java:247)
> 	at org.apache.calcite.plan.hep.HepInstruction$RuleInstance.execute(HepInstruction.java:125)
> 	at org.apache.calcite.plan.hep.HepPlanner.executeProgram(HepPlanner.java:206)
> 	at org.apache.calcite.plan.hep.HepPlanner.findBestExp(HepPlanner.java:193)
> 	at org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction.hepPlan(CalcitePlanner.java:1775)
> 	at org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction.apply(CalcitePlanner.java:1504)
> 	at org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction.apply(CalcitePlanner.java:1260)
> 	at org.apache.calcite.tools.Frameworks$1.apply(Frameworks.java:113)
> 	at org.apache.calcite.prepare.CalcitePrepareImpl.perform(CalcitePrepareImpl.java:997)
> 	at org.apache.calcite.tools.Frameworks.withPrepare(Frameworks.java:149)
> 	at org.apache.calcite.tools.Frameworks.withPlanner(Frameworks.java:106)
> 	at org.apache.hadoop.hive.ql.parse.CalcitePlanner.logicalPlan(CalcitePlanner.java:1068)
> 	at org.apache.hadoop.hive.ql.parse.CalcitePlanner.getOptimizedAST(CalcitePlanner.java:1084)
> 	at org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:363)
> 	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:11026)
> 	at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:285)
> 	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:258)
> 	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:511)
> 	at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1317)
> 	at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1457)
> 	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1237)
> 	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1227)
> 	at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:233)
> 	at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:184)
> 	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403)
> 	at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:821)
> 	at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:759)
> 	at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:686)
> 	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:233)
> 	at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
> {code}


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)