The error would encounter when IN clause is rewritten into Join, and
planner chooses to use distributed join (involves a Hash Exchange).  For
distributed join,  when two join keys do not have same types, only certain
type of implicit cast will be allowed.  In Khurram's case, I think the
query is not using hash-distributed join method, and hence did not hit this
error.

On Fri, Jul 14, 2017 at 12:17 PM, Khurram Faraaz <[EMAIL PROTECTED]> wrote:
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB