[jira] [Commented] (HIVE-22800) GenericUDFOPDTIPlus should support varchar

["Zoltan Haindrich (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-22800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17027410#comment-17027410 ] 

Zoltan Haindrich commented on HIVE-22800:
-----------------------------------------

I don't think this would be usefull (or bugfree)...without knowing the type of the filed it's hard to do arithmetic; I think in this case explicit casts should be added...

Are there any sql systems which accept this?

> GenericUDFOPDTIPlus should support varchar
> ------------------------------------------
>
>                 Key: HIVE-22800
>                 URL: https://issues.apache.org/jira/browse/HIVE-22800
>             Project: Hive
>          Issue Type: Improvement
>          Components: Hive
>            Reporter: Rajesh Balamohan
>            Priority: Minor
>
> {noformat}
> create table test(d_date varchar(10) stored as orc;
> select d_date + INTERVAL(5) DAY from test;
> Error: Error while compiling statement: FAILED: SemanticException [Error 10014]: Line 1:7 Wrong arguments '5': No matching method for class org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPDTIPlus with (varchar(10), interval_day_time) (state=42000,code=10014)
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)