hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Breshears (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-3960) Column Names of "Data"
Date Wed, 30 Jan 2013 03:19:12 GMT

     [ https://issues.apache.org/jira/browse/HIVE-3960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Alex Breshears updated HIVE-3960:
---------------------------------

    Description: 
There seems to be an issue with column names of "data". This is the same as all column names
that are the same as keywords.

I was able to create a table with a column name of "data" via Sqoop but discovered this problem
when trying to query the table in the CLI. Any refrence to a column name of "data" throws
an error - even when fully qualifying it in a SELECT.

See below.

hive> create table test (id int, data string);
FAILED: Parse Error: line 1:27 mismatched input 'data' expecting Identifier near ',' in column
specification

hive> create table test (id int, st string);  
OK
Time taken: 5.778 seconds

  was:
There seems to be an issue with column names of "data". 

I was able to create a table with a column name of "data" via Sqoop but discovered this problem
when trying to query the table in the CLI. Any refrence to a column name of "data" throws
an error - even when fully qualifying it in a SELECT.

See below.

hive> create table test (id int, data string);
FAILED: Parse Error: line 1:27 mismatched input 'data' expecting Identifier near ',' in column
specification

hive> create table test (id int, st string);  
OK
Time taken: 5.778 seconds

    
> Column Names of "Data"
> ----------------------
>
>                 Key: HIVE-3960
>                 URL: https://issues.apache.org/jira/browse/HIVE-3960
>             Project: Hive
>          Issue Type: Bug
>          Components: CLI
>    Affects Versions: 0.8.0
>         Environment: EC2 Amazon AMI 64-bit
>            Reporter: Alex Breshears
>            Priority: Minor
>
> There seems to be an issue with column names of "data". This is the same as all column
names that are the same as keywords.
> I was able to create a table with a column name of "data" via Sqoop but discovered this
problem when trying to query the table in the CLI. Any refrence to a column name of "data"
throws an error - even when fully qualifying it in a SELECT.
> See below.
> hive> create table test (id int, data string);
> FAILED: Parse Error: line 1:27 mismatched input 'data' expecting Identifier near ','
in column specification
> hive> create table test (id int, st string);  
> OK
> Time taken: 5.778 seconds

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message