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