Error while creating external table

(9 posts) (4 voices)

• Started 2 years ago by Habeeb
• Latest reply from Yewei
• This topic is resolved

Tags:

• Execution Error

1. 

   Habeeb
   Member

   I'm using Brisk from brisk-1.0~beta1 folder. when I read data from cassandra by using query like creating external table from hive it returns,
   FAILED: Error in metadata: java.lang.NullPointerException
   FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.

   should i include any external packages.. advice me

   Posted 2 years ago #
2. 

   tjake
   Moderator

   the hive log should be under brisk-1.0~beta1/logs/hive

   What was the query that gave you this error?

   Posted 2 years ago #
3. 

   Habeeb
   Member

   I'm running query like this

   create external table StockHist(row_key string, column_name string, value string)
   STORED BY 'org.apache.hadoop.hive.cassandra.CassandraStorageHandler'
   WITH SERDEPROPERTIES ("cassandra.ks.name" = "PortfolioDemo");

   Posted 2 years ago #
4. 

   tjake
   Moderator

   Could you look in the hive log and provide me with the full stack trace?

   Thanks!

   Posted 2 years ago #
5. 

   Habeeb
   Member

   In hive log I have error like this

   2011-05-17 18:32:38,572 ERROR exec.DDLTask (SessionState.java:printError(343)) - FAILED: Error in metadata: java.lang.NullPointerException
   org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.NullPointerException
   at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:476)
   at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3146)
   at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:213)
   at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:130)
   at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
   at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1063)
   at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:900)
   at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748)
   at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164)
   at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)
   at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:616)
   at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
   Caused by: java.lang.NullPointerException
   at org.apache.hadoop.hive.cassandra.CassandraManager.closeConnection(CassandraManager.java:105)
   at org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:146)
   at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:344)
   at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:470)
   ... 15 more

   2011-05-17 18:32:38,573 ERROR ql.Driver (SessionState.java:printError(343)) - FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

   Posted 1 year ago #
6. 

   tjake
   Moderator

   Thanks we will take a look,

   How are you invoking hive in the terminal? are you using "brisk hive" what platform and distribution are you on?

   Posted 1 year ago #
7. 

   zznate
   

   Created https://datastax.jira.com/browse/BRISK-195 for tracking.

   Posted 1 year ago #
8. 

   Habeeb
   Member

   I'm using ubuntu 10.10. and maverick distribution and trying to run in standalone mode..
   Thanks..

   Posted 1 year ago #
9. 

   Yewei
   Member

   In your query, since you have not specified the cassandra host and port, it will use the default host which is 'localhost' and default port which is '9160'. Would you please run ./nodetool -h localhost ring on the server where you run hive and post the result here?

   The error message is misleading, it should be 'connection failed.' This would be resolved in the beta-2 release.

   Thanks.

   Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.