so i was to trace the first issue to dos line endings. once i had convert the file to unix endings the first question gets resolved. the second is still a problem. On Jan 9, 2013, at 11:54 PM, Stanislav Seltser <[email protected]> wrote:
> Question 1. ardea parsing > i have the following small dataset that i store in file data1.csv > x,y,color > 0.652,673.114,blue > 0.255,797.098,green > 0.541,173.007,green > 0.231,168.145,red > 0.233,34.526,red > 0.219,34.526,red > 0.722,520.938,blue > 0.541,438.962,green > 0.381,797.098,green > > i run the following command on it to build index directory > ardea -b "," -d test2 -b "," -t data1.csv -m x:float,y:float,color:key > > > ardea -d "test2" -v 0 > Will attempt to parse 1 CSV file > data1.csv > with the following column names and types > x:float,y:float,color:key > > > ardea to read CSV file data1.csv ... > ardea read 9 rows from data1.csv > > now i run ibis query tool > ibis -d test2 -q "select color" > > "blu" > "gree" > "re" > > what happen to last character?? > > Question #2 > why the exact match query does not work?? > ibis -d test2 -q "select color where x=0.652" > > doQuaere -- "SELECT color WHERE x=0.652" produced a table with 0 row and 0 > column > doQuaere -- the result table (0 x 0) for "SELECT color WHERE x=0.652" > > but the range query works just fine > ibis -d test2 -q "select x,color where x <0.66 and x>0.65" > > doQuaere -- "SELECT x,color WHERE x <0.66 and x>0.65" produced a table with > 12 rows and 2 columns > doQuaere -- the first row (of 12) from the result table for "SELECT x,color > WHERE x <0.66 and x>0.65" > 0.652, "blu" >
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
