SSDB run_tiny.sh error


#1

Hi, all,

I am running SSDB with SciDB 12.10, only one instance is started on a single host.
Generating and initiation date is running smoothly, and all other queries except Q3 in run_tiny.sh are executed successfully.
The error message is :

UserQueryException in file: src/query/parser/ALTranslator.cpp function: passScalarFunction line: 1521
Error id: scidb::SCIDB_SE_SYNTAX::SCIDB_LE_UNEXPECTED_OPERATOR_IN_EXPRESSION
Error description: Query syntax error. Array operators cannot be used inside scalar expressions.

avg(thin(window(repart(subarray(project(tiny,a),0,0,0,19,9,9),
<a:int32>Z=0:19,1,0,J=0:9,12,0,I=0:9,12,0]),1,4,4,avg(a)),0,1,2,3,2,3))
^^^
It looks like a syntax error, but I checked userguide and cannot found any mistakes.

I am new to SciDB. Can anyone give any suggestion?

Thanks.


#2

It is a syntax error. I modified the query as follows:

iquery -r /dev/null -aq “avg(thin(window(repart(subarray(project(tiny,a),0,0,0,
19,$U1,$U1),<a:int32>[Z=0:19,1,0,J=0:9,12,0,I=0:9,12,0]),0,1,0,4,0,4,avg(a)),0,1
,2,3,2,3))”

It is OK now.
As if SSDB is not updated to the latest SciDB version.


#3

[quote=“liutaoying”]It is a syntax error. I modified the query as follows:

iquery -r /dev/null -aq “avg(thin(window(repart(subarray(project(tiny,a),0,0,0,
19,$U1,$U1),<a:int32>[Z=0:19,1,0,J=0:9,12,0,I=0:9,12,0]),0,1,0,4,0,4,avg(a)),0,1
,2,3,2,3))”

It is OK now.
As if SSDB is not updated to the latest SciDB version.[/quote]

But why do you add three 0 and what does that mean?