Discussion:
Non-ascii characters still fails on Drill 1.11
(too old to reply)
Rahul Raj
2017-08-11 05:02:56 UTC
Permalink
Raw Message
Hi,

https://issues.apache.org/jira/browse/DRILL-4039 was fixed in 1.11. It
failed on the following query below:

SELECT
`team_long_name`
FROM
dfs.user.`football/latest`
WHERE `team_long_name` = 'Górnik Łęczna'
LIMIT 500

org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
CalciteException: Failed to encode 'Górnik Łęczna' in character set
'ISO-8859-1' [Error Id: 220b4d90-e2da-46de-8718-5377b6981220 on
vpc12.o3c.in:31010]

Can someone comment on this?

Regards,
Rahul
--
**** This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom it is
addressed. If you are not the named addressee then you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and delete this e-mail from your system.****
Rahul Raj
2017-08-11 06:05:37 UTC
Permalink
Raw Message
I have not upgraded the drill client jar to 1.11. Will upgrade and confirm.

Regards,
Rahul
Post by Rahul Raj
Hi,
https://issues.apache.org/jira/browse/DRILL-4039 was fixed in 1.11. It
SELECT
`team_long_name`
FROM
dfs.user.`football/latest`
WHERE `team_long_name` = 'Górnik Łęczna'
LIMIT 500
CalciteException: Failed to encode 'Górnik Łęczna' in character set
'ISO-8859-1' [Error Id: 220b4d90-e2da-46de-8718-5377b6981220 on
vpc12.o3c.in:31010]
Can someone comment on this?
Regards,
Rahul
--
**** This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom it is
addressed. If you are not the named addressee then you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and delete this e-mail from your system.****
Rahul Raj
2017-08-11 06:18:28 UTC
Permalink
Raw Message
Issue persist even with JDBC driver 1.11.0.
Post by Rahul Raj
I have not upgraded the drill client jar to 1.11. Will upgrade and confirm.
Regards,
Rahul
Post by Rahul Raj
Hi,
https://issues.apache.org/jira/browse/DRILL-4039 was fixed in 1.11. It
SELECT
`team_long_name`
FROM
dfs.user.`football/latest`
WHERE `team_long_name` = 'Górnik Łęczna'
LIMIT 500
CalciteException: Failed to encode 'Górnik Łęczna' in character set
'ISO-8859-1' [Error Id: 220b4d90-e2da-46de-8718-5377b6981220 on
vpc12.o3c.in:31010]
Can someone comment on this?
Regards,
Rahul
--
**** This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom it is
addressed. If you are not the named addressee then you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and delete this e-mail from your system.****
Arina Yelchiyeva
2017-08-11 11:33:44 UTC
Permalink
Raw Message
Hi Rahul,

you need to update system property *saffron.default.charset* to *UTF-16LE*.

Kind regards
Arina
Post by Rahul Raj
Issue persist even with JDBC driver 1.11.0.
com
Post by Rahul Raj
I have not upgraded the drill client jar to 1.11. Will upgrade and
confirm.
Post by Rahul Raj
Regards,
Rahul
Post by Rahul Raj
Hi,
https://issues.apache.org/jira/browse/DRILL-4039 was fixed in 1.11. It
SELECT
`team_long_name`
FROM
dfs.user.`football/latest`
WHERE `team_long_name` = 'Górnik Łęczna'
LIMIT 500
CalciteException: Failed to encode 'Górnik Łęczna' in character set
'ISO-8859-1' [Error Id: 220b4d90-e2da-46de-8718-5377b6981220 on
vpc12.o3c.in:31010]
Can someone comment on this?
Regards,
Rahul
--
**** This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom it is
addressed. If you are not the named addressee then you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and delete this e-mail from your system.****
Khurram Faraaz
2017-08-11 12:33:07 UTC
Permalink
Raw Message
We need to add a unit test, the last comment in DRILL-4039 suggests that we add a unit test for that fix.


Thanks,

Khurram

________________________________
From: Arina Yelchiyeva <***@gmail.com>
Sent: Friday, August 11, 2017 5:03:44 PM
To: user
Subject: Re: Non-ascii characters still fails on Drill 1.11

Hi Rahul,

you need to update system property *saffron.default.charset* to *UTF-16LE*.

Kind regards
Arina
Post by Rahul Raj
Issue persist even with JDBC driver 1.11.0.
com
Post by Rahul Raj
I have not upgraded the drill client jar to 1.11. Will upgrade and
confirm.
Post by Rahul Raj
Regards,
Rahul
Post by Rahul Raj
Hi,
https://issues.apache.org/jira/browse/DRILL-4039 was fixed in 1.11. It
SELECT
`team_long_name`
FROM
dfs.user.`football/latest`
WHERE `team_long_name` = 'Górnik £êczna'
LIMIT 500
CalciteException: Failed to encode 'Górnik £êczna' in character set
'ISO-8859-1' [Error Id: 220b4d90-e2da-46de-8718-5377b6981220 on
vpc12.o3c.in:31010]
Can someone comment on this?
Regards,
Rahul
--
**** This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom it is
addressed. If you are not the named addressee then you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and delete this e-mail from your system.****
Rahul Raj
2017-08-11 12:38:31 UTC
Permalink
Raw Message
Thanks Arina, It worked after setting the property.

Regards,
Rahul

On Fri, Aug 11, 2017 at 5:03 PM, Arina Yelchiyeva <
Post by Arina Yelchiyeva
Hi Rahul,
you need to update system property *saffron.default.charset* to *UTF-16LE*.
Kind regards
Arina
com>
Post by Rahul Raj
Issue persist even with JDBC driver 1.11.0.
com
Post by Rahul Raj
I have not upgraded the drill client jar to 1.11. Will upgrade and
confirm.
Post by Rahul Raj
Regards,
Rahul
On Fri, Aug 11, 2017 at 10:32 AM, Rahul Raj
Post by Rahul Raj
Hi,
https://issues.apache.org/jira/browse/DRILL-4039 was fixed in 1.11.
It
Post by Rahul Raj
Post by Rahul Raj
Post by Rahul Raj
SELECT
`team_long_name`
FROM
dfs.user.`football/latest`
WHERE `team_long_name` = 'Górnik Łęczna'
LIMIT 500
CalciteException: Failed to encode 'Górnik Łęczna' in character set
'ISO-8859-1' [Error Id: 220b4d90-e2da-46de-8718-5377b6981220 on
vpc12.o3c.in:31010]
Can someone comment on this?
Regards,
Rahul
--
**** This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom it is
addressed. If you are not the named addressee then you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and delete this e-mail from your system.****
--
**** This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom it is
addressed. If you are not the named addressee then you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and delete this e-mail from your system.****
Loading...