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

[#1]

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)

[#2 · Accepted solution]

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...

[#3]

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

[#4]

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

[#5]

This worked. Thanks @mrizvi