Hi Smruti, Hive orc transactional support is available from Drill 1.13.0 onwards. Please update to the latest release version.
Thanks, Prasad On Wed, Mar 28, 2018 at 10:22 AM, Gautam Parai <[email protected]> wrote: > 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 > > >
