: ls -l star2002-?.csv -rw-r----- 1 13325 123 671537690 Jul 1 09:51 star2002-1.csv -rw-r----- 1 13325 123 670576063 Jul 1 09:55 star2002-2.csv -rw-r----- 1 13325 123 797333591 Jul 1 10:02 star2002-3.csv : foreach f ( star2002-?.csv ) foreach loop: time ../fastbit-b0.9.6/examples/ardea -d s1 -m "antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float" -t $f foreach loop: end /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea: verbose level 0 Will parse 1 CSV file with the following column names and types antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float 44.077u 4.380s 0:55.27 87.6% 0+0k 0+0io 93pf+0w /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea: verbose level 0 Will parse 1 CSV file with the following column names and types antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float 43.424u 4.445s 0:54.72 87.4% 0+0k 0+0io 15pf+0w /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea: verbose level 0 Will parse 1 CSV file with the following column names and types antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float 51.396u 5.199s 1:03.39 89.2% 0+0k 0+0io 8pf+0w : foreach f ( star2002-?.csv ) foreach loop: echo $f foreach loop: time ../fastbit-b0.9.6/examples/ardea -d s1 -m "antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float" -t $f foreach loop: end star2002-1.csv /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea: verbose level 0 Will parse 1 CSV file with the following column names and types antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float 42.411u 4.406s 0:54.85 85.3% 0+0k 0+0io 94pf+0w star2002-2.csv /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea: verbose level 0 Will parse 1 CSV file with the following column names and types antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float 44.330u 4.272s 0:56.35 86.2% 0+0k 0+0io 8pf+0w star2002-3.csv /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea: verbose level 0 Will parse 1 CSV file with the following column names and types antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float 49.741u 5.089s 1:03.65 86.1% 0+0k 0+0io 5pf+0w : time ../fastbit-b0.9.6/examples/ardea -d s1 -m "antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float" -t star2002-1.csv -t star2002-2.csv -t star2002-3.csv /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea: verbose level 0 Will parse 3 CSV files with the following column names and types antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float 136.351u 11.959s 2:51.12 86.6% 0+0k 0+0io 101pf+0w : time ../fastbit-b0.9.6/examples/ardea -d s1 -m "antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float" -t star2002-1.csv -t star2002-2.csv -t star2002-3.csv -v /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea: verbose level 1 Will parse 3 CSV files with the following column names and types antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea to read CSV file star2002-1.csv ... Completed construction of an ibis::part named s1 (user-supplied data parsed by ardea.cpp) 63430500 rows each with 16 columns ibis::tafel::write completed writing partition s1 (user-supplied data parsed by ardea.cpp) with 16 columns and 5000000 rows (total 68430500) to s1 using 1.9587 sec(CPU) and 5.53138 sec(elapsed) /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea to read CSV file star2002-2.csv ... Completed construction of an ibis::part named s1 (user-supplied data parsed by ardea.cpp) 68430500 rows each with 16 columns ibis::tafel::write completed writing partition s1 (user-supplied data parsed by ardea.cpp) with 16 columns and 5000000 rows (total 73430500) to s1 using 1.9387 sec(CPU) and 4.77833 sec(elapsed) /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea to read CSV file star2002-3.csv ... Completed construction of an ibis::part named s1 (user-supplied data parsed by ardea.cpp) 73430500 rows each with 16 columns ibis::tafel::write completed writing partition s1 (user-supplied data parsed by ardea.cpp) with 16 columns and 5857625 rows (total 79288125) to s1 using 2.21766 sec(CPU) and 5.78084 sec(elapsed) Completed construction of an ibis::part named s1 (user-supplied data parsed by ardea.cpp) 79288125 rows each with 16 columns ibis::mensa -- constructed table T-s1 (s1) from directory s1. It consists of 1 partition with 16 columns and 79288125 rows -- begin printing table -- Table (on disk) T-s1 (s1) consists of 1 partition with 16 columns and 79288125 rows antiNucleus INT eventFile INT eventNumber INT eventTime DOUBLE histFile INT multiplicity INT NaboveLb INT NbelowLb INT NLb INT primaryTracks INT prodTime DOUBLE Pt FLOAT runNumber INT vertexX FLOAT vertexY FLOAT vertexZ FLOAT 1, 1613423, 807, 20011015.2226039954, 1613424, 4518, 0, 0, 654, 1395, 20011204.1149510033, 10.955403, 2288071, -0.28820264, 0.40731233, 10.559091 1, 1613423, 808, 20011015.2226039954, 1613424, 886, 0, 0, 61, 371, 20011204.115313001, 23.326479, 2288071, -0.24732992, 0.45591551, 57.810596 1, 1613423, 809, 20011015.2226039954, 1613424, 638, 0, 0, 7, 121, 20011204.1153550036, 2.4442992, 2288071, -0.39096078, 0.58953387, 167.75714 4, 1613423, 810, 20011015.2226039954, 1613424, 4259, 0, 0, 1024, 1302, 20011204.1154300012, 9.5218678, 2288071, -0.29015437, 0.44602653, 8.6443624 5, 1613423, 811, 20011015.2226039954, 1613424, 3673, 1, 0, 592, 1246, 20011204.1157210022, 13.560424, 2288071, -0.25741839, 0.41968927, 29.02236 3, 1613423, 812, 20011015.2226039954, 1613424, 4707, 0, 0, 655, 1529, 20011204.1159470007, 47.679569, 2288071, -0.22179361, 0.41279319, 6.5899963 1, 1613423, 813, 20011015.2226039954, 1613424, 1115, 0, 0, 27, 384, 20011204.1202500015, 20.839916, 2288071, -0.23799685, 0.46584174, 7.9682536 2, 1613423, 814, 20011015.2226039954, 1613424, 678, 0, 0, 24, 263, 20011204.1203389987, 4.8227081, 2288071, -0.20905563, 0.31556332, -89.918007 0, 1613423, 815, 20011015.2226039954, 1613424, 632, 0, 0, 14, 243, 20011204.1204119958, 13.18028, 2288071, -0.30221173, 0.48555049, -3.6457486 3, 1613423, 816, 20011015.2226039954, 1613424, 4364, 1, 0, 692, 1512, 20011204.1204449981, 21.609955, 2288071, -0.26237243, 0.47709364, -5.2208481 ... 79288115 remaining in table T-s1 -- end printing table -- 136.443u 14.106s 2:46.80 90.2% 0+0k 0+0io 1562pf+0w : time ../fastbit-b0.9.6/examples/ardea -d s1 -m "antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float" -t star2002-full.csv -v -c ibis.rc ibis::resource::read -- Reading configuration file "ibis.rc" /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea: verbose level 1 Will parse 1 CSV file with the following column names and types antiNucleus:int, eventFile:int, eventNumber:int, eventTime:double, histFile:int, multiplicity:int, NaboveLb:int, NbelowLb:int, NLb:int, primaryTracks:int, prodTime:double, Pt:float, runNumber:int, vertexX:float, vertexY:float, vertexZ:float /data/kewu/fastbit-b0.9.6/examples/.libs/lt-ardea to read CSV file star2002-full.csv ... Completed construction of an ibis::part named s1 (user-supplied data parsed by ardea.cpp) 79288125 rows each with 16 columns ibis::tafel::write completed writing partition s1 (user-supplied data parsed by ardea.cpp) with 16 columns and 15857625 rows (total 95145750) to s1 using 6.08208 sec(CPU) and 15.0438 sec(elapsed) Completed construction of an ibis::part named s1 (user-supplied data parsed by ardea.cpp) 95145750 rows each with 16 columns ibis::mensa -- constructed table T-s1 (s1) from directory s1. It consists of 1 partition with 16 columns and 95145750 rows -- begin printing table -- Table (on disk) T-s1 (s1) consists of 1 partition with 16 columns and 95145750 rows antiNucleus INT eventFile INT eventNumber INT eventTime DOUBLE histFile INT multiplicity INT NaboveLb INT NbelowLb INT NLb INT primaryTracks INT prodTime DOUBLE Pt FLOAT runNumber INT vertexX FLOAT vertexY FLOAT vertexZ FLOAT 1, 1613423, 807, 20011015.2226039954, 1613424, 4518, 0, 0, 654, 1395, 20011204.1149510033, 10.955403, 2288071, -0.28820264, 0.40731233, 10.559091 1, 1613423, 808, 20011015.2226039954, 1613424, 886, 0, 0, 61, 371, 20011204.115313001, 23.326479, 2288071, -0.24732992, 0.45591551, 57.810596 1, 1613423, 809, 20011015.2226039954, 1613424, 638, 0, 0, 7, 121, 20011204.1153550036, 2.4442992, 2288071, -0.39096078, 0.58953387, 167.75714 4, 1613423, 810, 20011015.2226039954, 1613424, 4259, 0, 0, 1024, 1302, 20011204.1154300012, 9.5218678, 2288071, -0.29015437, 0.44602653, 8.6443624 5, 1613423, 811, 20011015.2226039954, 1613424, 3673, 1, 0, 592, 1246, 20011204.1157210022, 13.560424, 2288071, -0.25741839, 0.41968927, 29.02236 3, 1613423, 812, 20011015.2226039954, 1613424, 4707, 0, 0, 655, 1529, 20011204.1159470007, 47.679569, 2288071, -0.22179361, 0.41279319, 6.5899963 1, 1613423, 813, 20011015.2226039954, 1613424, 1115, 0, 0, 27, 384, 20011204.1202500015, 20.839916, 2288071, -0.23799685, 0.46584174, 7.9682536 2, 1613423, 814, 20011015.2226039954, 1613424, 678, 0, 0, 24, 263, 20011204.1203389987, 4.8227081, 2288071, -0.20905563, 0.31556332, -89.918007 0, 1613423, 815, 20011015.2226039954, 1613424, 632, 0, 0, 14, 243, 20011204.1204119958, 13.18028, 2288071, -0.30221173, 0.48555049, -3.6457486 3, 1613423, 816, 20011015.2226039954, 1613424, 4364, 1, 0, 692, 1512, 20011204.1204449981, 21.609955, 2288071, -0.26237243, 0.47709364, -5.2208481 ... 95145740 remaining in table T-s1 -- end printing table -- 138.929u 18.802s 3:06.70 84.4% 0+0k 0+0io 3142pf+0w : uname -a Linux dmx.lbl.gov 2.6.9-55.0.2.ELsmp #1 SMP Tue Jun 26 14:30:58 EDT 2007 i686 i686 i386 GNU/Linux : date Thu Aug 14 17:27:15 PDT 2008