RE: Not able to create table in hive
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 command line. Thank You, Manish -Original Message- From: alo alt [mailto:wget.n...@googlemail.com] Sent: Friday, February 03, 2012 1:37 PM To: u...@hive.apache.org Cc: dev@hive.apache.org; mgro...@oanda.com Subject: Re: Not able to create table in hive Importance: High check the rights in hdfs for the table hadoop dfs -fsck /path/to/warehouse/dir/table The table was created with the right of the user guest, so only guest can write in. - Alex -- Alexander Lorenz http://mapredit.blogspot.com On Feb 3, 2012, at 8:58 AM, Manish.Bhoge wrote: > 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:derby:;databaseName=/usr/share/hue/metastore_db;create=true > JDBC connect string for a JDBC metastore > > > > javax.jdo.option.ConnectionDriverName > org.apache.derby.jdbc.EmbeddedDriver > Driver class name for a JDBC metastore > > > > hive.hwi.war.file > /usr/lib/hive/lib/hive-hwi-0.7.0-CDH3B4.war > This is the WAR file with the jsp content for Hive Web > Interface > > > Thank You, > Manish > > -Original Message- > From: Mark Grover [mailto:mgro...@oanda.com] > Sent: Thursday, February 02, 2012 8:15 PM > To: u...@hive.apache.org > Subject: Re: Not able to create table in hive > > Hi Manish, > Sounds like a problem with your metastore. Can you verify that you have the > access and correct permissions to your metastore? > > Mark > > Mark Grover, Business Intelligence Analyst > OANDA Corporation > > www: oanda.com www: fxtrade.com > e: mgro...@oanda.com > > "Best Trading Platform" - World Finance's Forex Awards 2009. > "The One to Watch" - Treasury Today's Adam Smith Awards 2009. > > > - Original Message - > From: "Manish.Bhoge" > To: u...@hive.apache.org, dev@hive.apache.org > Sent: Thursday, February 2, 2012 8:45:26 AM > Subject: Not able to create table in hive > > > > > 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 object, cause: A > read-only user or a user in a read-only database is not permitted to disable > read-only mode on a connection. > > > > NestedThrowables: > > org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool > error Could not create a validated object, cause: A read-only user or a user > in a read-only database is not permitted to disable read-only mode on a > connection. > > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > > > Any idea? > > > > Thank You, > > Manish >
Re: Not able to create table in hive
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:derby:*;*databaseName=/usr/share/hue/metastore_db;create=true JDBC connect string for a JDBC metastore javax.jdo.option.ConnectionDriverName org.apache.derby.jdbc.EmbeddedDriver Driver class name for a JDBC metastore hive.hwi.war.file /usr/lib/hive/lib/hive-hwi-0.7.0-CDH3B4.war This is the WAR file with the jsp content for Hive Web Interface Thank You, Manish On Fri, Feb 3, 2012 at 1:37 PM, alo alt wrote: > check the rights in hdfs for the table > > hadoop dfs -fsck /path/to/warehouse/dir/table > > The table was created with the right of the user guest, so only guest can > write in. > > - Alex > > -- > Alexander Lorenz > http://mapredit.blogspot.com > > On Feb 3, 2012, at 8:58 AM, Manish.Bhoge wrote: > > > 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:derby:;databaseName=/usr/share/hue/metastore_db;create=true > > JDBC connect string for a JDBC metastore > > > > > > > > javax.jdo.option.ConnectionDriverName > > org.apache.derby.jdbc.EmbeddedDriver > > Driver class name for a JDBC metastore > > > > > > > > hive.hwi.war.file > > /usr/lib/hive/lib/hive-hwi-0.7.0-CDH3B4.war > > This is the WAR file with the jsp content for Hive Web > Interface > > > > > > Thank You, > > Manish > > > > -Original Message- > > From: Mark Grover [mailto:mgro...@oanda.com] > > Sent: Thursday, February 02, 2012 8:15 PM > > To: u...@hive.apache.org > > Subject: Re: Not able to create table in hive > > > > Hi Manish, > > Sounds like a problem with your metastore. Can you verify that you have > the access and correct permissions to your metastore? > > > > Mark > > > > Mark Grover, Business Intelligence Analyst > > OANDA Corporation > > > > www: oanda.com www: fxtrade.com > > e: mgro...@oanda.com > > > > "Best Trading Platform" - World Finance's Forex Awards 2009. > > "The One to Watch" - Treasury Today's Adam Smith Awards 2009. > > > > > > - Original Message - > > From: "Manish.Bhoge" > > To: u...@hive.apache.org, dev@hive.apache.org > > Sent: Thursday, February 2, 2012 8:45:26 AM > > Subject: Not able to create table in hive > > > > > > > > > > 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 object, cause: A > read-only user or a user in a read-only database is not permitted to > disable read-only mode on a connection. > > > > > > > > NestedThrowables: > > > > org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, > pool error Could not create a validated object, cause: A read-only user or > a user in a read-only database is not permitted to disable read-only mode > on a connection. > > > > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > > > > > > > Any idea? > > > > > > > > Thank You, > > > > Manish > > > >
Re: Not able to create table in hive
check the rights in hdfs for the table hadoop dfs -fsck /path/to/warehouse/dir/table The table was created with the right of the user guest, so only guest can write in. - Alex -- Alexander Lorenz http://mapredit.blogspot.com On Feb 3, 2012, at 8:58 AM, Manish.Bhoge wrote: > 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:derby:;databaseName=/usr/share/hue/metastore_db;create=true > JDBC connect string for a JDBC metastore > > > > javax.jdo.option.ConnectionDriverName > org.apache.derby.jdbc.EmbeddedDriver > Driver class name for a JDBC metastore > > > > hive.hwi.war.file > /usr/lib/hive/lib/hive-hwi-0.7.0-CDH3B4.war > This is the WAR file with the jsp content for Hive Web > Interface > > > Thank You, > Manish > > -Original Message- > From: Mark Grover [mailto:mgro...@oanda.com] > Sent: Thursday, February 02, 2012 8:15 PM > To: u...@hive.apache.org > Subject: Re: Not able to create table in hive > > Hi Manish, > Sounds like a problem with your metastore. Can you verify that you have the > access and correct permissions to your metastore? > > Mark > > Mark Grover, Business Intelligence Analyst > OANDA Corporation > > www: oanda.com www: fxtrade.com > e: mgro...@oanda.com > > "Best Trading Platform" - World Finance's Forex Awards 2009. > "The One to Watch" - Treasury Today's Adam Smith Awards 2009. > > > - Original Message - > From: "Manish.Bhoge" > To: u...@hive.apache.org, dev@hive.apache.org > Sent: Thursday, February 2, 2012 8:45:26 AM > Subject: Not able to create table in hive > > > > > 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 object, cause: A > read-only user or a user in a read-only database is not permitted to disable > read-only mode on a connection. > > > > NestedThrowables: > > org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool > error Could not create a validated object, cause: A read-only user or a user > in a read-only database is not permitted to disable read-only mode on a > connection. > > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > > > Any idea? > > > > Thank You, > > Manish >
RE: Not able to create table in hive
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:derby:;databaseName=/usr/share/hue/metastore_db;create=true JDBC connect string for a JDBC metastore javax.jdo.option.ConnectionDriverName org.apache.derby.jdbc.EmbeddedDriver Driver class name for a JDBC metastore hive.hwi.war.file /usr/lib/hive/lib/hive-hwi-0.7.0-CDH3B4.war This is the WAR file with the jsp content for Hive Web Interface Thank You, Manish -Original Message- From: Mark Grover [mailto:mgro...@oanda.com] Sent: Thursday, February 02, 2012 8:15 PM To: u...@hive.apache.org Subject: Re: Not able to create table in hive Hi Manish, Sounds like a problem with your metastore. Can you verify that you have the access and correct permissions to your metastore? Mark Mark Grover, Business Intelligence Analyst OANDA Corporation www: oanda.com www: fxtrade.com e: mgro...@oanda.com "Best Trading Platform" - World Finance's Forex Awards 2009. "The One to Watch" - Treasury Today's Adam Smith Awards 2009. - Original Message - From: "Manish.Bhoge" To: u...@hive.apache.org, dev@hive.apache.org Sent: Thursday, February 2, 2012 8:45:26 AM Subject: Not able to create table in hive 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 object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection. NestedThrowables: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask Any idea? Thank You, Manish
Not able to create table in hive
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 object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection. NestedThrowables: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask Any idea? Thank You, Manish
