Home | About | Sematext search-lucene.com search-hadoop.com
clear query|facets|time Search criteria: .   Results from 1 to 10 from 17 (0.104s).
Loading phrases to help you
refine your search...
...Hello All,I have a use case in RDBMS query which I have implemented inHIVE as..*1.1) Update statement* *in RDBMS*update  TABLE1setAge= case when isnull(age,'') ='' then 'A= Current' els...
   Author: yogesh dhari, 2014-03-04, 06:46
Re: Hive Query :: Implementing case statement - Hive - [mail # user]
...Hello Stephen ,Yes, actully I have used Left Outer Join instead of Join, there were leftouter joins in RDBMS Query instead of join.Thanks again :)On Thu, Feb 20, 2014 at 10:45 AM, Stephen Sp...
   Author: yogesh dhari, 2014-02-20, 07:05
HIVE SUB QUERY:: How to implement this case - Hive - [mail # user]
...Hello all,  I have a case statement where I need to work like this logic.  select as_of_dt as as_of_dt, max_feed_key as max_feed_key, min_feed_key as min_feed_key from table feed_k...
   Author: yogesh dhari, 2014-01-22, 17:42
Re: working with HIVE VARIALBE: Pls suggest - Hive - [mail # user]
...Thanks all for your help..  I think was not so much clear about what I was trying to do...  I was just trying to create a variable  in Hive like in RDBMS,  and want to st...
   Author: yogesh dhari, 2014-01-06, 18:24
Setting value into hive varialble - Hive - [mail # user]
...Hello All,   I have a case statement, where I need to check the date passed through parameter,  If date is 1st date of the month then keep it as it as else set the parameter date t...
   Author: yogesh dhari, 2014-01-02, 11:56
CASE Statement not working in hive - Hive - [mail # user]
...Hello all,    I have wrote this query .    *" select*  *case when as_date rlike '2013-05-01' then as_date else '2013-07-04' end as as_date from table AA ; " *  ...
   Author: yogesh dhari, 2013-12-24, 12:04
Re: to find the 1st day of the month in hive - Hive - [mail # user]
...Hi, Can i use this.  select date_sub('2013-12-08', (day('2013-12-08')) -1) from table.  just want to cross chk   On Tue, Dec 24, 2013 at 3:48 PM, yogesh dhari  wrote: &nb...
   Author: yogesh dhari, 2013-12-24, 10:55
Re: Date format in Hive - Hive - [mail # user]
...Java nahi aati, to udf kaha se likhu..  koi hive ka function hi bata ya work around it..  ya fir shell script me kaisey kerney ka h ...   On Tue, Dec 24, 2013 at 12:47 PM, &nb...
   Author: yogesh dhari, 2013-12-24, 08:38
JOIN comparasion  PIG V/S HIVE - Hive - [mail # user]
...Hi All,  Is it true that Pig's JOIN operation is not so efficient as of HIVE.  I have just tried over and found differences over JOIN query.  Hive resulted the same as My Sql ...
   Author: yogesh dhari, 2012-10-22, 18:22
RE: NEED HELP in Hive Query - Hive - [mail # user]
...Thanks John :-),  I got it now in Pig also :-).  A = load '/File/000000_0' using PigStorage('\u0001')    as as (name, date, url, hit:INT);   B = group A by (id, name...
   Author: yogesh dhari, 2012-10-14, 17:52
Hive (16)
MapReduce (9)
Pig (8)
Sqoop (7)
HDFS (2)
Hadoop (1)
mail # user (17)
last 7 days (0)
last 30 days (0)
last 90 days (0)
last 6 months (2)
last 9 months (17)
Namit Jain (645)
Carl Steinbach (417)
Zheng Shao (382)
Brock Noland (310)
Ashutosh Chauhan (298)
Edward Capriolo (297)
Navis (277)
Gunther Hagleitner (221)
John Sichi (212)
Thejas M Nair (197)
Lefty Leverenz (191)
Xuefu Zhang (180)
Ning Zhang (171)
Kevin Wilfong (152)
He Yongqiang (139)
Sergey Shelukhin (135)
Harish Butani (121)
Eugene Koifman (117)
Thejas Nair (113)
Eric Hanson (108)
Jason Dere (108)
Nitin Pawar (107)
Prasad Mujumdar (104)
Vaibhav Gumashta (103)
Szehon Ho (102)
yogesh dhari