Home | About | Sematext search-lucene.com search-hadoop.com
clear query|facets|time Search criteria: .   Results from 11 to 20 from 143 (0.1s).
Loading phrases to help you
refine your search...
Re: date format question - Hive - [mail # user]
...You could use the unix_timestamp function ...  unix_timestamp(ts, ) >= unix_timestamp("2012-09-10", 'yyyy-MM-dd') ...  something on those lines  Also checkout https://cwiki...
   Author: Ashish Thusoo, 2012-09-17, 21:17
Re: Hive client / thrift service query submission auditing - Hive - [mail # user]
...Hey Matt,  We did something similar at Facebook to capture the information on who ran what on the clusters and dumped that out to an audit db. Specifically we were using Hive post execu...
   Author: Ashish Thusoo, 2012-09-12, 18:20
Re: Converting rows into dynamic colums in Hive - Hive - [mail # user]
...you should be able to do this in hive using a group by on alpha and then using a combination of the max and if statement... something on the following lines  select alpha, max(abc), max...
   Author: Ashish Thusoo, 2012-08-07, 21:04
Re: SQL help - Hive - [mail # user]
...Hi Mohit,  Hive does not support window functions afaik.  The following link might be useful if you can bring that in...  https://github.com/hbutani/SQLWindowing/wiki  No...
   Author: Ashish Thusoo, 2012-05-24, 20:53
[HIVE-1449] Table aliases in order by clause lead to semantic analysis failure - Hive - [issue]
...A simple statement of the formselect a.account_id, count(1) from tmp_ash_test2 a group by a.account_id order by a.account_id;throws a sematic analysis exceptionwhere asselect a.account_id, c...
http://issues.apache.org/jira/browse/HIVE-1449    Author: Ashish Thusoo, 2012-05-17, 19:03
Re: how to select without Mapreduce after index build´╝č - Hive - [mail # user]
...Indexing in Hive works through map/reduce. There are no active components in Hive (such as the region servers in Hbase), so the way the index is basically used is by running the map/reduce j...
   Author: Ashish Thusoo, 2012-05-11, 16:17
Re: Passing date as hive configuration variable - Hive - [mail # user]
...I think you have to put quotes around the variable to tell give that you are comparing against a string...  Ashish On May 10, 2012 2:06 PM, "Saurabh S"  wrote:  ...
   Author: Ashish Thusoo, 2012-05-10, 18:35
Re: Dimensional Data Model on Hive - Hive - [mail # user]
...Also of most of the things that you will be doing is full scans as opposed to needle in haystack queries there is usually no point in paying the overhead of running hbase region servers. Onl...
   Author: Ashish Thusoo, 2012-05-10, 15:16
Re: Dynamic partitions in Hive - Hive - [mail # user]
...According to  https://cwiki.apache.org/Hive/dynamicpartitions.html  for dynamic partitions the partition clause must look like  PARTITION(year, month, edate)  the actual ...
   Author: Ashish Thusoo, 2012-04-25, 14:09
Re: Hive on Standalone Machine - Hive - [mail # user]
...Hive needs the hadoop jars to talk to hadoop. The machine that it is installed on has to have those jars installed. However, it does not need to be a "part" of the hadoop cluster in the sens...
   Author: Ashish Thusoo, 2012-04-25, 13:07
Hive (143)
Hadoop (6)
MapReduce (1)
mail # user (98)
issue (38)
mail # dev (7)
last 7 days (0)
last 30 days (0)
last 90 days (1)
last 6 months (1)
last 9 months (143)
Namit Jain (645)
Carl Steinbach (416)
Brock Noland (399)
Zheng Shao (382)
Ashutosh Chauhan (348)
Edward Capriolo (298)
Navis (292)
Gunther Hagleitner (235)
Thejas M Nair (221)
Xuefu Zhang (216)
Lefty Leverenz (214)
John Sichi (212)
Ning Zhang (171)
Sergey Shelukhin (158)
Kevin Wilfong (152)
Thejas Nair (149)
Harish Butani (145)
He Yongqiang (139)
Jason Dere (136)
Eugene Koifman (125)
Szehon Ho (121)
Vaibhav Gumashta (116)
Nitin Pawar (113)
Alan Gates (110)
Eric Hanson (108)
Ashish Thusoo