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
c1 CATEGORY
c2 LONG
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
