Does hive jdbc support java.sql.PreparedStatement?

Question

I am trying to query hive using java.sql.PreparedStatement and getting an empty result set, Same query giving proper resultset when executed using java.sql.Statement. I am using hive jdbc 1.2.2 jar and hives server is in Hortonworks hdp stack.

Answer 1

Yes, it does:

public class HivePreparedStatement extends HiveStatement implements java.sql.PreparedStatement

As can be seen, internally Hive does implement the JDBC interface PreparedStatement and thus, the driver supports this JDBC feature.

For reference see: https://hive.apache.org/javadocs/r1.2.2/api/org/apache/hive/jdbc/HivePreparedStatement.html

Hope it helps.