Sent from my HTC
----- Reply message ----- From: "John Wu" <[email protected]> To: "Rock Wang" <[email protected]>, "FastBit Users" <[email protected]> Subject: [FastBit-users] strange avg/sum/min/max result Date: Fri, Jan 27, 2012 17:10 Hi, Rock, Internally, two rows are produced, but only one row is printed to keep the print out short. If you want to get the full list of rows, you can tell ibis to output them to a file (with option -o, e.g., -o output-file-name), or increase the verboseness of the printout (e.g., -v or -v 3). Hope this helps. John On 1/27/12 12:27 AM, Rock Wang wrote: > Hi John, > > I am trying to use function to avg,sum/min/max, with ver 1.2.8, only > one row got back, where I am expecting two rows. Also, do you have > example how to read the result data with avg/sum > > Thanks, > Rock > > > $ ~/apps/bin/ibis -d tmp -q "select a, avg(b), sum(b), min(c), max(c) > where a in (10,20)" > tableSelect -- select(a, avg(b), sum(b), min(c), max(c), a in (10,20)) > on table T-tmp produced a table with 2 rows and 5 columns > tableSelect -- the first row (of 2) from the result table for "SELECT > a, avg(b), sum(b), min(c), max(c) FROM T-tmp WHERE a in (10,20)" > 10, 10, 10, 89, 89 > > 5$ ~/apps/bin/ibis -d tmp -q "select a, avg(b), sum(b), min(c), max(c) > where a in (20,10)" > tableSelect -- select(a, avg(b), sum(b), min(c), max(c), a in (20,10)) > on table T-tmp produced a table with 2 rows and 5 columns > tableSelect -- the first row (of 2) from the result table for "SELECT > a, avg(b), sum(b), min(c), max(c) FROM T-tmp WHERE a in (20,10)" > 10, 10, 10, 89, 89 > > $ ~/apps/bin/ibis -d tmp -q "select a, avg(b), sum(b), min(c), max(c) > where a in (20,30)" > tableSelect -- select(a, avg(b), sum(b), min(c), max(c), a in (20,30)) > on table T-tmp produced a table with 2 rows and 5 columns > tableSelect -- the first row (of 2) from the result table for "SELECT > a, avg(b), sum(b), min(c), max(c) FROM T-tmp WHERE a in (20,30)" > 20, 20, 20, 79, 79 > _______________________________________________ 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
