hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Travis Crawford (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3323) Enable enum to string conversions
Date Wed, 01 Aug 2012 01:06:35 GMT

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

Travis Crawford commented on HIVE-3323:
---------------------------------------

Summary of what this feature enables:

{code}
hive> create table convert_enum_to_string
    >   partitioned by (b string)
    >   row format serde "org.apache.hadoop.hive.serde2.thrift.ThriftDeserializer"
    >     with serdeproperties (
    >       "serialization.class"="org.apache.hadoop.hive.serde2.thrift.test.Complex",
    >       "serialization.format"="org.apache.thrift.protocol.TBinaryProtocol");
OK
Time taken: 0.067 seconds
hive> set hive.data.convert.enum.to.string=true;
hive> describe convert_enum_to_string;
OK
aint	int	from deserializer
astring	string	from deserializer
lint	array<int>	from deserializer
lstring	array<string>	from deserializer
lintstring	array<struct<myint:int,mystring:string,underscore_int:int>>	from deserializer
mstringstring	map<string,string>	from deserializer
myenum	string	from deserializer
b	string	
Time taken: 0.349 seconds
hive> set hive.data.convert.enum.to.string=false;
hive> describe convert_enum_to_string;
OK
aint	int	from deserializer
astring	string	from deserializer
lint	array<int>	from deserializer
lstring	array<string>	from deserializer
lintstring	array<struct<myint:int,mystring:string,underscore_int:int>>	from deserializer
mstringstring	map<string,string>	from deserializer
myenum	struct<value:int>	from deserializer
b	string	
Time taken: 0.144 seconds
{code}
                
> Enable enum to string conversions
> ---------------------------------
>
>                 Key: HIVE-3323
>                 URL: https://issues.apache.org/jira/browse/HIVE-3323
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Travis Crawford
>            Assignee: Travis Crawford
>         Attachments: HIVE-3323_enum_to_string.1.patch, HIVE-3323_enum_to_string.2.patch
>
>
> When using serde-reported schemas with the ThriftDeserializer, Enum fields are presented
as {{struct<value:int>}}
> Many users expect to work with the string values, which is both easier and more meaningful
as the string value communicates what is represented.
> Hive should provide a mechanism to optionally convert enum values to strings.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message