Have created jira at https://issues.apache.org/jira/browse/HIVE-22008 <https://www.google.com/url?q=https://issues.apache.org/jira/browse/HIVE-22008&sa=D&source=hangouts&ust=1563538731290000&usg=AFQjCNHrfFVVopKL-7k-5dGBYICOVAHMDg>
On Wed, 17 Jul 2019, 16:44 Shankar Mane, <ssma...@gmail.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) > > > > *-------------------------------------------------- Presto Queries > -----------------------------------------------------* > FYI - Presto (v0.221) is using above table meta store. We tested above > queries on presto too. > > *--1) **result = **success* > > presto> select * from default.withdraw where id like '%withdraw%'; > id > ---------- > withdraw > cash > (1 row) > > > *--2) **result = **success* > > presto> select * from default.withdraw where id like '%withdraw%cash'; > id > ---------- > withdraw > cash > (1 row) > > > *--3) **result = **success* > > presto> select * from default.withdraw where id like '%cash%'; > id > ---------- > withdraw > cash > (1 row) > > *-------------------------------------------------- * > *-------------------------------------------------- * > > Please help here in case i am missing anything. > > regards, > shankar > > >