question Re: Zeppelin Interpreter in Archives of Support Questions (Read Only)

Zeppelin Interpreter

itsssudheer — Fri, 22 Sep 2017 01:25:13 GMT

Do we have any SQL interpreter in Zeppelin?

kbadani — Fri, 22 Sep 2017 01:35:59 GMT

If you look at the zeppelin jdbc interpreter configuration, you will see these 4 properties:

default.driver ( Your driver, for e.g. org.postgresql.Driver)

default.url (jdbc connection URL)

default.user

default.password

You can configure these 4 properties and then use %jdbc as to do SQL queries

yjagadeesan — Fri, 22 Sep 2017 01:36:09 GMT

Here is the list of interpreters that exist in zeppelin.

There is nothing specifically for SQL interpreter though. What exactly are you trying to do here?

itsssudheer — Fri, 22 Sep 2017 01:37:36 GMT

I am just trying to connect to hive

yjagadeesan — Fri, 22 Sep 2017 01:39:52 GMT

Ah ok. Try this

%jdbc(hive)

You might need to check if the hive configuration is updated in the jdbc interpreter settings.

itsssudheer — Fri, 22 Sep 2017 01:41:12 GMT

Oh its working default. Thanks