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
