>From the error it seems like Drill barfs when trying to convert "0000112_0000" >to a number which would be expected? I am not familiar with Hive ORC but maybe >you could (temporarily) remove the offending row and try it?
Gautam ________________________________ From: Smruti Ranjan <[email protected]> Sent: Wednesday, March 28, 2018 2:19:30 AM To: [email protected] Subject: Issue in accessing ORC transactional table through apache drill Dear Team, Issue while accessing ORC transactional hive table through apache drill and below are the stack versions. Apache drill 1.10.0 Hive 1.2.1 [HDP 2.6.0 versions] Below is the error coming while accessing data from the mentioned table through apache drill. Query Failed: An Error Occurred org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: NumberFormatException: For input string: "0000112_0000" [Error Id: ad9b4243-d48d-43c7-9755-388202d7c54d on inbbrdssvm16.india.tcs.com:31010] Please help me in resolving the issue. Thanks & Regards Smruti Ranjan Jena Tata Consultancy Services Mailto: [email protected] Website: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.tcs.com&d=DwIBAg&c=cskdkSMqhcnjZxdQVpwTXg&r=jGaWXfAULy7L7yLSDM6rFQ&m=kVHrzlhCd8duKi3rDtQYq29gjO6EiXKxCg8iaz-x2h8&s=iOWB2L2JkjCw5RXZ9bkXhYhDDMFA3oOd6vPfvE-Jqnk&e= ____________________________________________ Experience certainty. IT Services Business Solutions Consulting ____________________________________________ =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
