[
https://issues.apache.org/jira/browse/HIVE-17106?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16090779#comment-16090779
]
Vineet Garg commented on HIVE-17106:
------------------------------------
Hi [[email protected]]. Do you know if there is any other database
which provide column aliasing in create table? I am curious if standard allows
this.
> Create a HIVE table withe the column names as aliases
> -----------------------------------------------------
>
> Key: HIVE-17106
> URL: https://issues.apache.org/jira/browse/HIVE-17106
> Project: Hive
> Issue Type: Task
> Components: Hive
> Reporter: Jayanthi R
>
> Hello,
> I have data in text file which i should load into hive table. The column
> names/headings in the text file is different from the table names which I
> should create while creating HIVE table. So, I want to alias these table
> names, how can I do it.
> I tried creating alias names in the create statement itself, but it was
> throwing error.
> Ex: create table table_name(name String as nm, Work String as wk).
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
