RE: Not able to create table in hive

2012-02-03 Thread Manish . Bhoge
This command can just tell about the data node and block details. My question was not specific to particular table. But I was not able to run any Hive command from command however same SQL can run from WEB UI. Yes, I am using 2 different users, 'Guest' user from Web and 'admin' user from comma

RE: Not able to create table in hive

2012-02-02 Thread Manish . Bhoge
Thanks Mark, I do have an access on metastore as I am login as admin. However when I query through Hue web interface it is working for me (using User: Guest). Here is how my hive-site.xml looks like. Is there any property that I need to extend here. javax.jdo.option.ConnectionURL jdbc

Not able to create table in hive

2012-02-02 Thread Manish . Bhoge
Hi, I am trying to create a table in Hive using below DDL: CREATE TABLE pokes (foo INT, bar STRING); I am getting below error, I have logged in as admin user : FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Cannot get a connection, pool error Could not create a validated obje