Hi, Petr, Thanks for the report. It is a little problem hiding pretty deep in the software. Please give SVN Revision 752 a try when you get the chance.
John On 9/25/14 4:00 AM, Petr Velan wrote: > Hi John, > > here is a simple test case. The attachment contains just a few rows of > data, following selects are performed using the ibis tool shipped > together with FastBit library (using rev 745). > > Does not work: > SELECT e0id152, (e0id153 - e0id152) as td, e0id4, e0id7, e0id11, > e0id6, e0id5, e0id2, e0id1, (e0id1 / (e0id153 - e0id152)) as bps, > (e0id1 / e0id2) as bpp FROM M2E > > Works: > SELECT (e0id1 / e0id2) as bpp, (e0id1 / (e0id153 - e0id152)) as bps, > e0id152, (e0id153 - e0id152) as td, e0id4, e0id7, e0id11, e0id6, > e0id5, e0id2, e0id1 FROM M2E > > > I hope that helps. > > Petr > > On Tue, Sep 23, 2014 at 12:25 PM, K. John Wu <[email protected] > <mailto:[email protected]>> wrote: > > Hi, Petr, > > Looks like you are using FastBit correctly, we must have something > wrong in handling the column names as you suspected. > > Sounds like you have a test program to reproduce this issue. If you > can share the test program, it would make the debugging work a little > easier for us. > > Thanks. > > John > > > On 9/18/14 1:23 AM, Petr Velan wrote: > > Hi John, > > > > we run into select columns ordering issue while using fastbit. > We are > > currently running revision 745. Here is the description of the > problem: > > > > Using ibis tool in interactive mode: > > ibis -i > > load the part > > > > append 257 > > print parts > > > > Name(s) of all data partitioins > > M35323568 > > > > Do select, which fails: > > > > SELECT e0id152, (e0id153 - e0id152) as td, e0id4, e0id8, e0id7, > > e0id12, e0id11, e0id7, e0id11, e0id6, e0id5, e0id2, (e0id1 / > > (e0id153 - e0id152)) as bps, e0id1 FROM M35323568 > > > > tableSelect:: select(e0id152, (e0id153 - e0id152) as td, e0id4, > e0id8, > > e0id7, e0id12, e0id11, e0id7, e0id11, e0id6, e0id5, e0id2, (e0id1 / > > (e0id153 - e0id152)) as bps, e0id1, 1=1) failed on table T-M35323568 > > > > Just by moving second to last column to front, the query works: > > > > SELECT (e0id1 / (e0id153 - e0id152)) as bps, e0id152, (e0id153 - > > e0id152) as td, e0id4, e0id8, e0id7, e0id12, e0id11, e0id7, > > e0id11, e0id6, e0id5, e0id2, e0id1 FROM M35323568 > > > > tableSelect -- select((e0id1 / (e0id153 - e0id152)) as bps, e0id152, > > (e0id153 - e0id152) as td, e0id4, e0id8, e0id7, e0id12, e0id11, > e0id7, > > e0id11, e0id6, e0id5, e0id2, e0id1, 1=1) on table T-M35323568 > produced > > a table with 76 rows and 12 columns > > tableSelect -- the first row (of 76) from the result table for > "SELECT > > (e0id1 / (e0id153 - e0id152)) as bps, e0id152, (e0id153 - > e0id152) as > > td, e0id4, e0id8, e0id7, e0id12, e0id11, e0id7, e0id11, e0id6, > e0id5, > > e0id2, e0id1 FROM T-M35323568 WHERE 1=1" > > 3.34857142857143, 1408440725886, 175, 6, 2481262304, 40733, > > 2481259049, 5222, 40733, 5222, 24, 0 > > > > Removing some of the columns without reordering the positions, the > > query works: > > > > SELECT e0id152, (e0id153 - e0id152) as td, (e0id1 / (e0id153 - > > e0id152)) as bps, e0id1 FROM M35323568 > > > > tableSelect -- select(e0id152, (e0id153 - e0id152) as td, (e0id1 / > > (e0id153 - e0id152)) as bps, e0id1, 1=1) on table T-M35323568 > produced > > a table with 76 rows and 4 columns > > tableSelect -- the first row (of 76) from the result table for > "SELECT > > e0id152, (e0id153 - e0id152) as td, (e0id1 / (e0id153 - e0id152)) as > > bps, e0id1 FROM T-M35323568 WHERE 1=1" > > 1408440725886, 175, 3.34857142857143, 586 > > > > Are we misusing it somehow, or is it a bug? > > > > Thanks, > > Petr > > > > > > _______________________________________________ > > FastBit-users mailing list > > [email protected] <mailto:[email protected]> > > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users > > > _______________________________________________ > FastBit-users mailing list > [email protected] <mailto:[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
