Ambiguous behavior of Joins with ON clause

Posted by prabhatkashyap on Nov 04, 2016; 7:46am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Ambiguous-behavior-of-Joins-with-ON-clause-tp2632.html

Hello,

When ever I'm trying to run following query

select * from emp4 left join emp5 on emp4.id=emp4.name;

  it executes successfully.

But when I m trying to run :

select * from emp4 left join emp5 on emp4.id=emp5.name;

It gave error

Error: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String

Similarly

select * from emp5 join emp4 on emp4.id=emp5.name;

Is working but

select * from emp5 left join emp4 on emp5.id=emp4.name;

Not working

Please confirm.