| clear query|facets|time |
Search criteria: .
Results from 21 to 28 from
28 (0.186s).
|
|
|
Loading phrases to help you
refine your search...
|
|
How to get percentage of each group? - Hive - [mail # user]
|
|
...I have a table, containing userId and userType. userId userType 1 A 2 B 3 C 4 A 5 B 6 B I wan...
|
|
|
Author: MiaoMiao,
2012-09-07, 05:23
|
|
|
Re: How to set default value for a certain field? - Hive - [mail # user]
|
|
...Thank you all, guess I just have to do it this way. On Thu, Sep 6, 2012 at 11:50 AM, Philip Tromans wrote:...
|
|
|
Author: MiaoMiao,
2012-09-06, 04:10
|
|
|
Re: How to set default value for a certain field? - Hive - [mail # user]
|
|
...You mean COALESCE(value,3)? This does work on int field, and easier than IF select value,COALESCE(value,3) from testtest; 1 1 1 1 2 2 NULL 3 NULL 3 On Wed, Sep 5, 2012 at 7:52 PM...
|
|
|
Author: MiaoMiao,
2012-09-06, 03:37
|
|
|
Re: How to set default value for a certain field? - Hive - [mail # user]
|
|
...COALESCE how? COALESCE(VALUE) will return VALUE or null. I know this query works select IF(VALUE is NULL,3,VALUE) from testtest; But I have to do this conditional check on every ...
|
|
|
Author: MiaoMiao,
2012-09-06, 03:28
|
|
|
Re: How to set default value for a certain field? - Hive - [mail # user]
|
|
...This will certainly work, but with 20 tables, each of 20GB size, using insert overwrite could take up both time and space a lot. On Wed, Sep 5, 2012 at 7:57 PM, wrote: s value...
|
|
|
Author: MiaoMiao,
2012-09-06, 03:20
|
|
|
Re: loading logfile into hive tables using certain format - Hive - [mail # user]
|
|
...I tried import apache2 log into hive a few weeks ago, and took a look at SERDEPROPERTIES, but it was too complicated and pasting others' demo wouldn't work. Then I came up with another...
|
|
|
Author: MiaoMiao,
2012-09-04, 10:52
|
|
|
Re: Group by clause gives error - Hive - [mail # user]
|
|
...You need to apply an aggregate function to NAME since it's not used as a GROUP BY key. Without an aggregate function, your query will be confusing. I mean, what does `select name from ...
|
|
|
Author: MiaoMiao,
2012-08-10, 08:12
|
|
|
Hive job got stuck in the last task - Hive - [mail # user]
|
|
...Hi there, I've been doing a few pre-research of hive for my project, and met a problem recently. I tried this query in hive cli, "select count(1) from day_20120629_main a join day_2012...
|
|
|
Author: MiaoMiao,
2012-08-10, 06:29
|
|
|
|
