Re:HIVE-1040 heads up

2011-12-13 Thread 王锋
Do you know this exception from hiveserver: java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.MapRedTask at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:194) And hivese

a serious issue of hiveserver

2011-12-13 Thread 王锋
when hiveserver is executing sql, it throws an exception: 2011-12-14 00:40:43,762 Stage-1 map = 90%, reduce = 13% 2011-12-14 00:40:45,771 Stage-1 map = 92%, reduce = 13% 2011-12-14 00:40:46,777 Stage-1 map = 96%, reduce = 13% 2011-12-14 00:40:47,782 Stage-1 map = 97%, reduce = 13% 2011-12-14

HIVE-1040 heads up

2011-12-13 Thread John Sichi
Yo if you have patches outstanding, sorry about the conflicts from the massive one-time diff update from HIVE-1040 I just committed :) JVS

Re: Confusion about IN clause

2011-12-13 Thread rohan monga
Yup, sub-queries don't work in the where clause. Is there another document and/or JIRA that i can look at for the implementation of IN clause? Regards, -- Rohan Monga On Mon, Dec 12, 2011 at 10:19 PM, Igor Tatarinov wrote: > I think the doc refers to an IN subquery > WHERE x IN (SELECT blah FR

Re: New to hive

2011-12-13 Thread rohan monga
i would also recommend cloudera tutorials. -- Rohan Monga On Tue, Dec 13, 2011 at 3:50 AM, Mohammad Tariq wrote: > Hi Praveenesh, > > If you want something other than the wiki, you can use books > like "Hadoop definitive guide" or "Hadoop in action"...These books > have dedicated chapt

one error

2011-12-13 Thread 王锋
java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.MapRedTask at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:194) the sql is correct ,but sometimes when I execute the

Re: New to hive

2011-12-13 Thread Mohammad Tariq
Hi Praveenesh, If you want something other than the wiki, you can use books like "Hadoop definitive guide" or "Hadoop in action"...These books have dedicated chapters on hive..In addition, you can also have a look at this presentation - "http://www.slideshare.net/cwsteinbach/hive-quick-st

Re:New to hive

2011-12-13 Thread 王锋
I think hive wiki is the best tutorials now by the way At 2011-12-13 19:34:35,"praveenesh kumar" wrote: >Guys, > >I have been using hadoop for 3,4 months. >Tried Map Reduce, HBase, Pig. >Now wanted to learn HIVE. >I hope it must be as exciting as other hadoop tools. >Can someone suggest me some g

New to hive

2011-12-13 Thread praveenesh kumar
Guys, I have been using hadoop for 3,4 months. Tried Map Reduce, HBase, Pig. Now wanted to learn HIVE. I hope it must be as exciting as other hadoop tools. Can someone suggest me some good tutorials, apart from HIVE wiki, which I can utilize to understand and work on hive ? Thanks, Praveenesh

hive select data throw NullPointer

2011-12-13 Thread 王锋
hive> select * from www_sinaedgeahsolci14ydn_kandian_d_hits_load_20111212 limit 30; OK Failed with exception java.io.IOException:java.lang.NullPointerException Time taken: 0.957 seconds hive> select * from www_sinaedgeahsolci14ydn_kandian_d_hits_load_20111212 limit 25; OK Failed with exception