Hi, Andrew, We have looked into thula.cpp. The problem with the ordering of the columns in the print out is from the implementation of the function printValues in the file thula.cpp. If you use ibis::table::dump instead, the order of the columns should match their positions in the select clause. We have made this change in thula.cpp, this change should be included in the next release.
John On 10/23/2009 7:14 AM, Andrew Olson wrote: > This problem is happening for me in the example programs too... My > code is a slimmed down version of thula.cpp. See example run below. > I observed that the column names are always sorted in the output. So > for my simple program that always returns the same 3 columns, I just > sort the columns in my select string and expect them to be returned > that way. > > Andrew > > bash-3.2$ thula -d hg18 -s "id,start,end,offset" -w "id=chr1" > thula > Select id,start,end,offset > From T-hg18 > Where -- > id=chr1 > doQuery(id=chr1) evaluated on T-hg18 produced 38 hits out of 511 records > -- begin printing the result table -- > Table (in memory) TTUc6i (SELECT id,start,end,offset FROM hg18 WHERE > id=chr1) contsists of 4 columns and 38 rows > id CATEGORY > start UINT > end UINT > offset UINT > end, id, offset, start > 177417, "chr1", 0, 10000 > 267719, "chr1", 41855, 227417 > 471368, "chr1", 51931, 317719 > 2634220, "chr1", 90344, 521368 > 3845268, "chr1", 618557, 2684220 > 13052998, "chr1", 908819, 3995268 > 13219912, "chr1", 3173252, 13102998 > 13557162, "chr1", 3202481, 13319912 > 17125658, "chr1", 3261794, 13607162 > 29878082, "chr1", 4141418, 17175658 > -- 28 skipped... > -- end printing -- > > On Oct 23, 2009, at 9:57 AM, K. John Wu wrote: > >> Hi, Andrew, >> >> It is our intention to keep the output in the same order as the string >> string. From your question, we assume that we have not been able to >> keep this order. We will examine the code to see what is the problem. >> In the mean time, if you have a simple example for us, it would make >> our life a little easier. >> >> Thanks. >> >> John >> >> >> On 10/22/2009 11:12 AM, Andrew Olson wrote: >>> 1 quick question. >>> Is there a way to fix the order of the columns to match the select >>> string? >>> >>> Andrew >>> _______________________________________________ >>> 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 > > _______________________________________________ > 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
