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)