It works fine when the numerical values - I tested on a small sample. However, it is not so easy to remove the quotes from only the numerical columns. There are a few dozen CSV files with up to 100 million rows each, and each one is 12-20 columns, a mixture of text and numerical.
On Fri, May 31, 2013 at 2:12 PM, K. John Wu <[email protected]> wrote: > Hi, Mark, > > Would you mind try without quotes on the numerical values? > > If the problem persists, please tell me more about the "mess".. > > John > > > On 5/31/13 11:08 AM, Mark Hansen wrote: > > The CSV files that I need to load have quotes around the values - both > > numeric and text values. When I load using ardea, I get a mess. I > > need quotes on the text columns because there are spaces in the text > > values. > > > > What should I do? > > > > Here is a sample of the CSV data: > > > > "89493","1407","2012-12-14","(not set)","linda > > farrow","33","35","26","166","143","13641","8" > > "89494","1407","2012-12-14","(not set)","linda farrow > > brillen","1","3","0","3","3","0","3" > > "89495","1407","2012-12-14","(not set)","linda farrow > > vintage","1","1","0","1","1","0","1" > > "89496","1407","2012-12-14","(not set)","óculos linda > > farrow","1","1","1","11","8","816","0" > > "89497","1407","2012-12-13","(not set)","(not > > set)","83","98","75","561","420","45517","28" > > "89498","1407","2012-12-13","(not set)","(not > > provided)","36","42","31","219","172","15951","5" > > > > > > -- > > Mark Hansen > > Founder & President > > Digital Brand Mine | 708 3rd Ave | New York, New York 10017 > > office: 212-961-7250 > > cell: 914-924-3398 > > http://digitalbrandmine.com/ | email: [email protected] > > <mailto:[email protected]> > > > > > > _______________________________________________ > > FastBit-users mailing list > > [email protected] > > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users > > > _______________________________________________ > FastBit-users mailing list > [email protected] > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users > -- Mark Hansen Founder & President Digital Brand Mine | 708 3rd Ave | New York, New York 10017 office: 212-961-7250 cell: 914-924-3398 http://digitalbrandmine.com/ | email: [email protected]
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
