| clear query|facets|time |
Search criteria: .
Results from 11 to 20 from
44 (0.301s).
|
|
|
Loading phrases to help you
refine your search...
|
|
Re: Hive query optimization - Hive - [mail # user]
|
|
...Here is my 2 cents. The parameters you are looking at are quite specific. Unless you know what you are doing it might be hard to set them exactly right and they shouldn't make that much of a...
|
|
|
Author: Igor Tatarinov,
2012-07-24, 04:51
|
|
|
Re: Performance Issues in Hive with S3 and Partitions - Hive - [mail # user]
|
|
...Are you using EMR? Have you tried setting Hive.optimize.s3.query=true as mentioned in http://docs.amazonwebservices.com/ElasticMapReduce/latest/DeveloperGuide/emr-hive-version-de...
|
|
|
Author: Igor Tatarinov,
2012-07-24, 04:37
|
|
|
Re: Something wrong with my query to get TOP 3? - Hive - [mail # user]
|
|
...Actually, never mind. Looks like you need to partition by both bid and pid. In that case, your problem is that rank() has to handle a combined bid+pid key. So first you need to create a comb...
|
|
|
Author: Igor Tatarinov,
2012-07-19, 23:00
|
|
|
Re: Something wrong with my query to get TOP 3? - Hive - [mail # user]
|
|
...Sorry, just pid needs to be dropped from both DISTRIBUTE and SORT clauses. Your very first query was correct except for the nested subquery part. (You don't need a double-nested subquery.) &...
|
|
|
Author: Igor Tatarinov,
2012-07-19, 22:57
|
|
|
Re: Something wrong with my query to get TOP 3? - Hive - [mail # user]
|
|
...Remove pid,time from DISTRIBUTE BY. On Thu, Jul 19, 2012 at 1:45 PM, comptech geeky wrote: ...
|
|
|
Author: Igor Tatarinov,
2012-07-19, 22:43
|
|
|
Re: Obvious and not so obvious query optimzations in Hive - Hive - [mail # user]
|
|
...If you are optimizing for latency (running time) as opposed to throughput, it's best to have a single "wave" of reducers. So if your cluster is setup with a limit of, say, 2 reducers per nod...
|
|
|
Author: Igor Tatarinov,
2012-06-27, 22:44
|
|
|
Re: some queries actually fail in hive - Hive - [mail # user]
|
|
...1) You have to SELECT every column you ORDER BY (id in this case) 2) the query is the same as in 1) - I assume you actually ran a different query igor decide.com On M...
|
|
|
Author: Igor Tatarinov,
2012-06-25, 16:43
|
|
|
Re: subquery syntax error - Hive - [mail # user]
|
|
...The columns you ORDER BY must be SELECTed. If you don't want identifier2 in the output, you will need to wrap your query with another SELECT. Hope this helps. igor decide.com On ...
|
|
|
Author: Igor Tatarinov,
2012-06-06, 06:22
|
|
|
Re: Need help with simple subquery - Hive - [mail # user]
|
|
...Try replacing the comma with JOIN igor decide.com On Mon, May 28, 2012 at 6:48 AM, shan s wrote: ...
|
|
|
Author: Igor Tatarinov,
2012-05-28, 22:28
|
|
|
Re: changing field delimiter for an existing table? - Hive - [mail # user]
|
|
...That's exactly what I was looking for! Thanks! On Fri, May 11, 2012 at 5:34 PM, David Kulp wrote: ...
|
|
|
Author: Igor Tatarinov,
2012-05-12, 06:28
|
|
|
|
