drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arina Yelchiyeva <arina.yelchiy...@gmail.com>
Subject Re: Apache Drill 1.10.0 - Issue with combination of Like operator & newline (\n) character in data
Date Wed, 17 Jul 2019 11:33:38 GMT
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


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message