http://www.datastax.com/support-forums/topic/error-while-creating-external-table Software, Support, and Training for Apache Cassandra en-US Wed, 19 Jun 2013 06:09:33 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/error-while-creating-external-table#post-113 Wed, 25 May 2011 19:17:46 +0000 Yewei 113@http://www.datastax.com/support-forums/ <p>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? </p> <p>The error message is misleading, it should be 'connection failed.' This would be resolved in the beta-2 release. </p> <p>Thanks. </p> http://www.datastax.com/support-forums/topic/error-while-creating-external-table#post-90 Fri, 20 May 2011 04:53:30 +0000 Habeeb 90@http://www.datastax.com/support-forums/ <p>I'm using ubuntu 10.10. and maverick distribution and trying to run in standalone mode..<br /> Thanks.. </p> http://www.datastax.com/support-forums/topic/error-while-creating-external-table#post-89 Thu, 19 May 2011 18:30:33 +0000 zznate 89@http://www.datastax.com/support-forums/ <p>Created <a href="https://datastax.jira.com/browse/BRISK-195" rel="nofollow">https://datastax.jira.com/browse/BRISK-195</a> for tracking. </p> http://www.datastax.com/support-forums/topic/error-while-creating-external-table#post-85 Thu, 19 May 2011 14:37:37 +0000 tjake 85@http://www.datastax.com/support-forums/ <p>Thanks we will take a look,</p> <p>How are you invoking hive in the terminal? are you using "brisk hive" what platform and distribution are you on? </p> http://www.datastax.com/support-forums/topic/error-while-creating-external-table#post-84 Thu, 19 May 2011 14:30:39 +0000 Habeeb 84@http://www.datastax.com/support-forums/ <p>In hive log I have error like this</p> <p>2011-05-17 18:32:38,572 ERROR exec.DDLTask (SessionState.java:printError(343)) - FAILED: Error in metadata: java.lang.NullPointerException<br /> org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.NullPointerException<br /> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:476)<br /> at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3146)<br /> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:213)<br /> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:130)<br /> at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)<br /> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1063)<br /> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:900)<br /> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748)<br /> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164)<br /> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)<br /> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.lang.reflect.Method.invoke(Method.java:616)<br /> at org.apache.hadoop.util.RunJar.main(RunJar.java:156)<br /> Caused by: java.lang.NullPointerException<br /> at org.apache.hadoop.hive.cassandra.CassandraManager.closeConnection(CassandraManager.java:105)<br /> at org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:146)<br /> at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:344)<br /> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:470)<br /> ... 15 more</p> <p>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 </p> http://www.datastax.com/support-forums/topic/error-while-creating-external-table#post-81 Thu, 19 May 2011 12:35:17 +0000 tjake 81@http://www.datastax.com/support-forums/ <p>Could you look in the hive log and provide me with the full stack trace?</p> <p>Thanks! </p> http://www.datastax.com/support-forums/topic/error-while-creating-external-table#post-79 Thu, 19 May 2011 04:51:27 +0000 Habeeb 79@http://www.datastax.com/support-forums/ <p>I'm running query like this</p> <p>create external table StockHist(row_key string, column_name string, value string)<br /> STORED BY 'org.apache.hadoop.hive.cassandra.CassandraStorageHandler'<br /> WITH SERDEPROPERTIES ("cassandra.ks.name" = "PortfolioDemo"); </p> http://www.datastax.com/support-forums/topic/error-while-creating-external-table#post-70 Wed, 18 May 2011 12:42:32 +0000 tjake 70@http://www.datastax.com/support-forums/ <p>the hive log should be under brisk-1.0~beta1/logs/hive</p> <p>What was the query that gave you this error? </p> http://www.datastax.com/support-forums/topic/error-while-creating-external-table#post-69 Wed, 18 May 2011 10:14:34 +0000 Habeeb 69@http://www.datastax.com/support-forums/ <p>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,<br /> FAILED: Error in metadata: java.lang.NullPointerException<br /> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.</p> <p>should i include any external packages.. advice me </p>