<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question impala jdbc not support UPSERT preparestatement (KUDU) in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/impala-jdbc-not-support-UPSERT-preparestatement-KUDU/m-p/54384#M11848</link>
    <description>&lt;P&gt;impala jdbc not support UPSERT preparestatement (KUDU)&lt;BR /&gt;&lt;BR /&gt;JDBC version is impala_jdbc_2.5.37.1057&lt;BR /&gt;&lt;BR /&gt;code is like below:&lt;BR /&gt;&lt;BR /&gt;conn.setAutoCommit(false);&lt;BR /&gt;PreparedStatement pstmt = conn.prepareStatement(sqlStatement);&lt;BR /&gt;for (ArrayList&amp;lt;String&amp;gt; ss : list) {&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;for (int i=0;i&amp;lt;types.length;i++) {&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;String s = "NULL";&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;if (i &amp;lt; ss.size()) s = ss.get(i);&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;setDataValue(i+1, pstmt, types[i], s);&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;}&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;pstmt.addBatch();&lt;BR /&gt;}&lt;BR /&gt;pstmt.executeBatch();&lt;BR /&gt;pstmt.close();&lt;BR /&gt;conn.setAutoCommit(true);&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;when the sqlStatement is using INSERT it's ok, but when using UPSERT, it report below exceptions&lt;BR /&gt;&lt;BR /&gt;Exception in thread "main" java.sql.SQLException: [Simba][ImpalaJDBCDriver](500057) Multi-batch parameter values not supported for this query type.&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.cloudera.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.getQueryWithParametersPopulated(Unknown Source)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.cloudera.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.execute(Unknown Source)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.cloudera.jdbc.common.SPreparedStatement.executeBatch(Unknown Source)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.seahigh.util.ImpalaJdbcUtil.batchInsert2_0(ImpalaJdbcUtil.java:391)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.seahigh.util.TestKuduInsertUtil.batchInsertTable(TestKuduInsertUtil.java:180)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at com.seahigh.util.TestKuduInsertUtil.testInsert(TestKuduInsertUtil.java:59)&lt;BR /&gt;Caused by: com.cloudera.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500057) Multi-batch parameter values not supported for this query type.&lt;/P&gt;</description>
    <pubDate>Fri, 16 Sep 2022 11:33:29 GMT</pubDate>
    <dc:creator>w3huang</dc:creator>
    <dc:date>2022-09-16T11:33:29Z</dc:date>
  </channel>
</rss>

