You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Rahul Raj <ra...@option3consulting.com> on 2017/08/11 05:02:56 UTC
Non-ascii characters still fails on Drill 1.11
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.****
Re: Non-ascii characters still fails on Drill 1.11
Posted by Khurram Faraaz <kf...@mapr.com>.
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 <ar...@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
On Fri, Aug 11, 2017 at 9:18 AM, Rahul Raj <ra...@option3consulting.com>
wrote:
> Issue persist even with JDBC driver 1.11.0.
>
> On Fri, Aug 11, 2017 at 11:35 AM, Rahul Raj <rahul.raj@option3consulting.
> com
> > wrote:
>
> > I have not upgraded the drill client jar to 1.11. Will upgrade and
> confirm.
> >
> > Regards,
> > Rahul
> >
> > On Fri, Aug 11, 2017 at 10:32 AM, Rahul Raj <rahul.raj@option3consulting.
> > com> wrote:
> >
> >> 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.****
>
Re: Non-ascii characters still fails on Drill 1.11
Posted by Rahul Raj <ra...@option3consulting.com>.
Thanks Arina, It worked after setting the property.
Regards,
Rahul
On Fri, Aug 11, 2017 at 5:03 PM, Arina Yelchiyeva <
arina.yelchiyeva@gmail.com> wrote:
> Hi Rahul,
>
> you need to update system property *saffron.default.charset* to *UTF-16LE*.
>
> Kind regards
> Arina
>
> On Fri, Aug 11, 2017 at 9:18 AM, Rahul Raj <rahul.raj@option3consulting.
> com>
> wrote:
>
> > Issue persist even with JDBC driver 1.11.0.
> >
> > On Fri, Aug 11, 2017 at 11:35 AM, Rahul Raj <rahul.raj@option3consulting.
> > com
> > > wrote:
> >
> > > I have not upgraded the drill client jar to 1.11. Will upgrade and
> > confirm.
> > >
> > > Regards,
> > > Rahul
> > >
> > > On Fri, Aug 11, 2017 at 10:32 AM, Rahul Raj
> <rahul.raj@option3consulting.
> > > com> wrote:
> > >
> > >> 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.****
> >
>
--
**** 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.****
Re: Non-ascii characters still fails on Drill 1.11
Posted by Arina Yelchiyeva <ar...@gmail.com>.
Hi Rahul,
you need to update system property *saffron.default.charset* to *UTF-16LE*.
Kind regards
Arina
On Fri, Aug 11, 2017 at 9:18 AM, Rahul Raj <ra...@option3consulting.com>
wrote:
> Issue persist even with JDBC driver 1.11.0.
>
> On Fri, Aug 11, 2017 at 11:35 AM, Rahul Raj <rahul.raj@option3consulting.
> com
> > wrote:
>
> > I have not upgraded the drill client jar to 1.11. Will upgrade and
> confirm.
> >
> > Regards,
> > Rahul
> >
> > On Fri, Aug 11, 2017 at 10:32 AM, Rahul Raj <rahul.raj@option3consulting.
> > com> wrote:
> >
> >> 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.****
>
Re: Non-ascii characters still fails on Drill 1.11
Posted by Rahul Raj <ra...@option3consulting.com>.
Issue persist even with JDBC driver 1.11.0.
On Fri, Aug 11, 2017 at 11:35 AM, Rahul Raj <rahul.raj@option3consulting.com
> wrote:
> I have not upgraded the drill client jar to 1.11. Will upgrade and confirm.
>
> Regards,
> Rahul
>
> On Fri, Aug 11, 2017 at 10:32 AM, Rahul Raj <rahul.raj@option3consulting.
> com> wrote:
>
>> 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.****
Re: Non-ascii characters still fails on Drill 1.11
Posted by Rahul Raj <ra...@option3consulting.com>.
I have not upgraded the drill client jar to 1.11. Will upgrade and confirm.
Regards,
Rahul
On Fri, Aug 11, 2017 at 10:32 AM, Rahul Raj <rahul.raj@option3consulting.com
> wrote:
> 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.****