"Already had POJO for id" Error In SQL - Join B/W Redshift and HDFS

[Rohit Kulkarni]

Hello all,

I am sure if not all of you, but some of you must have seen this error some
time -

*Error: SYSTEM ERROR: IllegalStateException: Already had POJO for id
(java.lang.Integer)
[com.fasterxml.jackson.annotation.ObjectIdGenerator$IdKey@3372bbe8]*

​I am trying to do a join between Redshift (JDBC​) and HDFS like this -




*select count(*)from hdfs.drill.TAGS_US as aright join
redshift.reports.public.us_tags as bon a.cvalue = b.tag_value;*


I don't see anything wrong in the query. The two individual tables return
proper data when fired a query separately. Is something missing or am I
doing something wrong?

Would very much appreciate your help! Thanks!!

-- 
Warm Regards,
Rohit Kulkarni