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)