Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Error when query hive/hbase from %sql



I setup Zeppelin, %spark and %hive is workign perfectly but I have somethin special with %sql

For the context, I have hbase table and hive is able to query the hbase table.

When I'm doing


show tables

I can see all the table name but when I doing hte following query:


Select * from table1

Then I got the following error:

MetaException(message:java.lang.ClassNotFoundException Class org.apache.hadoop.hive.hbase.HBaseSerDe not found) at org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(

at org.apache.hadoop.hive.ql.metadata.Table.getDeserializerFromMetaStore(

at org.apache.hadoop.hive.ql.metadata.Table.getDeserializer( at org.apache.hadoop.hive.ql.metadata.Table.getCols( at org.apache.hadoop.hive.ql.metadata.Table.checkValidity( at org.apache.hadoop.hive.ql.metadata.Hive.getTable( at org.apache.spark.sql.hive.client.ClientWrapper$$anonfun$getTableOption$1.apply(ClientWrapper.scala:202)

at org.apache.spark.sql.hive.client.ClientWrapper$$anonfun$getTableOption$1.apply(ClientWrapper.scala:198)

at org.apache.spark.sql.hive.client.ClientWrapper.withHiveState(ClientWrapper.scala:156)

at org.apache.spark.sql.hive.client.ClientWrapper.getTableOption(ClientWrapper.scala:198)

at org.apache.spark.sql.hive.client.ClientInterface$class.getTable(ClientInterface.scala:112)

at org.apache.spark.sql.hive.client.ClientWrapper.getTable(ClientWrapper.scala:61)

at org.apache.spark.sql.hive.HiveMetastoreCatalog.lookupRelation(HiveMetastoreCatalog.scala:227)

at ....................

Any idea?

Thanks in advance,



@Michel Sumbul

Conclusion: You are using %sql to read hbase table. Correct?

You can use %phoenix to do so. You can see %phoenix demo in this or this

View solution in original post


@Michel Sumbul

Conclusion: You are using %sql to read hbase table. Correct?

You can use %phoenix to do so. You can see %phoenix demo in this or this

"MetaException(message:java.lang.ClassNotFoundException Class org.apache.hadoop.hive.hbase.HBaseSerDe not found) at org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer("



Stupid question: How to show the list of the table in phoenix from zeppelin.

I try: show table, show tables, list table, !table

Noone is working, is it normal?

Thanks 🙂

@Michel Sumbul

That's in the demo too 😉

Select from system.catalog

Check the demo


Hey Michel. In phoneix the order is !tables I am unsure if it translates into phoenix but that's how I would do it in phoenix's CLI tool.

@Chris Gambino

! Does not work in Zeppelin

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.