[
https://issues.apache.org/jira/browse/HIVE-16776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16029886#comment-16029886
]
Jesus Camacho Rodriguez commented on HIVE-16776:
------------------------------------------------
Fails are unrelated. [~ashutoshc], could you take a look? Thanks
> 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
> Attachments: HIVE-16776.patch
>
>
> 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)
