[ https://issues.apache.org/jira/browse/HIVE-7721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laljo John Pullokkaran resolved HIVE-7721. ------------------------------------------ Resolution: Fixed > CBO: support case statement translation to optiq > ------------------------------------------------ > > Key: HIVE-7721 > URL: https://issues.apache.org/jira/browse/HIVE-7721 > Project: Hive > Issue Type: Sub-task > Reporter: Harish Butani > Assignee: Laljo John Pullokkaran > > Following query: > {code} > explain select case when key > '104' then null else key end as key from src > {code} > fails with: > {quote} > java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.RuntimeException: Unsupported Expression > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer$OptiqBasedPlanner.getOptimizedAST(SemanticAnalyzer.java:11808) > .... > aused by: java.lang.RuntimeException: Unsupported Expression > at > org.apache.hadoop.hive.ql.optimizer.optiq.translator.RexNodeConverter.convert(RexNodeConverter.java:91) > at > org.apache.hadoop.hive.ql.optimizer.optiq.translator.RexNodeConverter.convert(RexNodeConverter.java:124) > {quote} -- This message was sent by Atlassian JIRA (v6.2#6252)