{"action":"created","issue":{"url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/125","labels_url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/125/labels{/name}","comments_url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/125/comments","events_url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/125/events","html_url":"https://github.com/rcongiu/Hive-JSON-Serde/issues/125","id":122260596,"number":125,"title":"Error with exception for integer - JSON data","user":{"login":"srivastavakushagra999","id":13096106,"avatar_url":"https://avatars.githubusercontent.com/u/13096106?v=3","gravatar_id":"","url":"https://api.github.com/users/srivastavakushagra999","html_url":"https://github.com/srivastavakushagra999","followers_url":"https://api.github.com/users/srivastavakushagra999/followers","following_url":"https://api.github.com/users/srivastavakushagra999/following{/other_user}","gists_url":"https://api.github.com/users/srivastavakushagra999/gists{/gist_id}","starred_url":"https://api.github.com/users/srivastavakushagra999/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/srivastavakushagra999/subscriptions","organizations_url":"https://api.github.com/users/srivastavakushagra999/orgs","repos_url":"https://api.github.com/users/srivastavakushagra999/repos","events_url":"https://api.github.com/users/srivastavakushagra999/events{/privacy}","received_events_url":"https://api.github.com/users/srivastavakushagra999/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-12-15T12:18:35Z","updated_at":"2015-12-16T06:46:20Z","closed_at":"2015-12-15T13:05:54Z","body":"Hi - we are facing an issue with this serde.We imported JSON format data using this SerDe in Hive table and when we do a select * to fetch only a particular field called balance , we get the below error - \r\n\"Caused by: java.lang.NumberFormatException: For input string: \"-2380.84008789063\".\"\r\nWe expected data -2380.84008789063.\r\nThe balance field declared is an int (we have tried with float as well).Table declaration is as follows - \r\ncreate table single_customer_kush\r\n(\r\nSA_CUSTOMER array<struct<\r\nBALANCE:int,\r\nMNAME:string,\r\nSTATE:string,\r\nSINCE:string,\r\nCUSTOMER_ID:int,\r\nC_DATA:string,\r\nLNAME:string,\r\nSTREET_1:string,\r\nSTREET_2:string,\r\nPHONE_NUMBER:string,\r\nCREDIT:string,\r\nZIP:string,\r\nYTD_PAYMENT:int,\r\nCREDIT_LIMIT:string,\r\nEMAIL:string,\r\nENAME:string,\r\nCITY:string,\r\nPAYMENT_CNT:string,\r\nDELIVERY_CNT:string,\r\nDISCOUNT:string>>\r\n)\r\nROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe';\r\n\r\nand the sample data we are using is-------->\r\n\r\n\r\n {\"SA_CUSTOMER\":[{\"BALANCE\":-2380.84008789063,\"MNAME\":\"OE\",\"STATE\":\"4 \",\"SINCE\":\"2015-11-05 0\",\"CUSTOMER_ID\":8,\"C_DATA\":\"iyL0BmN06ggi0iR0yL0BPkR22BL2k6mkLP2R4 kLmky24kkRyk L42gkBB2kigy0g44gL4Lk PiRyLLBBRk6662wy4NNmwLPPNw00i2 0Pk6im R6wP4 wN2kwkB22PNR0NL6NyLPNPRB4iBBmyiL6gRNy6NgPk2ymPB0m6k0kyw40wg6 kLN4gi06mBkL mRgy0mN42m0PB00 PBRi4k6mBBgy k444 NN2iNw4igPkiNLRPiNmi2NgwBm 6NPy LRRL42kwk44Rw64igPRyBLLgP0m0ggw4N2Py6mNy40L 2ki 24k00BN4Rk y0 wP6 BPmwkiRR iy2NN2yw0RwiL6R62gkL0N4 R BwPyL2yiPw wR6k6wPiL4BRy4kP wmLw2imNP  ymgiR2gNg 06m2L0gi6y0w\",\"LNAME\":\"BARATIONCALLY\",\"STREET_1\":\"wg0RwNwiwwNB\",\"STREET_2\":\"kikk2gN 2gN\",\"PHONE_NUMBER\":\"377-991-3480    \",\"CREDIT\":\"GC\",\"ZIP\":\"802811111\",\"YTD_PAYMENT\":2380.84008789063,\"CREDIT_LIMIT\":50000,\"EMAIL\":\"someone@someplace.com\",\"ENAME\":\"2y44mPBiyB6iRyy\",\"CITY\":\"BiNRw0B06P\",\"PAYMENT_CNT\":2,\"DELIVERY_CNT\":0,\"DISCOUNT\":0.1672}]}\r\n\r\nPlease let me know what is the core issue here.Please let m know where am I going wrong.\r\n\r\nany help will be highly appreciated.\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/comments/165015891","html_url":"https://github.com/rcongiu/Hive-JSON-Serde/issues/125#issuecomment-165015891","issue_url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/125","id":165015891,"user":{"login":"srivastavakushagra999","id":13096106,"avatar_url":"https://avatars.githubusercontent.com/u/13096106?v=3","gravatar_id":"","url":"https://api.github.com/users/srivastavakushagra999","html_url":"https://github.com/srivastavakushagra999","followers_url":"https://api.github.com/users/srivastavakushagra999/followers","following_url":"https://api.github.com/users/srivastavakushagra999/following{/other_user}","gists_url":"https://api.github.com/users/srivastavakushagra999/gists{/gist_id}","starred_url":"https://api.github.com/users/srivastavakushagra999/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/srivastavakushagra999/subscriptions","organizations_url":"https://api.github.com/users/srivastavakushagra999/orgs","repos_url":"https://api.github.com/users/srivastavakushagra999/repos","events_url":"https://api.github.com/users/srivastavakushagra999/events{/privacy}","received_events_url":"https://api.github.com/users/srivastavakushagra999/received_events","type":"User","site_admin":false},"created_at":"2015-12-16T06:46:20Z","updated_at":"2015-12-16T06:46:20Z","body":"many Thanks :) "}}