ClassCastException on Drop table query in apache spark hive

kanwar_singh — Tue, 26 Jul 2016 17:40:49 GMT

I'm using the following hive query :

this.queryExecutor.executeQuery("Drop table user")

and am getting the following exception :

java.lang.LinkageError: ClassCastException: attempting to castjar:file:/usr/hdp/2.4.2.0-258/spark/lib/spark-assembly-1.6.1.2.4.2.0-258-hadoop2.7.1.2.4.2.0-258.jar!/javax/ws/rs/ext/RuntimeDelegate.classtojar:file:/usr/hdp/2.4.2.0-258/spark/lib/spark-assembly-1.6.1.2.4.2.0-258-hadoop2.7.1.2.4.2.0-258.jar!/javax/ws/rs/ext/RuntimeDelegate.class

I saw there have been similar posts here and here but they haven't had any response till now.

Whats intriguing is that this is specific when we try to use drop table (or drop table if exists) query.

Hoping to find resolution for the same.

Re: ClassCastException on Drop table query in apache spark hive

cstanca — Thu, 28 Jul 2016 09:10:15 GMT

@kanwar singh

user is a reserved word in hive. You need to use escape characters for it. They are the back ticks, e.g. `user`. Since you are passing the statement as a string, you may have to escape the back-tick ` as well using a back-slash, \`.

Additionally, commands issued in hive require a semi-colon at the end.

To test the above theory just try to drop a table that does not have a reserved keyword in hive, e.g. MyTable.

If this helps, please vote/accept answer.

question ClassCastException on Drop table query in apache spark hive in Archives of Support Questions (Read Only)

ClassCastException on Drop table query in apache spark hive

Re: ClassCastException on Drop table query in apache spark hive