configure zeppelin so spark interpreter can create hive tables

[#1]

Hello community,

I am using HDP 3.0.1 and Zeppelin 0.8.0

I would like to create hive tables, however, I get the following error:

org.apache.spark.sql.AnalysisException: Hive support is required to CREATE Hive TABLE (AS SELECT);

I found that I have to add spark.sql.catalogImplementation=hive

If I execute spark.sessionState.catalog from Zeppelin, I get:

org.apache.spark.sql.catalyst.catalog.SessionCatalog = org.apache.spark.sql.catalyst.catalog.SessionCatalog@4c3b5588

However, If I run spark from cli using the following command:

spark-shell --master yarn --conf spark.sql.catalogImplementation=hive

and then type spark.sessionState.catalog

I get the following result

org.apache.spark.sql.catalyst.catalog.SessionCatalog = org.apache.spark.sql.hive.HiveSessionCatalog@5a384aef

Running the same code, I can create a hive table from cli, but I can't create it from Zeppelin

I would like to create hive tables from Zeppelin.

What configuration do I miss?

Thanks in advance.

[#2 · Accepted solution]

After editing JDBC interpreter and adding hive password solved the issue.

[#3]

In which file did you make the change? and what are the values?