question Re: Error as below occurred while running Tutorial Getting Started with HDP Lab 5 STEP 6.3: 8. %jdbc SELECT a.driverid, a.riskfactor, b.city, b.state FROM riskfactor a, geolocation b where a.driverid=b.driverid in Archives of Support Questions (Read Only)

Error as below occurred while running Tutorial Getting Started with HDP Lab 5 STEP 6.3: 8. %jdbc SELECT a.driverid, a.riskfactor, b.city, b.state FROM riskfactor a, geolocation b where a.driverid=b.driverid

cliu20000728 — Fri, 30 Sep 2016 07:03:49 GMT

FATAL: no pg_hba.conf entry for host "127.0.0.1", user "gpadmin", database "gpadmin", SSL off class org.postgresql.util.PSQLException org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:420) org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:195) org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:127) org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29) org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21) org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:41) org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) org.postgresql.Driver.makeConnection(Driver.java:414) org.postgresql.Driver.connect(Driver.java:282) java.sql.DriverManager.getConnection(DriverManager.java:571) java.sql.DriverManager.getConnection(DriverManager.java:187) org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:257) org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(JDBCInterpreter.java:275) org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:336) org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:442) org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94) org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341) org.apache.zeppelin.scheduler.Job.run(Job.java:176) org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162) java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) java.util.concurrent.FutureTask.run(FutureTask.java:262) java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) java.lang.Thread.run(Thread.java:745)

Re: Error as below occurred while running Tutorial Getting Started with HDP Lab 5 STEP 6.3: 8. %jdbc SELECT a.driverid, a.riskfactor, b.city, b.state FROM riskfactor a, geolocation b where a.driverid=b.driverid

gkeys — Fri, 30 Sep 2016 20:10:29 GMT

When you click on the Interpreters tab you will see that %jdbc is preconfigured for postgres. Not sure why this version of the sandbox is set up that way ... but that is the way it is.

Either try %hive or try to configure the Interpreter for %jdbc hive using as a guide https://community.hortonworks.com/questions/56113/trying-to-create-phoenix-interpreter-using-jdbc-in.html

Re: Error as below occurred while running Tutorial Getting Started with HDP Lab 5 STEP 6.3: 8. %jdbc SELECT a.driverid, a.riskfactor, b.city, b.state FROM riskfactor a, geolocation b where a.driverid=b.driverid

mrizvi — Sat, 01 Oct 2016 01:06:40 GMT

Hi @Cindy Liu, can you please replace %jdbc with %jdbc(hive) and then run the qery, it should work

Re: Error as below occurred while running Tutorial Getting Started with HDP Lab 5 STEP 6.3: 8. %jdbc SELECT a.driverid, a.riskfactor, b.city, b.state FROM riskfactor a, geolocation b where a.driverid=b.driverid

cliu20000728 — Sat, 01 Oct 2016 11:23:20 GMT

This worked. Thanks @mrizvi

Re: Error as below occurred while running Tutorial Getting Started with HDP Lab 5 STEP 6.3: 8. %jdbc SELECT a.driverid, a.riskfactor, b.city, b.state FROM riskfactor a, geolocation b where a.driverid=b.driverid

cliu20000728 — Sat, 01 Oct 2016 11:34:51 GMT

Thanks @Greg Keys for the insight. Change @jdbc to @jdbc(hive) worked.