Hi, Matt, The results of a query is an ibis::table object, you can use the function ibis::table::dump to print the results out. Line 3264 in ibis.cpp is an example of how this function is used in doQuaere.
John On 3/27/13 3:35 PM, Matt Bomhoff wrote: > John, > > Thanks for the info, I updated my code to force the doQuaere behavior. Is > there a way to print all output rows to stdout? I experimented with the -v > option but it wasn't clear. > > Thanks, > Matt > > > On Mar 27, 2013, at 11:29 AM, K. John Wu wrote: > >> Hi, Matt, >> >> There is good reason for the difference. The cause is that the >> function doQuery is using the older style output routine while the >> function doQuaere is using a output routine with finer controls. Our >> intention is to switch to use doQuaere in the near term. In the >> short-term if you want to be sure to invoke doQuaere, then make sure >> you have a period in your query string (something very arbitrary;-), >> something like changing 0 to 0.0. >> >> John >> >> >> On 3/27/13 11:04 AM, Matt Bomhoff wrote: >>> Hello, >>> >>> I am wondering why the output format is different for the two queries below >>> that only differ by the 'chr' where clause? Fastbit v1.3.5 is installed. >>> >>> Query1 >>> ====== >>> ibis -d /opt/apache/CoGe/data//experiments/0/0/0/378 -q "select >>> chr,start,stop,strand,value1,value2 where chr like 'NC_006090%' and start > >>> 0 and stop < 99999" >>> >>> "NC_006090.3", 32386, 32412, 1, 0.0332527, 0.0012 >>> "NC_006090.3", 32857, 32913, 1, 0.00270446, 5.4e-12 >>> "NC_006090.3", 68859, 68900, 1, 0.000538718, 0.00096 >>> "NC_006090.3", 69668, 69685, -1, 0.0133321, 0.0059 >>> >>> doQuery:: evaluate(SELECT chr,start,stop,strand,value1,value2 FROM 4 WHERE >>> chr like 'NC_006090%' and start > 0 and stop < 99999) produced 5 hits >>> >>> Query2 >>> ====== >>> ibis -d /opt/apache/CoGe/data//experiments/0/0/0/378 -q "select >>> chr,start,stop,strand,value1,value2 where chr='NC_006090.3' and start > 0 >>> and stop < 99999" >>> >>> doQuaere -- "SELECT chr,start,stop,strand,value1,value2 WHERE >>> chr='NC_006090.3' and start > 0 and stop < 99999" produced a table with 5 >>> rows and 6 columns >>> doQuaere -- the first row (of 5) from the result table for "SELECT >>> chr,start,stop,strand,value1,value2 WHERE chr='NC_006090.3' and start > 0 >>> and stop < 99999" >>> "NC_006090.3", 32386, 32412, 1, 0.0332527017466677, 0.0012 >>> >>> >>> The db was created with ardea -m \"chr:key, start:unsigned long, >>> stop:unsigned long, strand:byte, value1:double, value2:double\" >>> >>> Thanks! >>> Matt >>> _______________________________________________ >>> 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
