[HIVE-16776] Strange cast behavior for table backed by druid

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: Druid integration
• Target Version/s: 3.0.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Slim Bouguerra
• Created: 26/May/17 18:33
• Updated: 27/Feb/24 22:24
• Resolved: 31/May/17 14:55

Description

The following query

 
explain select SUBSTRING(`Calcs`.`str0`,CAST(`Calcs`.`int2` AS int), 3) from `druid_tableau`.`calcs` `Calcs`;
OK
Plan not optimized by CBO. 

fails the cbo with the following exception

 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]

.