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

["Dudu Markovitz (JIRA)" <ji...@apache.org>]

    [ 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)