I got to know a new tip about VoltDB.
When you got Error:
"This query is not plannable. It has a subquery which needs cross-partition access."
on creating procedure, I recommend to try a empty procedure first.
Creating procedure including subquery, I got a error above. My subquery designed to run close in a partition. In the point of creating procedure
it is not yet given partition attribute. Create sacrifice procedure with same name and give column of partition. This is my workaround.