[CALCITE-1128] Support addBatch()/executeBatch() in remote driver

• Type: Improvement
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: avatica-1.8.0
• Component/s: avatica
• Assignee: Josh Elser
• Reporter: Josh Elser
• Created: 07/Mar/16 18:19
• Updated: 29/Apr/19 17:14
• Resolved: 24/Mar/16 04:29

Description

JDBC has some "batch-oriented" APIs which should help in the heavy-write workloads. These should help ammortize the RPC cost of repeated PrepareAndExecuteRequests and ExecuteRequests.

Through some of the recent performance work, CALCITE-1091, I think we're getting close to the limit of what is possible given our current server implementation (both in terms of HTTP-based clients and deserialization in POJOs). The thought is that we will get some better throughput if we reduce the total number of RPCs.

Issue Links

• blocks: PHOENIX-2541 Support addBatch() and updateBatch() through QueryServer
• relates to: CALCITE-1180 Support clearBatch() in remote driver
• links to: PR