[jira] [Commented] (NIFI-1239) ConvertJSONToSQL should cache results from database resultset metadata

["Mark Payne (JIRA)" <ji...@apache.org>]

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

Mark Payne commented on NIFI-1239:
----------------------------------

This Processor does cache the schema already. However, there is a bug that causes the schema to remain empty all the time.

> ConvertJSONToSQL should cache results from database resultset metadata
> ----------------------------------------------------------------------
>
>                 Key: NIFI-1239
>                 URL: https://issues.apache.org/jira/browse/NIFI-1239
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Extensions
>            Reporter: Mark Payne
>             Fix For: 0.4.0
>
>
> Currently, when we convert JSON to SQL, we make calls to the database to determine the type of each column that we are converting. We should cache this information instead of calling to the database each time, as performance will be greatly improved. We should be sure not to cache indefinitely, though, as the schema could change.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)