Hi, Amihay, Thanks for the report. The basic problem is that somewhere a fully-qualified name is required, but not found, there might be an easy fix in your case, please try
-q "select nation.tbl.n_name, region.tbl.name from nation.tbl, region.tbl where regionkey=3" I am a little worried about the fact that your table names have dots '.' in them, I believe that the SQL standard does not permit that -- at least the old standards.. On the FastBit part, we could be more persistent in looking up names and do a better job in recovering from exceptions. If you give us a sample data to reproduce the problem, we can take a look into these issues shortly. John On 3/11/13 6:05 AM, amihay gonen wrote: > HI , > In trying to do some simple join for example , but i can't get it > working : > > but it seems the following : > 1. the query is done before the join . > 2. how can i print join results ? > 3. it seems to return 4 hits , although table has 5 rows answering the > results . > > i've attached bellow that table description (-part.txt) . > > ○ → rlwrap /home/agonen/Code/fastbit-ibis1.3.5/examples/ibis -v -d > /home/agonen/Code/fastbit_col_data/nation.tbl -d > /home/agonen/Code/fastbit_col_data/region.tbl -j nation.tbl > region.tbl regionkey regionkey=3 -q "select n_name,name " > > Constructed a part named nation.tbl > Constructed a part named region.tbl > query[EJx4CK3xpKR----1]::evaluate -- time to compute the 5 hits: 0 > sec(CPU), 8.8037e-05 sec(elapsed). > Error -- bundles::ctor "n_name" is not the name of a column in table > region.tbl > Error -- bundles::ctor received an exception, start cleaning up > Warning -- doQuery(SELECT n_name,name FROM region.tbl) failed to > create the bundle object for output operations > countQuery::evaluate -- Select count(*) From nation.tbl Where > regionkey == 3 --> 4 > countQuery::evaluate -- duration: 0 sec(CPU), 0.00032864 sec(elapsed) > jNatural::count(From nation.tbl Join region.tbl Using(regionkey) Where > ...) -- duration: 0 sec(CPU), 0.000119586 sec(elapsed) > doJoin(From nation.tbl Join region.tbl Using(regionkey) Where > regionkey=3) -- counted 4 hits > doJoin(From nation.tbl Join region.tbl Using(regionkey) Where > regionkey=3) -- duration: 0.001 sec(CPU), 0.000777227 sec(elapsed) > /home/agonen/Code/fastbit-ibis1.3.5/examples/.libs/lt-ibis -- total > CPU time 0.003 s, total elapsed time 0.00331276 s > > nation.tbl > # meta data for data partition nation.tbl written by > ibis::tafel::write on Mon Mar 11 14:56:12 2013 > > BEGIN HEADER > Name = nation.tbl > Description = > /home/agonen/Code/fastbit-ibis1.3.5/examples/.libs/lt-ardea -d > /home/agonen/Code/fastbit_col_data/nation.tbl -m > nationkey:int,n_name:text,regionkey:int,comment:text -t > /home/agonen/Code/rowdata/nation.tbl.csv > Number_of_rows = 25 > Number_of_columns = 4 > Timestamp = 1363006572 > END HEADER > > Begin Column > name = comment > data_type = TEXT > End Column > > Begin Column > name = n_name > data_type = TEXT > End Column > > Begin Column > name = nationkey > data_type = INT > End Column > > Begin Column > name = regionkey > data_type = INT > End Column > > BEGIN HEADER > Name = region.tbl > Description = > /home/agonen/Code/fastbit-ibis1.3.5/examples/.libs/lt-ardea -d > /home/agonen/Code/fastbit_col_data/region.tbl -m > regionkey:int,name:text -t /home/agonen/Code/rowdata/region.tbl.csv > Number_of_rows = 5 > Number_of_columns = 2 > Timestamp = 1363005189 > END HEADER > > Begin Column > name = name > data_type = TEXT > End Column > > Begin Column > name = regionkey > data_type = INT > End Column > > > > _______________________________________________ > 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
