[jira] [Created] (HIVE-6628) Use UDFs in create table statement

["nicolas maillard (JIRA)" <ji...@apache.org>]

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)