Re: COMMERCIAL:Re: Hive - regexp_replace function for multiple strings

2015-02-12 Thread Viral Parikh
8 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Cc: Viral Parikh mailto:viral.j.par...@gmail.com>> Subject: RE: COMMERCIAL:Re: Hive - regexp_replace function for multiple strings Below 2 solutions. Solution1 uses lookahead and l

Hive - regexp_replace function for multiple strings

2015-02-03 Thread Viral Parikh
Hi Everyone, I am using hive 0.13! I want to find multiple tokens like "hip hop" and "rock music" in my data and replace them with "hiphop" and "rockmusic" - basically replace them without white space. I have used the regexp_replace function in hive. Below is my query and it works great for above

Python API to Read Data from Hive / Hadoop

2014-11-11 Thread Viral Parikh
Hi Fellow Hive Users! Has anyone tried to access Hive (which is on the Linux box) using Ipython / Python? I am using windows 7 64 bit machine and I am trying to use some python packages likes hive_utils and pyhs2 but when I install I am having some errors. My hadoop platform is supported by Horto

Access Hive via ipython

2014-11-10 Thread Viral Parikh
Hi Hive Users! Has anyone tried to access Hive (which is on the Linux box) using Ipython / Python? I am using windows 7 64 bit machine and I am trying to use some python packages likes hive_utils but when I install I am having some issues? Is there any way to extract data from hive using ipython

Re: Correlated Subqueries Workaround in Hive!

2014-09-15 Thread Viral Parikh
t with that > if location turns out to be '-1' > > On 15 September 2014 17:01, Nitin Pawar wrote: > >> have you taken a look at lag and lead functions ? >> >> On Mon, Sep 15, 2014 at 4:46 PM, Viral Parikh >> wrote: >> >>> To Whomsoever

Correlated Subqueries Workaround in Hive!

2014-09-15 Thread Viral Parikh
To Whomsoever It May Concern, I posted this question last week but still haven't heard from anyone; I'd appreciate any reply. I've got a table that contains a LocationId field. In some cases, where a record shares the same foreign key, the LocationId might come through as -1. What I want to do i

Re: Return value from previous record if value is -1 using HIVE

2014-09-12 Thread Viral Parikh
1.record AND T2.fk = T1.fk AND T2.location != -1 ORDER BY T2.Record DESC ) ENDFROM#temp1 AS T1 Thank you for your help in advance! On Fri, Sep 12, 2014 at 11:33 AM, Viral Parikh wrote: > To Whomsoever It May Concern, > > I&#x