hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuefu Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5191) Add char data type
Date Fri, 01 Nov 2013 01:50:18 GMT

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

Xuefu Zhang commented on HIVE-5191:
-----------------------------------

Personally I think 255 might be sufficient, and I'd like the idea of being inline with mysql.
I haven't heard any complaint about the limit is too low for char type for any any database.
Most usage of char is storing some fix-length symbols such as state abbreviation, zip code,
ssn, etc. for those, 255 is probably good enough. In Hive, user can always opt for varchar
if something bigger is needed. After all, char offers no performance adv over varchar, at
least as of now.

> Add char data type
> ------------------
>
>                 Key: HIVE-5191
>                 URL: https://issues.apache.org/jira/browse/HIVE-5191
>             Project: Hive
>          Issue Type: New Feature
>          Components: Types
>            Reporter: Jason Dere
>            Assignee: Jason Dere
>         Attachments: HIVE-5191.1.patch, HIVE-5191.2.patch, HIVE-5191.3.patch
>
>
> Separate task for char type, since HIVE-4844 only adds varchar



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

Mime
View raw message