Support Questions
Find answers, ask questions, and share your expertise

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

Solved Go to solution

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

Expert Contributor

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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

Expert Contributor

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

View solution in original post

2 REPLIES 2

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

Expert Contributor

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

View solution in original post

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

Expert Contributor

@anarasimham

Thanks for the explanation.