I wonder if the meta-tool can help? https://cwiki.apache.org/confluence/display/Hive/Hive+MetaTool ... View more

Thank you! According the cloudera jdbc documentation this is the right format: jdbc:hive2://zk=hadoopcluster01:2181,hadoopcluster02:2181/hiveserver2 both of course I tried both way... unfortunatelly it was not work. So I changed it to the original hive jdbc: <dependency>             <groupId>org.apache.hive</groupId>             <artifactId>hive-jdbc</artifactId>             <version>1.2.1</version> </dependency>   and it looks good now! 😉 ... View more

This behavior is like any system with float representation, float bit representation does not allow exact representation of most values.  There is a lot of literature on the subject like  http://docs.oracle.com/cd/E19957-01/806-3568/ncg_goldberg.html   If you want exact values it's better to go with decimal, where you can specify scale and precision.   Thanks Szehon ... View more