hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manish.Bhoge <Manish.Bh...@target.com>
Subject RE: Not able to create table in hive
Date Fri, 03 Feb 2012 09:34:35 GMT
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.null@googlemail.com] 
Sent: Friday, February 03, 2012 1:37 PM
To: user@hive.apache.org
Cc: dev@hive.apache.org; mgrover@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. 
> 
> <property>
>  <name>javax.jdo.option.ConnectionURL</name>
>  <value>jdbc:derby:;databaseName=/usr/share/hue/metastore_db;create=true</value>
>  <description>JDBC connect string for a JDBC metastore</description>
> </property>
> 
> <property>
>  <name>javax.jdo.option.ConnectionDriverName</name>
>  <value>org.apache.derby.jdbc.EmbeddedDriver</value>
>  <description>Driver class name for a JDBC metastore</description>
> </property>
> 
> <property>
>  <name>hive.hwi.war.file</name>
>  <value>/usr/lib/hive/lib/hive-hwi-0.7.0-CDH3B4.war</value>
>  <description>This is the WAR file with the jsp content for Hive Web Interface</description>
> </property>
> 
> Thank You,
> Manish
> 
> -----Original Message-----
> From: Mark Grover [mailto:mgrover@oanda.com] 
> Sent: Thursday, February 02, 2012 8:15 PM
> To: user@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: mgrover@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" <Manish.Bhoge@target.com>
> To: user@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 
> 


Mime
View raw message