Resending with proper subject line On Thu, May 24, 2012 at 6:49 PM, Deepa Sahni <[email protected]> wrote:
> Hi, > > I am trying to run some queries on data I recently loaded into FastBit. > I am using the ibis command line utility to run the queries. > > Say I have a table called temp and columns a,b,c. I am unclear on how to > run the following query. > > SELECT COUNT(*) FROM temp > B1,temp B2 WHERE B1.a = 49 AND > B1.b = B2.c; > > Now in FastBit when I loaded the data for table temp, I have a separate > data partition for columns a, b and c. Since there is no table name as > such, I am not clear on how to use an alias at a table level. Will the > following query in FastBit achieve the same thing? > > examples\ibis -d tmp -q "select COUNT(*) WHERE a = 49 AND b = c" > > Also the documentation on the sql's query syntax for ibis I found on the > FastBit website is very limited. Can someone point me in the direction of a > good resource. > > Thanks in advance, > Deepa >
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
