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
