Home | About | Sematext search-lucene.com search-hadoop.com
clear query|facets|time Search criteria: .   Results from 1 to 10 from 17 (0.135s).
Loading phrases to help you
refine your search...
HIVE QUERY HELP:: HOW TO IMPLEMENT THIS CASE - Hive - [mail # user]
...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
Sort:
project
Hive (16)
MapReduce (9)
Pig (8)
Sqoop (7)
HDFS (2)
Hadoop (1)
type
mail # user (17)
date
last 7 days (0)
last 30 days (0)
last 90 days (3)
last 6 months (8)
last 9 months (17)
author
Namit Jain (645)
Carl Steinbach (419)
Zheng Shao (382)
Brock Noland (294)
Edward Capriolo (291)
Ashutosh Chauhan (262)
Navis (248)
John Sichi (212)
Gunther Hagleitner (197)
Thejas M Nair (178)
Ning Zhang (170)
Lefty Leverenz (156)
Kevin Wilfong (152)
He Yongqiang (139)
Xuefu Zhang (134)
yogesh dhari