Re: Apache Hive 2.3.4 - Issue with combination of Like operator & newline (\n) character in data
It will worked when your aware of data. This solution is not suitable when column data is unknown and dynamic in nature. On Mon, 29 Jul 2019, 21:50 Sungwoo Park, wrote: > Not a solution, but one can use \n in the search string, e.g.: > > select * from default.withdraw where id like '%withdraw\ncash'; > select * from default.withdraw where id like '%withdraw%\ncash'; > select * from default.withdraw where id like '%withdraw%\n%cash'; > > --- Sungwoo > > > On Tue, Jul 30, 2019 at 12:58 AM Shankar Mane wrote: > >> Can anyone looking at this issue ? >> >> On Sat, Jul 20, 2019 at 9:08 AM Shankar Mane wrote: >> >>> 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=156353873129&usg=AFQjCNHrfFVVopKL-7k-5dGBYICOVAHMDg> >>> >>> On Wed, 17 Jul 2019, 16:44 Shankar Mane, 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 >>>> >>>> >>>>
Re: Apache Hive 2.3.4 - Issue with combination of Like operator & newline (\n) character in data
Can anyone looking at this issue ? On Sat, Jul 20, 2019 at 9:08 AM Shankar Mane wrote: > 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=156353873129&usg=AFQjCNHrfFVVopKL-7k-5dGBYICOVAHMDg> > > On Wed, 17 Jul 2019, 16:44 Shankar Mane, 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 >> >> >>
Re: Apache Hive 2.3.4 - Issue with combination of Like operator & newline (\n) character in data
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=156353873129&usg=AFQjCNHrfFVVopKL-7k-5dGBYICOVAHMDg> On Wed, 17 Jul 2019, 16:44 Shankar Mane, 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 > > >
Apache Hive 2.3.4 - Issue with combination of Like operator & newline (\n) character in data
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
Re: Hiveserver2 - Beeline How to enable progress bar (Tez)
Does anyone has this is working. I am still looking for response here. On Fri 2 Feb, 2018, 3:03 PM Shankar Mane, wrote: > I have set Tez as a default execution engine. > > On 02-Feb-2018 2:59 PM, "Margusja" wrote: > > Does it depends what kind of engine you are using - tez versus mr? > > Br margus > > > On 1 Feb 2018, at 17:57, Shankar Mane wrote: > > Any update? > > I m not getting progress bar with beeline client. tried both embedded and > remote connection. > > It's working properly with Hive CLI. > > > On 30-Jan-2018 6:01 PM, "Shankar Mane" wrote: > > May i know, how to enable Tez progress bar in beeline ? I am using Tez has > a execution engine. > > I have followed some steps but failed. steps are: > set hive.async.log.enable=false > set hive.server2.in.place.progress=true > > > Env Details: > RHEL > hive 2.3.2 > hadoop 2.9.0 > Tez 0.9.1 > Apache Distribution > > Also while connecting to hiveserver, i am getting below error: > > > 2018-01-30T16:08:46,204 INFO [main] http.HttpServer: Started > HttpServer[hiveserver2] on port 10002 > Exception in thread > "org.apache.hadoop.hive.common.JvmPauseMonitor$Monitor@2489e84a" > java.lang.NoSuchMethodError: > com.google.common.base.Stopwatch.elapsed(Ljava/util/concurrent/TimeUnit;)J > at > org.apache.hadoop.hive.common.JvmPauseMonitor$Monitor.run(JvmPauseMonitor.java:185) > at java.lang.Thread.run(Thread.java:748) > > > > > > >
Re: Hiveserver2 - Beeline How to enable progress bar (Tez)
I have set Tez as a default execution engine. On 02-Feb-2018 2:59 PM, "Margusja" wrote: Does it depends what kind of engine you are using - tez versus mr? Br margus On 1 Feb 2018, at 17:57, Shankar Mane wrote: Any update? I m not getting progress bar with beeline client. tried both embedded and remote connection. It's working properly with Hive CLI. On 30-Jan-2018 6:01 PM, "Shankar Mane" wrote: May i know, how to enable Tez progress bar in beeline ? I am using Tez has a execution engine. I have followed some steps but failed. steps are: set hive.async.log.enable=false set hive.server2.in.place.progress=true Env Details: RHEL hive 2.3.2 hadoop 2.9.0 Tez 0.9.1 Apache Distribution Also while connecting to hiveserver, i am getting below error: 2018-01-30T16:08:46,204 INFO [main] http.HttpServer: Started HttpServer[hiveserver2] on port 10002 Exception in thread "org.apache.hadoop.hive.common .JvmPauseMonitor$Monitor@2489e84a" java.lang.NoSuchMethodError: com.google.common.base.Stopwatch.elapsed(Ljava/util/concurrent/TimeUnit;)J at org.apache.hadoop.hive.common.JvmPauseMonitor$Monitor.run(Jv mPauseMonitor.java:185) at java.lang.Thread.run(Thread.java:748)
Re: Hiveserver2 - Beeline How to enable progress bar (Tez)
Any update? I m not getting progress bar with beeline client. tried both embedded and remote connection. It's working properly with Hive CLI. On 30-Jan-2018 6:01 PM, "Shankar Mane" wrote: May i know, how to enable Tez progress bar in beeline ? I am using Tez has a execution engine. I have followed some steps but failed. steps are: set hive.async.log.enable=false set hive.server2.in.place.progress=true Env Details: RHEL hive 2.3.2 hadoop 2.9.0 Tez 0.9.1 Apache Distribution Also while connecting to hiveserver, i am getting below error: 2018-01-30T16:08:46,204 INFO [main] http.HttpServer: Started HttpServer[hiveserver2] on port 10002 Exception in thread "org.apache.hadoop.hive.common .JvmPauseMonitor$Monitor@2489e84a" java.lang.NoSuchMethodError: com.google.common.base.Stopwatch.elapsed(Ljava/util/concurrent/TimeUnit;)J at org.apache.hadoop.hive.common.JvmPauseMonitor$Monitor.run(Jv mPauseMonitor.java:185) at java.lang.Thread.run(Thread.java:748)
Hiveserver2 - Beeline How to enable progress bar (Tez)
May i know, how to enable Tez progress bar in beeline ? I am using Tez has a execution engine. I have followed some steps but failed. steps are: set hive.async.log.enable=false set hive.server2.in.place.progress=true Env Details: RHEL hive 2.3.2 hadoop 2.9.0 Tez 0.9.1 Apache Distribution Also while connecting to hiveserver, i am getting below error: 2018-01-30T16:08:46,204 INFO [main] http.HttpServer: Started HttpServer[hiveserver2] on port 10002 Exception in thread "org.apache.hadoop.hive.common.JvmPauseMonitor$Monitor@2489e84a" java.lang.NoSuchMethodError: com.google.common.base.Stopwat ch.elapsed(Ljava/util/concurrent/TimeUnit;)J at org.apache.hadoop.hive.common.JvmPauseMonitor$Monitor.run(Jv mPauseMonitor.java:185) at java.lang.Thread.run(Thread.java:748)
