[
https://issues.apache.org/jira/browse/NIFI-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15854714#comment-15854714
]
ASF GitHub Bot commented on NIFI-3429:
--------------------------------------
Github user pvillard31 commented on a diff in the pull request:
https://github.com/apache/nifi/pull/1464#discussion_r99680121
--- Diff:
nifi-nar-bundles/nifi-standard-bundle/nifi-standard-processors/src/main/java/org/apache/nifi/processors/standard/ConvertJSONToSQL.java
---
@@ -500,7 +521,11 @@ private String generateUpdate(final JsonNode rootNode,
final Map<String, String>
final StringBuilder sqlBuilder = new StringBuilder();
int fieldCount = 0;
- sqlBuilder.append("UPDATE ").append(tableName).append(" SET ");
+ sqlBuilder.append("UPDATE ");
--- End diff --
Same comment applies here ;) And for columns quotes as well.
> ConvertJSONToSQL Does not work with table identifiers that need to be quoted
> ----------------------------------------------------------------------------
>
> Key: NIFI-3429
> URL: https://issues.apache.org/jira/browse/NIFI-3429
> Project: Apache NiFi
> Issue Type: Bug
> Components: Core Framework
> Affects Versions: 1.2.0
> Reporter: Nicholas Carenza
> Priority: Minor
> Fix For: 1.2.0
>
>
> I have a table identifer that needs to be quoted. If i supple the table
> identifer unquoted in the properties, the processor can convert the json to
> sql but the output sql doesn't have the table name quoted even if I select
> the option Quote Identifiers because, true to the description, it only
> applies to column identifiers. If I supply the table identifier quoted in the
> properties, then the processor fails completely because it can't find the
> table.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
