Yes, Please try ibis -d temp -v -q "from temp s, temp t where s.a = 4.9 and s.b = t.c"
Let's know if you have problems with it. John On 5/24/12 8:25 PM, Deepa Sahni wrote: > 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
