Well, looks like a bug, you can fill in Drill Jira (please include reproduce 
steps).

Contributions are always welcome!

Kind regards,
Arina

> On Jul 17, 2019, at 4:13 PM, Shankar Mane <shankar.m...@games24x7.com> wrote:
> 
> Hi,  just tested on *Drill 1.16.0 (docker) *:
> 
> *--1) **result = success*
> apache drill> select * from hive.default.withdraw;
> +---------------+
> |      id       |
> +---------------+
> | withdraw
> cash |
> +---------------+
> 1 row selected (0.189 seconds)
> 
> 
> *--2) **result = success*
> apache drill> select * from hive.default.withdraw where id  like
> '%withdraw%';
> +---------------+
> |      id       |
> +---------------+
> | withdraw
> cash |
> +---------------+
> 1 row selected (0.168 seconds)
> 
> 
> *--3) **result = wrong*
> apache drill> select * from hive.default.withdraw where id  like
> '%withdraw%cash';
> +----+
> | id |
> +----+
> +----+
> No rows selected (0.214 seconds)
> 
> 
> *--4)* *result = success*
> apache drill> select * from hive.default.withdraw where id  like '%cash%';
> +---------------+
> |      id       |
> +---------------+
> | withdraw
> cash |
> +---------------+
> 1 row selected (0.181 seconds)
> 
> 
> 
> 
> 
> On Wed, Jul 17, 2019 at 5:03 PM Arina Yelchiyeva <arina.yelchiy...@gmail.com>
> wrote:
> 
>> Hi Shankar,
>> 
>> To verify behavior on the latest Drill version, you can download Drill
>> from here https://drill.apache.org/download/ <
>> https://drill.apache.org/download/>.
>> 
>> Kind regards,
>> Arina
>> 
>>> On Jul 17, 2019, at 2:29 PM, Shankar Mane <shankar.m...@games24x7.com>
>> wrote:
>>> 
>>> Hi All,
>>> 
>>> I am facing some issues while using Like operator & newline (\n)
>> character.
>>> Below is the in details description :
>>> 
>>> *-------------------------------------------------- Hive Queries
>>> ------------------------------------------------------------*
>>> 
>>> create table default.withdraw(
>>> id string
>>> ) stored as parquet;
>>> 
>>> 
>>> insert into default.withdraw select 'withdraw\ncash';
>>> 
>>> 
>>> *--1)  result = success*
>>> 
>>> hive> select * from default.withdraw where id like '%withdraw%';
>>> OK
>>> withdraw
>>> cash
>>> Time taken: 0.078 seconds, Fetched: 1 row(s)
>>> 
>>> 
>>> *--2) **result = wrong*
>>> 
>>> hive> select * from default.withdraw where id like '%withdraw%cash';
>>> OK
>>> Time taken: 0.066 seconds
>>> 
>>> 
>>> *--3) **result = success*
>>> 
>>> hive> select * from default.withdraw where id like '%cash%';
>>> OK
>>> withdraw
>>> cash
>>> Time taken: 0.086 seconds, Fetched: 1 row(s)
>>> 
>>> 
>>> 
>>> *-------------------------------------------------- Drill Queries
>>> -----------------------------------------------------*
>>> FYI - Drill (v1.10.0) is using above table meta store. We tested above
>>> queries on drill too.
>>> 
>>> *Summary* - I m getting unexpected results in this version (1.10.0). *Can
>>> someone please confirm what is the output on latest Drill version ?*
>>> 
>>> Here are the Drill queries and its outputs:
>>> 
>>> *--1) result = success*
>>> 
>>> 0: jdbc:drill:> select * from withdraw;
>>> +----------------+
>>> |       id       |
>>> +----------------+
>>> | withdraw
>>> cash  |
>>> +----------------+
>>> 1 row selected (0.34 seconds)
>>> 
>>> 
>>> *--2) **result = wrong*
>>> 
>>> 0: jdbc:drill:> select * from withdraw where id like '%withdraw%';
>>> +-----+
>>> | id  |
>>> +-----+
>>> +-----+
>>> No rows selected (1.219 seconds)
>>> 
>>> 
>>> 
>>> 
>>> *--3) **result = wrong*
>>> 
>>> 0: jdbc:drill:> select * from withdraw where id like '%withdraw%cash';
>>> +-----+
>>> | id  |
>>> +-----+
>>> +-----+
>>> No rows selected (0.188 seconds)
>>> 
>>> 
>>> 
>>> *--4) **result = wrong*
>>> 
>>> 0: jdbc:drill:> select * from withdraw where id like '%cash%';
>>> +-----+
>>> | id  |
>>> +-----+
>>> +-----+
>>> No rows selected (0.181 seconds)
>>> 
>>> *-------------------------------------------------- *
>>> *-------------------------------------------------- *
>>> 
>>> Please help here in case i am missing anything.
>>> 
>>> regards,
>>> shankar
>> 
>> 

Reply via email to