Hi Vishal, This one is an easy one (I think)... All columns in CSV are read as VARCHAR. So if you are trying to convert anything in CSV to a Numeric format, you will first have to CAST it via one of Drill's data conversion functions to the appropriate numeric type. -- C
> On Feb 14, 2020, at 10:44 AM, Vishal Jadhav (BLOOMBERG/ 731 LEX) > <[email protected]> wrote: > > During my select statement on conversion of csv file to parquet file, I get > the NumberFormatException exception, I am running drill in the embedded mode. > Is there a way to find out which csv file or row in that file is causing the > issue? > I checked the logs with trace verbosity, but not able find the 'data' which > has the issue. > > Error: SYSTEM ERROR: NumberFormatException > > Fragment 1:5 > > Please, refer to logs for more information. > > Thanks! > - Vishal >
