---- On Wed, 26 Aug 2015 13:45:42 +0530 <ma...@whiteklay.in> wrote ----
Hello Experts,I have been using Hive 0.13 , where I have a column of type decimal(30,0) e.g Value: 1020140515022209000023580957 , The above value is stored properly and even displayed properly , the problem arises when I try to search with this number. When I query the table as follows: select * from test where id=1020140515022209000023580957; It returns zero rows, when I tried to trace the problem I found that it converts the number to "ppd.OpProcFactory: (id = 1.020140515022209E27)" (This is from logs while executing the query from HUE). Also to specify that I am using MapR Hadoop Distribution. Can somebody please let me know what is the issue. Thanks & regards, Mayur Saparia.