Bernoulli throws error


#1

I am getting the following error when using bernoulli:

scidb@scidb-controller:~/es_data/scripts$ iquery -o lcsv+
AQL% select * from bernoulli(hrly_temp, 0.00001);
airport,date,hour,value,EmptyTag
840003927,"1988-06-16 00:00:00",5,58,true
840003927,"1989-06-17 00:00:00",5,69,true
840003927,"1990-06-18 00:00:00",5,75,true
UserException in file: src/array/Array.cpp function: getEmptyBitmap line: 613
Error id: scidb::SCIDB_SE_EXECUTION::SCIDB_LE_OPERATION_FAILED
Error description: Error during query execution. Operation 'setPosition' failed.
Failed query id: 1100964438084
AQL% ^Cscidb@scidb-controller:~/es_data/scripts$

#2

Ouch.

  1. Can you give us some more details? The CREATE ARRAY statement? And some idea about the data distribution in the array? (sparse, dense, etc)?

  2. We have a closed / fixed (in 12.10) ticket # 1472 that looks very similar.

#
#  6. The offending query. 
#
iquery -o lsparse -aq "
bernoulli ( Timeseries_Example, 0.99 )
"
#  UserException in file: src/query/ops/bernoulli/PhysicalBernoulli.cpp function: setSamplePosition line: 182
#  Error id: scidb::SCIDB_SE_EXECUTION::SCIDB_LE_NO_CURRENT_ELEMENT
#  Error description: Error during query execution. No current element.
#

The precise error is different. But the underlying cause–bernoulli sampling over an array which is sufficiently sparse that it has empty chunks–I suspect is the same.


#3

I am upgrading to the new version 12.10. Will test and see if the errors is fixed.

Thank you,
Vijay