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.****
Col1,Col2,Col3 India,data1,1 Us,data2,2 China,data3,3
