Hello Team, We have tested the java code internally and it worked fine for us. ClouderaJDBC version:- 2.6.27.1032 Java code:- ======== import java.sql.*; import java.math.*; public class test{ public static void main(String args[]){ try{ Class.forName("com.cloudera.impala.jdbc41.Driver"); Connection con=DriverManager.getConnection("jdbc:impala://<<hostname>> :21050;UseNativeQuery=1"); String sql = "upsert into user_info(id, name, address, email, insert_time) values (?,?,?,?,?)"; PreparedStatement statement = con.prepareStatement(sql); statement.setInt(1, 102); statement.setString(2, "Peter"); statement.setString(3, "New York"); statement.setString(4, "John@xyz.com"); statement.setTimestamp(5, java.sql.Timestamp.valueOf(java.time.LocalDateTime.now())); statement.addBatch(); statement.executeBatch(); statement.close(); con.close(); } catch(Exception e){ System.out.println(e); } } } Please let us know if it helps.
... View more
