Hi John, I own two data partitions with about 30 milion lines each. Each partition has two columns: col0 of type doublecol1 of type key When I do the query: [r...@localhost ~]# ./ibis -d /tests/index0 -d /tests/index1 -v -o /tests/result.csv -q "select sum(col0), col1 where col1 != ''" I giver an error that is shown at the end. But when I run the following query: [r...@localhost ~]# ./ibis -d /tests/index0 -d /tests/index1 -v -o /tests/result.csv -q "select col1 where col1 != ''" Its run normally:this result: col1 (with counts)"EUROPE ", 6046909"ASIA ", 5970191"AFRICA ", 5965676"MIDDLE EAST ", 5995910"AMERICA ", 6014422col1 (with counts)"EUROPE ", 6029149"ASIA ", 6090108"AMERICA ", 5902212"AFRICA ", 5989584"MIDDLE EAST ", 598205 this is the error: [r...@localhost ~]# ./ibis -d /tests/index0 -d /tests/index1 -v -o /tests/result.csv -q "select sum(col0), col1 where col1 != ''"/opt/fastbit-ibis1.2.1/examples/.libs/lt-ibis: batch mode, log level 1Completed construction of an part named index0 29993108 rows and 2 columnsCompleted construction of an part named index1 29993106 rows and 2 columnsliga -- constructed table T-index0 (a simple list of partitions: index0 and index1) from a list of 2 data partitions, with 2 columns and 59986214 rowstableSelect -- the number of hits is 59986214countQuery::evaluate -- Select count(*) From index0 Where ( ! 0x9aa5f90) --> 29993108 countQuery::evaluate -- duration: 0 sec(CPU), 0.0982819 sec(elapsed)countQuery::evaluate -- Select count(*) >From index1 Where ( ! 0x9aa5f90) --> 29993106 countQuery::evaluate -- duration: 0 sec(CPU), 0.000159979 sec(elapsed)Warning -- table::select absorbed an exception, will return a nil pointer--- Fri Nov 12 15:13:29 2010The number of memory mapped files is 2. (max = 768)file name: /tests/index0/col0storage @ 0x9aa75d0, 0xa9a90000, 1st 32 bits = 0, 1st 64 bits = 4132445800000000file descriptor 3fmap size 239944864base address 0xa9a90000mapped y opened at Fri Nov 12 15:07:06 2010 last used at Fri Nov 12 15:07:06 2010# of bytes 239944864 # of past acc 1 # of active acc 0file name: /tests/index1/col0storage @ 0x42df8a58, 0x9b5bb000, 1st 32 bits = c0000000, 1st 64 bits = 41507d12c0000000file descriptor 4fmap size 239944848base address 0x9b5bb000mapped y opened at Fri Nov 12 15:10:27 2010 last used at Fri Nov 12 15:10:27 2010# of bytes 239944848 # of past acc 1 # of active acc 0Size of all mapped files is 479,889,712The number of files read into memory is 0The total size of all files read into memory is 0Size of all named storages is 479,889,712Size of all unnamed storages is 480The total size of all named and unnamed storages is 479,890,192The prescribed maximum size is 1,568,624,640Number of pages accessed (recorded so far) is 117168 (page size = 4096)tableSelect:: select(sum(col0), col1 , col1 != '') failed on table T-index0/opt/fastbit-ibis1.2.1/examples/.libs/lt-ibis -- total CPU time 81.6956 s, total elapsed time 383.965 s Thanks
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
