Jesus Camacho Rodriguez created HIVE-16776:
----------------------------------------------
Summary: Strange cast behavior for table backed by druid
Key: HIVE-16776
URL: https://issues.apache.org/jira/browse/HIVE-16776
Project: Hive
Issue Type: Bug
Components: Druid integration
Affects Versions: 3.0.0
Reporter: slim bouguerra
Assignee: Jesus Camacho Rodriguez
The following query
{code}
explain select SUBSTRING(`Calcs`.`str0`,CAST(`Calcs`.`int2` AS int), 3) from
`druid_tableau`.`calcs` `Calcs`;
OK
Plan not optimized by CBO.
{code}
fails the cbo with the following exception
{code} org.apache.hadoop.hive.ql.parse.SemanticException: Line 0:-1 Wrong
arguments '3': No matching method for class
org.apache.hadoop.hive.ql.udf.UDFSubstr with (string, bigint, int). Po
ssible choices: _FUNC_(binary, int) _FUNC_(binary, int, int) _FUNC_(string,
int) _FUNC_(string, int, int)
at
org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckProcFactory.java:1355)
~[hive-exec-2.1.0.2.6.0.2-SNAPSHOT.jar:2.1.0.2.6.0.2-SNA
PSHOT]{code}.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
