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

["Pierre Villard (Jira)" <ji...@apache.org>]

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

Pierre Villard edited comment on NIFI-9377 at 11/18/21, 12:53 PM:
------------------------------------------------------------------

Did you try setting an environment variable for NiFi (in bootstrap.conf)?
{code:java}
calcite.default.charset=utf-8 {code}


was (Author: pvillard):
Did you try setting an environment variable for NiFi (in bootstrap.conf)?
{code:java}
calcite.default.charset=urf-8 {code}

> NiFi QueryRecord Error:  org.apache.calcite.runtime.CalciteException: Failed to encode '%Поиск%' in character set 'ISO-8859-1'
> ------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: NIFI-9377
>                 URL: https://issues.apache.org/jira/browse/NIFI-9377
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Extensions
>    Affects Versions: 1.12.0, 1.12.1, 1.14.0, 1.13.2, 1.15.0
>            Reporter: Alexandr Mikhaylov
>            Priority: Major
>         Attachments: image-2021-11-13-16-07-59-879.png
>
>
> 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'
>  



--
This message was sent by Atlassian Jira
(v8.20.1#820001)