[STORM-699] storm-jdbc should support customer insert queries.

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.10.0
• Fix Version/s: 0.10.0
• Component/s: storm-jdbc
• Assignee: Parth Brahmbhatt
• Reporter: Parth Brahmbhatt
• Created: 07/Mar/15 02:45
• Updated: 29/Sep/15 02:31
• Resolved: 01/Jun/15 20:02

Description

Currently storm-jdbc insert bolt/state only supports to specify a table name and constructs a query of the form "insert into tablename values(?,?,?)" based on table's schema. This fails to support use cases like "insert into as select * from" or special cases like Phoenix that has a jdbc driver but only supports "upsert into".

We should add a way so the users can specify their own custom query for the insert bolt. This was already pointed out by revans2 during the PR review and we now have concrete cases that will be benefited by this feature.