[jira] [Issue Comment Deleted] (NIFI-3429) ConvertJSONToSQL Does not work with table identifiers that need to be quoted

["Nicholas Carenza (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NIFI-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nicholas Carenza updated NIFI-3429:
-----------------------------------
    Comment: was deleted

(was: Apprently it only supports a single string date format hardcoded into the processor:

`SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");`)

> 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
>
> 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)