Zeppelin hive jdbc postgresql HDP 2.6 not working

alzuabi_ibr — Sun, 18 Aug 2019 05:37:36 GMT

I have installed Ambari 2.5 with HDP 2.6 in 3 nods. and I have tested Hive through Hive View, it works fine.

but when I try to query Hive with Zeppelin (find jdbc interpreter configuration in the image)

%jdbc 

show tables;

it fails with below:

org.postgresql.util.PSQLException: ERROR: unrecognized configuration parameter "tables"
 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:398)
 at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
 at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
 at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:580)
 at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:692)
 at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
 at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:489)
 at org.apache.zeppelin.scheduler.Job.run(Job.java:175)
 at org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
 at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
 at java.lang.Thread.run(Thread.java:745)

Re: Zeppelin hive jdbc postgresql HDP 2.6 not working

rguruvannagari — Sun, 16 Apr 2017 22:02:50 GMT

@Ibrahim AlZuabi

Specify which interpreter to use with jdbc.

%jdbc(hive)

show tables;

Re: Zeppelin hive jdbc postgresql HDP 2.6 not working

alzuabi_ibr — Mon, 17 Apr 2017 01:00:27 GMT

@rguruvannagari Thank you it works. I followed the hortonworks hello wold tutorial. it doesn't mentioned that.

question Re: Zeppelin hive jdbc postgresql HDP 2.6 not working in Support Questions

Zeppelin hive jdbc postgresql HDP 2.6 not working

Re: Zeppelin hive jdbc postgresql HDP 2.6 not working

Re: Zeppelin hive jdbc postgresql HDP 2.6 not working