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
