Re: Re: join on different data type

Also. Refer section "*Allowed Implicit Conversions*" on https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types It had given a try on joining tables on STRING and INT column , it should work through implicit conversions. Regards Sanjiv Singh Mob : +091 9990-447-339 On Mon,

Re: Too many connections from hive to zookeeper

Setting the hive.server2.enable.doAs property to false does fix the problem but may causes file permission problems. If upgrading Hive is not permitted, maybe compiling the related Hive packages with this patch (https://issues.apache.org/jira/browse/HIVE-9119) to replace the jars in the lib will w