HUE -BEESWAX GIVING PROBLEM IN CDH4

[tech.zo...@gmail.com]

hi ,

I HAVE INSTALLED CDH4, AND I WANT TO USE HUE ?      BUT  WHEN I OPEN BROWSER IT GIVING THIS ERROR.........

Error!

Exception communicating with Hive Metastore Server at localhost:8003: timed out

I AM GETTING  PIG AND HBASE SHELL ,BUT  ONLY ONE SHELL WE CAN USE AT A TIME..... WHAT WAS THE PROBLEM?

[Romain Rigaux]

Hi,

Most of the time, this error happens when Hive is not configured properly: https://ccp.cloudera.com/display/CDH4DOC/Hive+Installation#HiveInstallation-MetastoreDeploymentModes

However, if you don't want to use Hive for doing SQL queries and just want to use the FileBrowser or Shell this error is not important.

For the Shell, you can use multiple at the same time, just open them in a new tab with a middle click or doing 'Open link in a new tab'.

Romain

[tech.zo...@gmail.com]

THANKS Romain,

BUT I WANT TO QUERY DATA FROM HIVE TO HBASE AS WELL AS I WANT TO INSERT DATA IN HBASE THROUGH HIVE WITH THE HELP HUE,
 CAN IT POSSIBLE?

TECHZONE

[Romain Rigaux]

Yes, this is possible, Hue is just a UI on top of Hive.

Is it working on the command line already? https://ccp.cloudera.com/display/CDH4DOC/Hive+Installation#HiveInstallation-UsingHivewithHBase

Romain

[tech.zo...@gmail.com]

Hi Romain,

Yes it working fine with cli ,as well i have integrated hive with hbase, but still i am not going to use hive in hue?

Techzone

[Romain Rigaux]

Yes it should work.

Could you share the Hue/Beeswax logs? https://ccp.cloudera.com/display/CDH4DOC/Hue+Installation#HueInstallation-HueLogging

Romain

[Romain Rigaux]

You probably have a similar error:

============= begin nested exception, level (1) ===========

java.sql.SQLException: Directory /var/lib/hive/metastore/metastore_db cannot be created.

        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)

        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)

        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)

        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)

        at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)

        at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)

        at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)

        at java.sql.DriverManager.getConnection(DriverManager.java:582)

        at java.sql.DriverManager.getConnection(DriverManager.java:185)

        at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)

        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)

        at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)

        at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java

:521)

It happens because /var/lib/hive/metastore does not belong to 'hue'. Could you do a 'sudo chown hue:hue /var/lib/hive/metastore' (or 'your_user' running Hue instead of hue'. You can also 'sudo chmod -R 777  /var/lib/hive/metastore' if you are on a test machine)?

What does 'ls /var/lib/hive/metastore' give you now?

One way to avoid this problem is to not use a Derby DB but a recommended 'MySql Database': https://ccp.cloudera.com/display/CDH4DOC/Hive+Installation#HiveInstallation-UsingtheEmbeddedMetaStore%28Derby%29

Romain

[tech.zo...@gmail.com]

Romain Rigaux

Thanks Now it's working....

But i want to integrate Beeswax hive with hbase what will be the steps

Techzone

[tech.zo...@gmail.com]

On Friday, December 28, 2012 5:33:43 PM UTC+5:30, tech.zo...@gmail.com wrote:

Romain Rigaux

Thanks Now it's working....  But the location is  ( chmod -R 777  /var/lib/hive/hue_beeswax_metastore/) ...

But i want to integrate Beeswax hive with hbase what will be the steps ,

Techzone

[tech.zo...@gmail.com]

Hi Romain,

I have integrated hive and hbase in hue ... it creating table with hive to hbase but while loading data into hbase table through hive it giving this error..................

Server Error (500)

Sorry, there's been an error. Please contact your site administrators. Thanks for your patience.

TECHZONE

[Romain Rigaux]

What are the Hue logs?

Romain

[tech.zo...@gmail.com]

Hi Romain,

It is not giving any error in that ,that mean it is not storing any logs in the log file .....................

What to do?

 

TECHZONE