[
https://issues.apache.org/jira/browse/STORM-699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14356354#comment-14356354
]
ASF GitHub Bot commented on STORM-699:
--------------------------------------
Github user HeartSaVioR commented on a diff in the pull request:
https://github.com/apache/storm/pull/458#discussion_r26190281
--- Diff: external/storm-jdbc/README.md ---
@@ -13,14 +13,39 @@ public interface JdbcMapper extends Serializable {
}
```
-The `getColumns()` method defines how a storm tuple maps to a list of
columns representing a row in a database.
+The `getColumns()` method defines how a storm tuple maps to a list of
columns representing a row in a database.
+**The order of the returned list is important. The place holders in the
supplied queries are resolved in the same order as returned list.**
+For example if the user supplied insert query is `insert into table
user(user_id, user_name, create_date) values (?,?, now())` the 1st item
--- End diff --
Could you check query again? Seems like it's strange.
> storm-jdbc should support customer insert queries.
> --------------------------------------------------
>
> Key: STORM-699
> URL: https://issues.apache.org/jira/browse/STORM-699
> Project: Apache Storm
> Issue Type: Improvement
> Affects Versions: 0.10.0
> Reporter: Parth Brahmbhatt
> Assignee: Parth Brahmbhatt
> Priority: Minor
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
