C
CK
Guest
Hi, as confirmed as part of case 00268827 the Hive JDBC driver does not support row counts unlike most other JDBC drivers. This means that a command like [Prepared]Statement.executeUpdate( "insert overwrite table ck_dev_d_1.src_customer2 select * from ck_dev_d_1.src_customer" ); will not return any rowcount information. Due to this the calling JDBC application has no insight about how many rows have been affected, which is an important information. Summary of the enhancement (from case 00268827): Enhancement: Request for retrieving count of number of rows inserted by Connect for JDBC Hive driver 1. The nature of the enhancement required specifying what should be changed or implemented. Connect for JDBC Hive driver should be able to retrieve the number of rows inserted 2. The use cases for the proposed idea (enhancement) specifying the added functionality of the product as a result of the proposed enhancement. Application cannot determine the number of rows that were updated recently after a insert operation. 3. The current alternatives or workarounds for the proposed idea (enhancement), if such alternatives exist, and why these are not desirable. There are no supported alternatives to this use.
Continue reading...
Continue reading...