RE: LEFT OUTER JOIN and partition

2012-01-02 Thread mdefoinplatel.ext
Hi Mark, First of all, Happy New Year ! And sorry for the late answer... I had the hive.optimize.ppd option set to true already so it explains why the query works fast : SELECT count(A.id) FROM a LEFT OUTER JOIN b ON (A.id=B.id AND B.dt=X) WHERE A.dt=X AND B.id IS NULL; I am relatively happy w

Re: Hive command line- select

2012-01-02 Thread vikas Srivastava
@ check you jobtracker or tasktracker is running or not ... On Mon, Jan 2, 2012 at 7:23 PM, wd wrote: > Because 'select *' will not run map reduce job, may be you should > check if your hadoop cluster is work > > On Mon, Jan 2, 2012 at 10:37 AM, Aditya Kumar > wrote: > > > > Hi, > > I am able t

Re: Jira is down?

2012-01-02 Thread Aniket Mokashi
Thanks Steven! On Mon, Jan 2, 2012 at 9:50 PM, Steven Wong wrote: > http://monitoring.apache.org/status/ > > ** ** > > ** ** > > *From:* Aniket Mokashi [mailto:aniket...@gmail.com] > *Sent:* Monday, January 02, 2012 4:04 PM > *To:* user@hive.apache.org > *Subject:* Jira is down? > > **

RE: Jira is down?

2012-01-02 Thread Steven Wong
http://monitoring.apache.org/status/ From: Aniket Mokashi [mailto:aniket...@gmail.com] Sent: Monday, January 02, 2012 4:04 PM To: user@hive.apache.org Subject: Jira is down? Looks like asf jira is down. Is this a scheduled downtime? Where should I subscribe to get updates about it? https://iss

Jira is down?

2012-01-02 Thread Aniket Mokashi
Looks like asf jira is down. Is this a scheduled downtime? Where should I subscribe to get updates about it? https://issues.apache.org/jira Thanks, Aniket

Re: Hive command line- select

2012-01-02 Thread wd
Because 'select *' will not run map reduce job, may be you should check if your hadoop cluster is work On Mon, Jan 2, 2012 at 10:37 AM, Aditya Kumar wrote: > > Hi, > I am able to install hive, and create a table (external) and map it to my > Hbasetable. > > I am able to do > hive>select * from m