[ 
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)

Reply via email to