Put "t1.obj<>t2.obj" in the where clause.
On Fri, Apr 30, 2010 at 12:14 AM, Harshit Kumar <[email protected]> wrote: > Hi > > I have a query like this > > from spo t1 join spo t2 on (t1.sub=t2.sub and t1.obj<>t2.obj) insert > overwrite table spojoin select t1.sub, t1.pre, t2.obj, t2.sub, t2.pre, > t2.obj; > > Executing the above query gives the following error. > FAILED: Error in semantic analysis: line 1:46 Both Left and Right Aliases > Encountered in Join obj > > However, If I replace the <> operator with == operator, it executes. > > Please let me know what am I doing wrong? > > Thanks > Kumar > > > -- Yours, Zheng http://www.linkedin.com/in/zshao
