[ 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 [~reddy.jayanthi...@gmail.com]. 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)