An error happened on executing window() query


#1

Hi all,

When I executed window() queries that is “window(merge(rgb,grid),250,250,avg(red),avg(green),avg(blue))”,

then I got an error “Error Description: Query Processor error. Parametermust be constant with type int64”

Anybody know this reason?

Thank you a lot!


#2

Can you please include a repro including array definition. If we can cut & paste what you put here into a terminal, we can immediately see what’s going on and can help you sooner.


#3

Hi donghui,

I have solved this,

These errors happened when executing MODBASE demo benchmark file rgb_10.sh in /modtools/queries/rgb directory.

the detailed clause is below:

iquery -anq “
store(
thin(
window(
merge(rgb, grid_centers),
$xBlurWindowSize,
$yBlurWindowSize,
avg(red) as red,
avg(green) as green,
avg(blue) as blue
),
$xStart, $xCellsPerTile,
$yStart, $yCellsPerTile
),
rgb_gridded
)”

because Window() function lose 2 arguments in dim_2_low and dim_2_hi position,

I add the parameters to window() to become that:

iquery -anq "
store(
thin(
window(
merge(rgb, grid_centers),
$xBlurWindowSize,
$yBlurWindowSize,

    [color=#FF0000]$xBlurWindowSize,
    $yBlurWindowSize,[/color]

    avg(red) as red,
    avg(green) as green,
    avg(blue) as blue
  ),
  $xStart, $xCellsPerTile,
  $yStart, $yCellsPerTile
),
rgb_gridded

)"

may be I use SCIDB 13.12 to run the source file , but the source file is developed for older SCIDB versions.