Rahul, I had a similar problem last week and yes it is a line separator issue. Edmon Begoli kindly pointed out that there is a Jira already:
https://issues.apache.org/jira/browse/DRILL-3726 and possibly a duplicate of: https://issues.apache.org/jira/browse/DRILL-3149 Regards, Uwe Uwe Geercken Swissport International Ltd. Station Zurich Phone +41 43 81 50359 Mobile +41786954707 From: Rahul Raj [mailto:[email protected]] Sent: Donnerstag, 3. Dezember 2015 06:39 To: [email protected] Subject: CSV(MS Excel created) - error while casting last column to Integer Hi, When querying a CSV created with MS Excel, Drill 1.2 throws number format exception while casting the last column as integer. No issues with any other integer columns.Once saved as a unix file, the query works fine. Seems to a the line separator issue. Is it possible to get a more descriptive error message that includes the line number as well? Currently only the erroneous value is printed out. Not sure if it is possible as fragments are processed in parallel. File & query below. select columns[0] as `Col1`, columns[1] as `Col2`, CAST(columns[2] as INTEGER) as `Col3` from dfs.xx.`sample/data/*.csv` Regards, Rahul *** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. If you are not the named addressee then you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and delete this e-mail from your system.***
