[
https://issues.apache.org/jira/browse/HIVE-15258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15685951#comment-15685951
]
Ashutosh Chauhan commented on HIVE-15258:
-----------------------------------------
Stack trace:
{code}
2016-11-21T23:21:28,641 DEBUG [242fd792-2ede-470e-98a3-cb3d0676254c main]
parse.CalcitePlanner: genSelectPlan: input = vector_interval_1{(ts,ts:
timestamp)(dt,dt: date)(str1,str1: string)(str2,str2:
string)(block__offset__inside__file,BLOCK__OFFSET__INSIDE__FILE:
bigint)(input__file__name,INPUT__FILE__NAME: string)(row__id,ROW__ID:
struct<transactionid:bigint,bucketid:int,rowid:bigint>)} starRr = null
2016-11-21T23:21:28,642 ERROR [242fd792-2ede-470e-98a3-cb3d0676254c main]
parse.CalcitePlanner: CBO failed, skipping CBO.
org.apache.hadoop.hive.ql.parse.SemanticException: Line 0:-1 Invalid function
'TOK_INTERVAL_YEAR_MONTH_LITERAL'
at
org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.getXpathOrFuncExprNodeDesc(TypeCheckProcFactory.java:877)
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
at
org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckProcFactory.java:1248)
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
{code}
{code}
parse.CalcitePlanner (CalcitePlanner.java:genOPTree(324)) - CBO failed,
skipping CBO.
org.apache.hadoop.hive.ql.optimizer.calcite.CalciteSemanticException:
INTERVAL_DAY_TIME is not well supported
at
org.apache.hadoop.hive.ql.optimizer.calcite.translator.RexNodeConverter.convert(RexNodeConverter.java:520)
~[
{code}
> Enable CBO on queries involving interval literals
> -------------------------------------------------
>
> Key: HIVE-15258
> URL: https://issues.apache.org/jira/browse/HIVE-15258
> Project: Hive
> Issue Type: Bug
> Components: CBO, Query Planning
> Reporter: Ashutosh Chauhan
> Assignee: Ashutosh Chauhan
>
> Currently, queries fail and fall back to non-cbo path.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
