How to store the data executed after voltExecuteSQL() in new VoltTable into VoltDB via Java stored procedure?
Oct 22, 2015
Hello All,
I am writing a java stored procedure. In which I have to store the data in the new VoltTable(Physical VoltTable) into the VoltDB executed after the voltExecuteSQL() method. (Well, I know voltExecuteSQL() execute the statements in the queue & returns its results in a VoltTable structure. )
But, VoltDB java stored procedure does not support the "CREATE TABLE" statements inside the stored procedure itself.
So, I want to store the data in the new physical VoltTable into the VoltDB (In short, storing the data into the VoltDB while returning voltExecuteSQL() method)
So, please suggest me how can I do that ?
Thank You!
Best Regards,
Pavan
I am writing a java stored procedure. In which I have to store the data in the new VoltTable(Physical VoltTable) into the VoltDB executed after the voltExecuteSQL() method. (Well, I know voltExecuteSQL() execute the statements in the queue & returns its results in a VoltTable structure. )
But, VoltDB java stored procedure does not support the "CREATE TABLE" statements inside the stored procedure itself.
So, I want to store the data in the new physical VoltTable into the VoltDB (In short, storing the data into the VoltDB while returning voltExecuteSQL() method)
So, please suggest me how can I do that ?
Thank You!
Best Regards,
Pavan