It worked :) Thank you, Deepa
On Thu, May 24, 2012 at 9:43 PM, K. John Wu <[email protected]> wrote: > 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
