[NIFI-9377] NiFi QueryRecord Error: org.apache.calcite.runtime.CalciteException: Failed to encode '%Поиск%' in character set 'ISO-8859-1'

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.12.0, 1.12.1, 1.14.0, 1.13.2, 1.15.0
• Component/s: Extensions
• Assignee: Unassigned
• Reporter: Alexandr Mikhaylov
• Created: 13/Nov/21 13:14
• Updated: 16/Mar/22 20:52

Description

QueryrRecord Processor not working when using non-ASCII characters in a select phrase.

Example use Russian Cyrillic symbols:

JSON:

[

{ "id":"test", "message":"Search Поиск" }

]

QueryRecord Property Value:

select * from flowfile where message like '%Поиск%'

Error:

NiFi org.apache.calcite.runtime.CalciteException: Failed to encode '%Поиск%' in character set 'ISO-8859-1'