You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Naveen Reddy <na...@yahoo.co.in> on 2012/11/26 11:54:49 UTC
Hive on Cassandra : issues in setup
Hi,
I am trying to setup hive on Cassandra using https://github.com/riptano/hive/wiki/Cassandra-Handler-usage-in-Hive-0.7-with-Cassandra-0.7 . I do not find any better documentation, if you have any other pointers please
provide them. I and trying to setup this without using brisk from DataStax.
Versions –
hive-0.8.1
hadoop-1.0.4
apache-cassandra-1.0.7 - as mentioned in ivy/libraries.properties
hive-cassandra-handler-0.8.1.jar : from hive-hive-0.8.1-merge
( https://github.com/riptano/hive ) – downloaded this source and built
And I am hitting the below error while running a query from
hive. Help please -
I tried multiple versions of Cassandra/hive/hadoop, but
getting stuck with one or the other exception. Can you please tell me the right
combination of versions.
hive>
> CREATE
EXTERNAL TABLE invites2 (foo INT, bar STRING)
> STORED BY
'org.apache.hadoop.hive.cassandra.CassandraStorageHandler'
> WITH
SERDEPROPERTIES (
>
"cassandra.host" = "localhost",
>
"cassandra.port" = "9160",
>
"cassandra.ks.name" = "examples",
>
"cassandra.cf.name" = "invites2" );
java.lang.IncompatibleClassChangeError: Implementing class
at
java.lang.ClassLoader.defineClass1(Native Method)
at
java.lang.ClassLoader.defineClass(Unknown Source)
at
java.security.SecureClassLoader.defineClass(Unknown Source)
at
java.net.URLClassLoader.defineClass(Unknown Source)
at
java.net.URLClassLoader.access$000(Unknown Source)
at
java.net.URLClassLoader$1.run(Unknown Source)
at
java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown
Source)
at
java.lang.ClassLoader.loadClass(Unknown Source)
at
java.lang.ClassLoader.loadClass(Unknown Source)
at
java.lang.ClassLoader.loadClassInternal(Unknown Source)
at
org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:54)
at
org.apache.hadoop.hive.cassandra.CassandraClientHolder.<init>(CassandraClientHolder.java:31)
at
org.apache.hadoop.hive.cassandra.CassandraClientHolder.<init>(CassandraClientHolder.java:23)
at
org.apache.hadoop.hive.cassandra.CassandraProxyClient.createConnection(CassandraProxyClient.java:136)
at
org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:152)
at
org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:101)
at
org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:88)
at org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:237)
at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396)
at
org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540)
at
org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3479)
at
org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:225)
at
org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:133)
at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
at
org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1332)
at
org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1123)
at
org.apache.hadoop.hive.ql.Driver.run(Driver.java:931)
at
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:255)
at
org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:212)
at
org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403)
at
org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:671)
at
org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:554)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at
java.lang.reflect.Method.invoke(Unknown Source)
at
org.apache.hadoop.util.RunJar.main(RunJar.java:156)
FAILED: Execution Error, return code -101 from
org.apache.hadoop.hive.ql.exec.DDLTask
Thank you
Naveen
Re: Hive on Cassandra : issues in setup
Posted by Naveen Reddy <na...@yahoo.co.in>.
Can someone please help me with this or share your experiences if you have tried this before please?
________________________________
From: Naveen Reddy <na...@yahoo.co.in>
To: "user@cassandra.apache.org" <us...@cassandra.apache.org>
Sent: Monday, 26 November 2012 4:24 PM
Subject: Hive on Cassandra : issues in setup
Hi,
I am trying to setup hive on Cassandra using https://github.com/riptano/hive/wiki/Cassandra-Handler-usage-in-Hive-0.7-with-Cassandra-0.7 . I do not find any better documentation, if you have any other pointers please
provide them. I and trying to setup this without using brisk from DataStax.
Versions –
hive-0.8.1
hadoop-1.0.4
apache-cassandra-1.0.7 - as mentioned in ivy/libraries.properties
hive-cassandra-handler-0.8.1.jar : from hive-hive-0.8.1-merge
( https://github.com/riptano/hive ) – downloaded this source and built
And I am hitting the below error while running a query from
hive. Help please -
I tried multiple versions of Cassandra/hive/hadoop, but
getting stuck with one or the other exception. Can you please tell me the right
combination of versions.
hive>
> CREATE
EXTERNAL TABLE invites2 (foo INT, bar STRING)
> STORED BY
'org.apache.hadoop.hive.cassandra.CassandraStorageHandler'
> WITH
SERDEPROPERTIES (
>
"cassandra.host" = "localhost",
>
"cassandra.port" = "9160",
>
"cassandra.ks.name" = "examples",
>
"cassandra.cf.name" = "invites2" );
java.lang.IncompatibleClassChangeError: Implementing class
at
java.lang.ClassLoader.defineClass1(Native Method)
at
java.lang.ClassLoader.defineClass(Unknown Source)
at
java.security.SecureClassLoader.defineClass(Unknown Source)
at
java.net.URLClassLoader.defineClass(Unknown Source)
at
java.net.URLClassLoader.access$000(Unknown Source)
at
java.net.URLClassLoader$1.run(Unknown Source)
at
java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown
Source)
at
java.lang.ClassLoader.loadClass(Unknown Source)
at
java.lang.ClassLoader.loadClass(Unknown Source)
at
java.lang.ClassLoader.loadClassInternal(Unknown Source)
at
org.apache.hadoop.hive.cassandra.CassandraClientHolder.initClient(CassandraClientHolder.java:54)
at
org.apache.hadoop.hive.cassandra.CassandraClientHolder.<init>(CassandraClientHolder.java:31)
at
org.apache.hadoop.hive.cassandra.CassandraClientHolder.<init>(CassandraClientHolder.java:23)
at
org.apache.hadoop.hive.cassandra.CassandraProxyClient.createConnection(CassandraProxyClient.java:136)
at
org.apache.hadoop.hive.cassandra.CassandraProxyClient.initializeConnection(CassandraProxyClient.java:152)
at
org.apache.hadoop.hive.cassandra.CassandraProxyClient.<init>(CassandraProxyClient.java:101)
at
org.apache.hadoop.hive.cassandra.CassandraManager.openConnection(CassandraManager.java:88)
at org.apache.hadoop.hive.cassandra.CassandraStorageHandler.preCreateTable(CassandraStorageHandler.java:237)
at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:396)
at
org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:540)
at
org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3479)
at
org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:225)
at
org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:133)
at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
at
org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1332)
at
org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1123)
at
org.apache.hadoop.hive.ql.Driver.run(Driver.java:931)
at
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:255)
at
org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:212)
at
org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403)
at
org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:671)
at
org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:554)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at
java.lang.reflect.Method.invoke(Unknown Source)
at
org.apache.hadoop.util.RunJar.main(RunJar.java:156)
FAILED: Execution Error, return code -101 from
org.apache.hadoop.hive.ql.exec.DDLTask
Thank you
Naveen