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
