[ https://issues.apache.org/jira/browse/HIVE-6628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15400794#comment-15400794 ]
Dudu Markovitz commented on HIVE-6628: -------------------------------------- Hi Nicolas I couldn't understand why a combination of external table + view is not a good fit for you, e.g. - create external table mytable( userid int ,adate string ,listofthings string )ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' ; create view mytable_v as select userid int , from_utc_timestamp(adate,"Europe/Paris") ,split( list_of_things, ";") from mytable ; > 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.3.4#6332)