Custom Query (2765 matches)

bug derived by a discussion on rasdaman-users mailing list at ​http://groups.google.com/group/rasdaman-users/browse_thread/thread/54d698e038a98fb9?hl=en

I'm working with the latest rasdaman version available by git.

When I select data from a collection and I try to encode results into a specific file format, the files selected are always saved with the ".unknown" extension instead of the correct file type suffix.

It seems a little problem related only to the file name because the data are encoded correctly.

X Peter and Dimitar, if you want to verify this issue you can use the System provided in Munich by EOX. Also the rasdaman installed on the Key is affected by this problem. I can not verify if the virtual machines provided for the Earth Server project by EOX are OK. Currently i'm working with an own installation of Rasdaman and I don't use the packages prepared by EOX.

Examples:

rasql -q "select tiff(i) from rgb as i" —out file rasql: rasdaman query tool v1.0, rasdaman v8 — generated on 14.10.2011 17:27:00. opening database RASBASE at localhost:7001...ok Executing retrieval query…ok Query result collection has 1 element(s):

Result object 1: going into file rasql_1.unknown…ok.

rasql done.

rasql -q "select png(i) from mr as i" —out file rasql: rasdaman query tool v1.0, rasdaman v8 — generated on 14.10.2011 17:27:00. opening database RASBASE at localhost:7001...ok Executing retrieval query…ok Query result collection has 3 element(s):

Result object 1: going into file rasql_1.unknown…ok. Result object 2: going into file rasql_2.unknown…ok. Result object 3: going into file rasql_3.unknown…ok.

rasql done.

rasql -q "select jpeg(i) from aatsr as i" —out file rasql: rasdaman query tool v1.0, rasdaman v8 — generated on 14.10.2011 17:27:00. opening database RASBASE at localhost:7001...ok Executing retrieval query…ok Query result collection has 8 element(s):

Result object 1: going into file rasql_1.unknown…ok. Result object 2: going into file rasql_2.unknown…ok. Result object 3: going into file rasql_3.unknown…ok. Result object 4: going into file rasql_4.unknown…ok. Result object 5: going into file rasql_5.unknown…ok. Result object 6: going into file rasql_6.unknown…ok. Result object 7: going into file rasql_7.unknown…ok. Result object 8: going into file rasql_8.unknown…ok.

rasql done.

Damiano

Try to load the attached TIFF file using the command below:

rasql -q 'insert into bgs_rs values (RGBPixel) inv_tiff( $1 )' --file bgs_small_ls_test.tif --user rasadmin --passwd ...

I get error:

Executing update query...rasdaman error 300: Parsing error 300 in line 1, column 38: Unexpected name inv_tiff.

and in the log file

Request: 'insert into bgs_rs values (RGBPixel) inv_tiff( #MDD0# )'...parsing...Error: cannot parse query

When I try to insert the attached file into rasdaman the x and y dimensions seem to be swapped.

gdalinfo on data set says

Size is 20, 40

Querying domain after insertion says

Result element 1: [0:39,0:19]

Steps to reproduce:

gdalinfo osdtm_small.netcdf
rasql -q 'create collection os_dtm FloatSet' --user rasadmin --passwd ...
rasql -q 'insert into os_dtm values inv_netcdf($1)' --file osdtm_small.netcdf --user rasadmin --passwd ...
rasql -q 'select sdom(m) from os_dtm as m' --user rasadmin --passwd ... --out string