[TASK][CHALLENGE] JDBC driver supports affected rows

[pan3793]

What's the level of this task?

CHALLENGE

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

Search before creating

• [X] I have searched in the task list and found no similar tasks.

Mentor

• [X] I have sufficient expertise on this task, and I volunteer to be a mentor of this task to guide contributors through the task.

Skill requirements

• Knowledge of Java, Thrift, JDBC

Background and Goals

JDBC standard requires the following method return affected rows.

java.sql.Statement#executeUpdate(java.lang.String) => int

Hive added such a feature in 4.0.0 https://issues.apache.org/jira/browse/HIVE-14388

Implementation steps

This is an umbrella ticket to track all sub-tasks

• https://github.com/apache/kyuubi/issues/6252 covers thrift protocol upgrading, which adds an optional field numModifiedRows in TGetOperationStatusResp
• Modify the JDBC driver to support affected rows, refer to https://github.com/apache/hive/issues/4819
• As Kyuubi supports multi-computing engines, some engines like Spark themselves do not report affected rows but some engines like JDBC do. We can start with the JDBC engine to let them report affected rows after completing the DML operations, and propagate to client side
• Making changes in computing engines to allow them to report affected rows (this is the most challenging part of this task)

Additional context

Introduction of 2024H1 Kyuubi Code Contribution Program

[slfan1989]

@pan3793 Could you assign this issue to me? Thank you very much!

[pan3793]

@slfan1989 thanks, assigned.

@zhaohehuhu do you have minutes to address comments on https://github.com/apache/kyuubi/pull/6262, so we can get it in and unblock this task

[pan3793]

@slfan1989 do you have any progress/questions on this task?