You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Jason Dere (JIRA)" <ji...@apache.org> on 2013/10/30 03:10:26 UTC

[jira] [Commented] (HIVE-3190) allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)

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

Jason Dere commented on HIVE-3190:
----------------------------------

How about the following aliases:

INTEGER = INT
BLOB/BINARY LARGE OBJECT = BINARY
CLOB/CHARACTER LARGE OBJECT = STRING
NUMERIC = DECIMAL
REAL = FLOAT
DOUBLE PRECISION = DOUBLE

> allow INTEGER as a type name in a column/cast expression (per ISO-SQL 2011)
> ---------------------------------------------------------------------------
>
>                 Key: HIVE-3190
>                 URL: https://issues.apache.org/jira/browse/HIVE-3190
>             Project: Hive
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 0.8.0
>            Reporter: N Campbell
>
> Just extend the parser to allow INTEGER instead of making folks use INT
> select cast('10' as integer) from cert.tversion tversion
> FAILED: Parse Error: line 1:20 cannot recognize input near 'integer' ')' 'from' in primitive type specification



--
This message was sent by Atlassian JIRA
(v6.1#6144)