[jira] [Created] (HIVE-16776) Strange cast behavior for table backed by druid

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

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)