Re: Unable to create sample tables in Hive

2012-06-08 Thread shashwat shriparv
r hive instance was already working some one might have >> accidentally deleted some tables from metastore db. >> >> Regards >> Bejoy >> >> -------------- >> *From:* Nanda Vijaydev >> *To:* user@hive.apache.org >> *Sent:* Thursday, June 7,

Re: Unable to create sample tables in Hive

2012-06-08 Thread soham sardar
instance was already working some one might have accidentally > deleted some tables from metastore db. > > Regards > Bejoy > > -- > *From:* Nanda Vijaydev > *To:* user@hive.apache.org > *Sent:* Thursday, June 7, 2012 11:59 PM > *Subject:* Re:

Re: Unable to create sample tables in Hive

2012-06-07 Thread Bejoy Ks
to create sample tables in Hive There is nothing wrong with your SQL statement. This works on CLI fine and I tried the following. Your issue seems to be related to the underlying metadata store. CREATE TABLE page_view(viewTime INT, userid BIGINT,     page_url STRING, referrer_url STRING,    

Re: Unable to create sample tables in Hive

2012-06-07 Thread Nanda Vijaydev
There is nothing wrong with your SQL statement. This works on CLI fine and I tried the following. Your issue seems to be related to the underlying metadata store. CREATE TABLE page_view(viewTime INT, userid BIGINT, page_url STRING, referrer_url STRING, ip STRING COMMENT 'IP Address of the