Hi, Amihay, Just looked through the code for the error message, it seems that the function ibis::bord::append was not able to find the matching column name, which causes it to return -13 (printed by the first line of Warning message). If you are able to share the data, I could take a look at the problem in a debugger and see what was the real problem.
John On 3/30/13 3:54 PM, amihay gonen wrote: > Hi , I'm try to do join between two tables , but without success. > any idea , what i'm doing wrong ? > > if i'm doing the following query : > $ibis -v -q "SELECT nation.name <http://nation.name> FROM > nation,region where region.name <http://region.name>='AFRICA' " -o > $outfile -d $db/nation -d $db/region -j nation region regionkey > regionkey=region.regionkey regionkey=nation.regionkey > > i get : > > Constructed a part named nation > Constructed a part named region > filter::sift2(SELECT nation.name <http://nation.name> FROM 1 data > partition WHERE region ...) -- processing data partition region > countQuery::evaluate -- Select count(*) From region Where region.name > <http://region.name> == "AFRICA" --> 1 > countQuery::evaluate -- duration: 0.001 sec(CPU), 0.000271094 sec(elapsed) > Warning -- filter::sift2(SELECT nation.name <http://nation.name> FROM > 1 data partition WHERE region ...) failed to append 1 row from region, > ierr = -13 > Warning -- doQuaere(SELECT nation.name <http://nation.name> FROM > nation,region WHERE region.name <http://region.name>='AFRICA' ) failed > to produce a result table > countQuery::evaluate -- Select count(*) From nation Where regionkey == > region.regionkey --> 25 > countQuery::evaluate -- duration: 0 sec(CPU), 0.000177332 sec(elapsed) > countQuery::evaluate -- Select count(*) From region Where regionkey == > nation.regionkey --> 5 > countQuery::evaluate -- duration: 0 sec(CPU), 9.994e-05 sec(elapsed) > jNatural::count(From nation Join region Using(regionkey) Where ...) -- > duration: 0 sec(CPU), 8.1054e-05 sec(elapsed) > doJoin(From nation Join region Using(regionkey) Where > regionkey=region.regionkey And regionkey=nation.regionkey) -- counted > 25 hits > doJoin(From nation Join region Using(regionkey) Where > regionkey=region.regionkey And regionkey=nation.regionkey) -- > duration: 0 sec(CPU), 0.000648564 sec(elapsed) > > > > _______________________________________________ > 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
