[
https://issues.apache.org/jira/browse/NIFI-7810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ZhangCheng updated NIFI-7810:
-----------------------------
Description:
'Translate Field Names' in PutDatabaseRecord and ConvertJSONToSQL can help us
map the field and column by
{code:java}
private static String normalizeColumnName(final String colName, final boolean
translateColumnNames) {
return translateColumnNames ? colName.toUpperCase().replace("_", "") :
colName;
}
{code}
but this rule `colName.toUpperCase().replace("_", "")` is fixed. I think maybe
we can define the rule using Expression Language.
It's vary useful for 'Translate Field Names', but sometimes, there will be
column names such as 'AB' and 'A_B' in the table, and
`colName.toUpperCase().replace("_", "")` can not help
was:
'Translate Field Names' in PutDatabaseRecord and ConvertJSONToSQL can help us
map the field and column by
{code:java}
private static String normalizeColumnName(final String colName, final boolean
translateColumnNames) {
return translateColumnNames ? colName.toUpperCase().replace("_", "") :
colName;
}
{code}
but this rule `colName.toUpperCase().replace("_", "")` is fixed. I think maybe
we can define the rule using Expression Language.
> Improvement for 'Translate Field Names'
> ---------------------------------------
>
> Key: NIFI-7810
> URL: https://issues.apache.org/jira/browse/NIFI-7810
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Extensions
> Reporter: ZhangCheng
> Assignee: ZhangCheng
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 'Translate Field Names' in PutDatabaseRecord and ConvertJSONToSQL can help us
> map the field and column by
> {code:java}
> private static String normalizeColumnName(final String colName, final boolean
> translateColumnNames) {
> return translateColumnNames ? colName.toUpperCase().replace("_", "")
> : colName;
> }
> {code}
> but this rule `colName.toUpperCase().replace("_", "")` is fixed. I think
> maybe we can define the rule using Expression Language.
> It's vary useful for 'Translate Field Names', but sometimes, there will be
> column names such as 'AB' and 'A_B' in the table, and
> `colName.toUpperCase().replace("_", "")` can not help
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
