Keyworkds in Hive

["Aggarwal, Vaibhav" <va...@amazon.com>]

Hi
Is there a wiki page which contains a list of keywords in Hive?
Can we use 'time' or 'date' as column names?
Thanks
Vaibhav

Re: Keyworkds in Hive

[Ayon Sinha <ay...@yahoo.com>]

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTable

AFAIK, you can use date and time as column names. Hive only uses string
 
-Ayon
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.



________________________________
From: Liam Friel <li...@gmail.com>
To: user@hive.apache.org
Sent: Wednesday, August 31, 2011 1:31 PM
Subject: Re: Keyworkds in Hive


I forget where you find the keyword list (a quick google did not find it for me) but you can use any name you like as a column name provided you escape it in the CREATE TABLE statement with backticks ``

Might make you life easier not to use reserved names, mind you ... 


On Wed, Aug 31, 2011 at 9:17 PM, Aggarwal, Vaibhav <va...@amazon.com> wrote:

Hi
>Is there a wiki page which contains a list of keywords in Hive?
>Can we use ‘time’ or ‘date’ as column names?
>Thanks
>Vaibhav

Re: Keyworkds in Hive

[Liam Friel <li...@gmail.com>]

I forget where you find the keyword list (a quick google did not find it for
me) but you can use any name you like as a column name provided you escape
it in the CREATE TABLE statement with backticks ``

Might make you life easier not to use reserved names, mind you ...

On Wed, Aug 31, 2011 at 9:17 PM, Aggarwal, Vaibhav <va...@amazon.com>wrote:

> Hi****
>
> Is there a wiki page which contains a list of keywords in Hive?****
>
> Can we use ‘time’ or ‘date’ as column names?****
>
> Thanks****
>
> Vaibhav****
>