hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-16776) Strange cast behavior for table backed by druid
Date Fri, 26 May 2017 18:34:04 GMT
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)

Mime
View raw message