Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

PreparedStatement through Cloudera Impala JDBC driver

Highlighted

PreparedStatement through Cloudera Impala JDBC driver

New Contributor

When trying to execute PreparedStatement, the type of the column on the WHERE is always treated as a VARCHAR in the Impala driver no matter what is the original type on source.

 

Class.forName("com.cloudera.impala.jdbc4.Driver");
con = DriverManager.getConnection(connectionUrl);
String sql = "select * from default.employee where id= ?";
PreparedStatement pstm = con.prepareStatement(sql);

While looking inside getParameterMetaData()  the type is always VARCHAR. 

Is there any way to get the original column type from source?