Difference between %jdbc, %hive and %sql Interpreter in Zeppelin

[#1]

Hi,

Is there a difference (in functionality) between %jdbc, %hive and %sql interpreter. If Yes, what is the difference? We can access hive data by using all these interpreters.

As per the documentation, we can achieve the same functionality by using %jdbc when compared to %hive and it (%hive) will be replaced in newer version of Zeppelin.

Thanks.

[#2 · Accepted solution]

As you've already read, the hive interpreter is deprecated and you should favor the use of jdbc. The hive interpreter provides equivalent functionality to the jdbc interpreter as far as accessing hive schemas is concerned, but the jdbc interpreter can connect to a much larger variety of data sources.

As far as the sql interpreter, this is the spark.sql interpreter and will provide the same functionality as the jdbc interpreter.

Please reference the following sources of documentation for more information.

Hive is being deprecated:

https://zeppelin.apache.org/docs/0.6.2/interpreter/hive.html

Spark SQL is equivalent to using the JDBC driver. Please see the "SQL" section near the top of the page:

https://spark.apache.org/docs/latest/sql-programming-guide.html

[#3]

@anarasimham

Thanks for the explanation.