Hi Divya, We found a couple of issues in CSV files that would lead to the kind of errors you encountered. These issues will be fixed in the upcoming Drill 1.11 release.
Sharing a sample CSV file will let us check the issue. Even better, voting is open for the 1.11 release. Please go ahead and download it and try your file with that release. Let us know if you still have a problem. Thanks, - Paul > On Jul 26, 2017, at 6:14 AM, Khurram Faraaz <kfar...@mapr.com> wrote: > > Can you please share your CSV file, the SQL query and the version of Drill > that you are on. So someone can take a look and try to reproduce the error > that you are seeing. > > > Thanks, > > Khurram > > ________________________________ > From: Divya Gehlot <divya.htco...@gmail.com> > Sent: Wednesday, July 26, 2017 3:18:08 PM > To: user@drill.apache.org > Subject: regex replace in string > > Hi, > I have a CSV file where column values are > "This is the column,one " > "This is column , two" > column3 > column4 > > When I try to regex_replace it throws error > > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: >> IllegalArgumentException: reallocation size must be non-negative Fragment >> 0:0 > > > How can I read the above columns as one string like This is the column > one > Appreciate the help > > Thanks, > Divyab