Hi John, The contents of the CSV file is mentioned in the original mail - it is a toy file with 3 rows and 2 columns:
--Test Data-- $ cat ~/Desktop/tmp.txt a,1 b,2 c,3 cheers, gaurav On Mon, Oct 1, 2012 at 9:12 PM, K. John Wu <[email protected]> wrote: > Hi, Gaurav, > > Would you be willing to share your CSV file? Thanks. > > John > > > On 9/30/12 9:38 PM, Gaurav Agarwal wrote: > > Hi John, > > > > There is a problem with the current SVN trunk - if I try to do a sum > > of long values broken down by a column, there is a segmentation fault. > > If I change the column type to double from long, the query works fine. > > Here are the steps to reproduce it: > > > > --Test Data-- > > $ cat ~/Desktop/tmp.txt > > a,1 > > b,2 > > c,3 > > > > --Import-- > > $ardea -d /tmp/tst -t ~/Desktop/tmp.txt -m "c1:k,c2:l" > > ardea: verbose level 0 > > Will attempt to parse 1 CSV file > > /Users/gaurav/Desktop/tmp.txt > > with the following column names and types > > c1:k,c2:l > > > > > > ardea to read CSV file /Users/gaurav/Desktop/tmp.txt ... > > ardea read 3 rows from /Users/gaurav/Desktop/tmp.txt > > > > --Query-- > > $thula -d /tmp/tst -s "c1,sum(c2)" -w "c1!='foo'" -v 2 > > > > FastBit ibis1.3.2.6 > > Log messages started on Mon Oct 1 10:08:05 2012 > > util::gatherParts -- examining /tmp/tst > > Constructed a part named tst > > activeDir = "/tmp/tst" > > 3 rows and 2 columns > > mensa::addPartition(/tmp/tst) found 1 new data partition > > mensa::addPartition(/tmp/tst) increases the number partitions from 0 > > to 1, the number of rows from 0 to 3, and the number of columns from 0 > > to 2 > > Table (on disk) T-tst (/tmp/tst) consists of 1 partition with 2 > > columns and 3 rows > > c1CATEGORY > > c2LONG > > thula > > Select c1,sum(c2) > > From T-tst > > Where -- > > c1!='foo' > > countQuery::setWhereClause -- add a new where clause "( ! 0x10db022d0)" > > countQuery assigned data partition tst > > countQuery::estimate -- number of hits is 3 > > countQuery::estimate -- duration: 0.00044 sec(CPU), 0.000439882 > > sec(elapsed) > > doQuery(c1!='foo') -- the estimated number of hits on T-tst is 3 > > countQuery::setWhereClause accepted new query conditions "( ! > > 0x10db01640)" > > Constructed in-memory data partition guhXd0 -- filter::sift2(SELECT > > c1,sum(c2) FROM 1 data partition WHERE ( ! 0x ...) -- with 2 columns > > filter::sift2(SELECT c1,sum(c2) FROM 1 data partition WHERE ( ! 0x > > ...) -- processing data partition tst > > countQuery assigned data partition tst > > countQuery::evaluate -- Select count(*) From tst Where ( ! > > 0x10db01640) --> 3 > > countQuery::evaluate -- duration: 7.8e-05 sec(CPU), 7.79629e-05 > > sec(elapsed) > > Mon Oct 1 10:08:05 2012 > > Warning -- column[guhXd0.__1](LONG)::selectDoubles -- incompatible > > data type > > Segmentation fault: 11 > > > > cheers, > > gaurav > > > > > > _______________________________________________ > > 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
