Hey John, I'm a bit confused as to how NULLs in csv files are treated by ardea. Here is an experiment I just did:
in "nulls.csv": 10,1 20, 30,3 then load the data with ardea: ardea -d tmp/nulls_test -m a:int,b:int -t nulls.csv then query with ibis: ibis.sh -d tmp/nulls_test -q 'SELECT a, b WHERE 1 = 1' -o out.txt cat out.txt 10, 1 30, 3 For some reason the csv row with a NULL in it is ignored by ardea. This is unexpected for me, but I'm wondering if this is working as designed or not. If this is expected behaviour, then I'm wondering how I can specify NULL values when loading data. Thanks, Michael _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
