Changes between Initial Version and Version 4 of Ticket #794


Ignore:
Timestamp:
Mar 8, 2016, 11:06:43 AM (8 years ago)
Author:
Bang Pham Huu
Comment:

Merge with #1261 and add information with Petascope error when execute Rasql with complex number.

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #794

    • Property Owner changed from Veranika Liaukevich to George Merticariu
    • Property Status newassigned
    • Property Milestone 9.0.x10.0
  • Ticket #794 – Description

    initial v4  
    1111  as RasCollectionType is not supported yet.
    1212}}}
     13
     14'''
     15Another information
     16'''
     17
     18When WCPS 1.5 translates this WCPS query
     19
     20
     21{{{
     22for c in (mr) return (2,3)
     23}}}
     24
     25to Rasql
     26
     27{{{
     28SELECT complex(2, 3) FROM mr AS c
     29}}}
     30
     31when Petascope execute this query, it throws exception
     32
     33
     34{{{
     35Caused by: rasj.RasTypeNotSupportedException: Exception: Base type typeName:
     36 typeID:  0
     37  as RasCollectionType is not supported yet.
     38        at org.rasdaman.rasnet.communication.RasRasnetImplementation.getResponse(RasRasnetImplementation.java:711)
     39        at org.rasdaman.rasnet.communication.RasRasnetImplementation.queryRequest(RasRasnetImplementation.java:400)
     40        at rasj.odmg.RasOQLQuery.execute(RasOQLQuery.java:254)
     41        at petascope.util.ras.RasUtil.executeRasqlQuery(RasUtil.java:151)
     42}}}
     43
     44
     45However, this Rasql query can be executed normally in Rasql
     46
     47
     48{{{
     49rasql -q 'SELECT complex(2, 3) FROM mr AS c' --out string
     50rasql: rasdaman query tool v1.0, rasdaman v9.2.0-beta1-gf79e291 -- generated on 21.01.2016 14:39:26.
     51opening database RASBASE at localhost:7001...ok
     52Executing retrieval query...ok
     53Query result collection has 1 element(s):
     54  Result element 1: (2,3)
     55
     56}}}
     57
     58It works if encode complex number inside "encode( )" operator, here is example:
     59
     60
     61{{{
     62http://localhost:8088/rasdaman/ows?service=WCS&version=2.0.1&request=ProcessCoverages&query=
     63for c in (mr) return encode(coverage complexNumber
     64over $x x (0:1),$y y (0:1) values
     65condense over $x x (0:1),$y y (0:1)
     66using (0.1, 0.1),"csv")&wcpsVersion=2.0
     67}}}
     68
     69which returns Rasql
     70
     71
     72{{{
     73SELECT encode(
     74MARRAY x in [0:1,209:210] VALUES
     75CONDENSE +
     76OVER x in [0:1,209:210]
     77USING complex(0.1, 0.1), "csv" )
     78FROM mr AS c
     79}}}
     80
     81and result
     82
     83
     84{{{
     85{(0.4, 0.4),(0.4, 0.4)},{(0.4, 0.4),(0.4, 0.4)}
     86}}}
     87
     88
     89
     90