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 FROM nation,region where 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 FROM 1 data partition WHERE region ...) -- processing data partition region countQuery::evaluate -- Select count(*) From region Where region.name == "AFRICA" --> 1 countQuery::evaluate -- duration: 0.001 sec(CPU), 0.000271094 sec(elapsed) Warning -- filter::sift2(SELECT nation.name FROM 1 data partition WHERE region ...) failed to append 1 row from region, ierr = -13 Warning -- doQuaere(SELECT nation.name FROM nation,region WHERE 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
