Read only database issue in hive

2013-07-11 Thread Hamza Asad 
I'm facing the following issue while i executes a command in hive terminal

*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
*
why is this so?
-- 
*Muhammad Hamza Asad*

HIVESERVER2 JDBC Client throws SQL exceptions on select statements

2013-07-11 Thread Varunkumar Manohar 
I am trying to execute a hive query from JDBC CLient.I am using Hiveserver2
currently.
A very basic query throws SQL exception only from the JDBC CLient and not
from the CLI
*
The queries shown below execute successfully on the CLI*

>From the JDBC client
*select * from tableA*  works fine

whereas if I try to provide a column name and execute the query from the
JDBC CLient  I land into errors
*select col1,col2 from tableA *

throws up the following SQL exception. Is anyone facing the same issue ?
*
Exception in thread "main" java.sql.SQLException: Error while processing
statement: FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.MapRedTask
at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:159)
at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:147)
at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:182)
at
org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:246)

*
I
s there a fix for the issue?

Thanks,Varun

Re: getRegion method is missing from RegionCoprocessorEnvironment class in version 0.94

2013-07-11 Thread Ted Yu 
Which release of 0.94 do you use ?

For tip of 0.94, I see:

public interface RegionCoprocessorEnvironment extends
CoprocessorEnvironment {
  /** @return the region associated with this coprocessor */
  public HRegion getRegion();

On Thu, Jul 11, 2013 at 6:40 PM, ch huang  wrote:

> how can i do ,to change the example code based on 0.92 api ,so it can
> running in 0.94?
>

getRegion method is missing from RegionCoprocessorEnvironment class in version 0.94

2013-07-11 Thread ch huang 
how can i do ,to change the example code based on 0.92 api ,so it can
running in 0.94?

Re: Hive Storage

2013-07-11 Thread Nitin Pawar 
I think you may need to read more about how HDFS stores data.

here is the basic definition
http://hadoop.apache.org/docs/stable/hdfs_design.html#NameNode+and+DataNodes

by definition hdfs never stores and files (your data) on the namenode. It
stores the files etc on hdfs and the metadata related to those files are
stored on namenode


On Thu, Jul 11, 2013 at 3:30 PM, Manickam P  wrote:

> Hi experts,
>
> In hive While  we load files into tables will it be stored in master node
> only?  or will it use data nodes also for HDFS storage?
>
> Please clarify.
>
>
> Thanks,
> Manickam P
>



-- 
Nitin Pawar

Hive Storage

2013-07-11 Thread Manickam P 
Hi experts,
In hive While  we load files into tables will it be stored in master node only? 
 or will it use data nodes also for HDFS storage? 
Please clarify.

Thanks,
Manickam P