| clear query|facets|time |
Search criteria: .
Results from 11 to 20 from
28 (2.373s).
|
|
|
Loading phrases to help you
refine your search...
|
|
Re: Percentile calculation - Hive - [mail # user]
|
|
...More info, please. On Mon, Oct 1, 2012 at 4:50 PM, Mayank Bansal wrote: on rror? s) is act ty, il...
|
|
|
Author: MiaoMiao,
2012-10-02, 03:10
|
|
|
Re: Questions about Hive - Hive - [mail # user]
|
|
...I believe Hive is not for web users, since it takes several minutes or even hours to do one query. But I managed to provide a web service via THRIFT and php. http://nousefor.net/55/2011/12/p...
|
|
|
Author: MiaoMiao,
2012-09-18, 01:28
|
|
|
Re: Does hive support nested queries? - Hive - [mail # user]
|
|
...Yes, + is an operator. t1 a b 1 2 3 4 and the result will be: col 3 7 On Mon, Sep 17, 2012 at 4:43 PM, Amila Maha Arachchi wrote:...
|
|
|
Author: MiaoMiao,
2012-09-17, 08:53
|
|
|
Re: insert into table not working with tables prefixed with database name - Hive - [mail # user]
|
|
...Yes, same problem here, sorry I missed your point and tested only once. On Fri, Sep 14, 2012 at 10:13 PM, Kaufman Ng wrote:...
|
|
|
Author: MiaoMiao,
2012-09-17, 05:17
|
|
|
Re: Show job progress when using JDBC to run HIVE query - Hive - [mail # user]
|
|
...Not familiar with JDBC, but thrift seems can't. On Sat, Sep 15, 2012 at 3:17 AM, Haijia Zhou wrote:...
|
|
|
Author: MiaoMiao,
2012-09-17, 04:17
|
|
|
Re: How to overwrite a file inside hive table folder - Hive - [mail # user]
|
|
...What do you mean by "a file"? If your HDFS dir contains several file and you want to overwrite one, then no way you can do it with HiveQL. You can check out this link and see if it suits you...
|
|
|
Author: MiaoMiao,
2012-09-17, 04:12
|
|
|
Re: insert into table not working with tables prefixed with database name - Hive - [mail # user]
|
|
...This query works on my hive 0.8 insert into table tmp.testtest select user,city from source; On Fri, Sep 14, 2012 at 4:36 AM, Kaufman Ng wrote:...
|
|
|
Author: MiaoMiao,
2012-09-14, 03:07
|
|
|
Re: most efficient way to concatenate 3 tables into one? - Hive - [mail # user]
|
|
...Then you will get a copy of each sub table. My project use external partitions instead, and in this way, you don't need to cp sub tables. 1) Create a table some_table 2) ALTER TABLE some_tab...
|
|
|
Author: MiaoMiao,
2012-09-13, 01:25
|
|
|
Re: How to get percentage of each group? - Hive - [mail # user]
|
|
...Yeah I figure it out, this query will create 3 jobs, it seems to do sub-queries without any optimization. SELECT A.userType , A.userType_count/B.glob...
|
|
|
Author: MiaoMiao,
2012-09-07, 07:10
|
|
|
Re: How to get percentage of each group? - Hive - [mail # user]
|
|
...You mean this one? Hive 0.8 doesn't have CROSS JOIN, so I don't know if this query works. SELECT A.userType , A.userType_count/B.global_count FROM &...
|
|
|
Author: MiaoMiao,
2012-09-07, 06:16
|
|
|
|
