Jira has been created @ https://issues.apache.org/jira/browse/DRILL-7328

On Wed, Jul 17, 2019 at 6:55 PM Arina Yelchiyeva <arina.yelchiyeva@gmail.com>
wrote:

> 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.mane@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.yelchiyeva@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.mane@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
> >>
> >>
>
>