Hello, When FastBit is asked to use descending sort on an aggregation column with 1 distinct value it attempts to sort by all columns and in doing so breaks the row ordering. Here's an example input CSV:
11,43,0 11,43,1 13,43,0 13,43,1 17,43,0 17,43,1 19,43,1 19,97,1 Load: `ardea -d test -m "a:int,b:int,c:int" -t test.csv` Query: `ibis -d test -q "select a, b, sum(c) as s from test where 1=1 order by s desc limit 1000"` 19, 43, 1 19, 43, 1 17, 43, 1 13, 43, 1 11, 97, 1 Thanks, Will
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
