Hey John, thanks for the response but when you say query do you mean the first one or the second? If you mean the first then what do I specify instead of
>From temp A , temp B since I don't have a table name. Thanks, Deepa Sent from my Windows Phone From: K. John Wu Sent: 5/24/2012 7:49 PM To: FastBit Users Cc: Deepa Sahni Subject: Re: [FastBit-users] ibis : select query with table alias 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
