Unanswered: SPL: Cannot unload to multiple devices when the given query cannot be executed in
In hploader, i am trying to uload to multi device array.
And i tried to make a procedure last.sql used in sql query statement :
but seems the SPL can't work with multi device array.
Query -> select last(cpp_dt_modif) actorid from cust_ppaid_v2 for read only
Convert Reject -> localHPLLog/actor.Urej
Cannot unload to multiple devices when the given query cannot be executed in parallel.
here is the procedures :
drop procedure last;
-- get GMT integer , represent the millesecond from date 01/01/1970
-- when the flag is 1 , take the current datetime integer if the given datetime is null
CREATE PROCEDURE last(d DATETIME YEAR TO SECOND) RETURNING INT8;
DEFINE n INT8;
select (((d - DATETIME(2000-01-01 00:00:00) YEAR TO SECOND)::INTERVAL SECOND(9) TO SECOND || '')::integer + 946684800) *1000 actorid into n fr
om aa ;
How to make the SPL works parrallel? is there any special setting?
i check on document, it was talking about use 'with parrallizable', but this option is only for C external UDRS.