hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "nicolas maillard (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-6628) Use UDFs in create table statement
Date Wed, 12 Mar 2014 12:48:43 GMT
nicolas maillard created HIVE-6628:
--------------------------------------

             Summary: Use UDFs in create table statement
                 Key: HIVE-6628
                 URL: https://issues.apache.org/jira/browse/HIVE-6628
             Project: Hive
          Issue Type: New Feature
          Components: CLI
            Reporter: nicolas maillard
            Priority: Trivial


It would be nice to be able to use UDFs in a create table statement
Say my data is : userid, timestamp utc, list_of_things
123,1386716402,thing1;thing2:thing3
Being able to say
create external table mytable(
userid int
adate string as from_utc_timestamp(tilmestamp,"Europe/Paris")
listofthings array<String> as split( list_of_things, ";")
)ROW FORMAT DELIMITED FIELDS TERMINATED BY ','

this is like a much lighter serde or a simpler view I guess.
It would allow to correct the view of certains fields on the fly  without needing to do reproscessing.
this is a use case we see happening a lot in our inital data collections





--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message