nifi-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (NIFI-3429) ConvertJSONToSQL Does not work with table identifiers that need to be quoted
Date Thu, 02 Feb 2017 22:22:51 GMT

    [ https://issues.apache.org/jira/browse/NIFI-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15850609#comment-15850609
] 

ASF GitHub Bot commented on NIFI-3429:
--------------------------------------

Github user patricker commented on the issue:

    https://github.com/apache/nifi/pull/1464
  
    I introduced the QUOTED_IDENTIFIERS property a while back in this processor.  When I added
it I was focused on quoting column names. My goal was to make it a no-impact change for people
who don't want to use them.  What about updating the description on this property and quoting
table names only if this is true?


> 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
>            Reporter: Nicholas Carenza
>            Priority: Minor
>
> 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)

Mime
View raw message