Hi, Please find attached the sample_data.csv file Pasting the content of the csv file below , in case attachment doesn't reach
> Column1,Column2,Column3,Column4,Column5 > colonedata1,coltwodata1,-35.924476,138.5987123, > colonedata2,coltwodata2,-27.4372536,153.0304583,137 > colonedata3,coltwodata3,-35.2793885,149.1233503,134 > colonedata4,coltwodata4,-33.8724176,151.2067579, > colonedata5,coltwodata5,,, > "This, col6 data",coltwodata6,-33.869732,151.2055553,351 > "This, col7 data yes.",coltwodata7,1.2845045,103.8482739,80 > Chifley,coltwodata5,,, Error : > Query Failed: An Error Occurred > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > IllegalArgumentException: reallocation size must be non-negative Fragment > 0:0 Thanks all for the help. Thanks , Divya On 26 July 2017 at 23:31, Paul Rogers <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> > > Sent: Wednesday, July 26, 2017 3:18:08 PM > > To: [email protected] > > 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 > >
Column1,Column2,Column3,Column4,Column5 colonedata1,coltwodata1,-35.924476,138.5987123, colonedata2,coltwodata2,-27.4372536,153.0304583,137 colonedata3,coltwodata3,-35.2793885,149.1233503,134 colonedata4,coltwodata4,-33.8724176,151.2067579, colonedata5,coltwodata5,,, "This, col6 data",coltwodata6,-33.869732,151.2055553,351 "This, col7 data yes.",coltwodata7,1.2845045,103.8482739,80 Chifley,coltwodata5,,,
