Hi, Deepa, You are right that the syntax of FastBit is very limited. However, you should be able to give the select statement (minus the semicolon) as a query statement to ibis. Please give it a try and let us know how it goes for you.
John On 5/24/12 6:56 PM, Deepa Sahni wrote: > > Resending with proper subject line > On Thu, May 24, 2012 at 6:49 PM, Deepa Sahni <[email protected] > <mailto:[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 _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
