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
