How to merge the data of 2 VoltTables?
Aug 27, 2015
Hello,
I want to merge the data of 2 VoltDB tables. I am using Java in my Client application.
Here is my scenario:
I have two tables. On every table, I am calling a select statement(Ad-Hoc Query ..Eg : SELECT col1, col2, col3 from Table1 where col4 = ? order by col1 ASC; ) using client.callProcedure() and storing the results in VoltTable objects V1 & V2.
Now, I want to merge the results of both the VoltTable objects v1 & v2.
How can I do that ?I know, in traditional RDBMS it can be done by Joins.
Does Voltdb support Joins? If yes, then how can I use Joins in Voltdb ? Is there any other alternative which fulfills my requirements?
Any help much appreciated!
Regards,
Pavan
I want to merge the data of 2 VoltDB tables. I am using Java in my Client application.
Here is my scenario:
I have two tables. On every table, I am calling a select statement(Ad-Hoc Query ..Eg : SELECT col1, col2, col3 from Table1 where col4 = ? order by col1 ASC; ) using client.callProcedure() and storing the results in VoltTable objects V1 & V2.
Now, I want to merge the results of both the VoltTable objects v1 & v2.
How can I do that ?I know, in traditional RDBMS it can be done by Joins.
Does Voltdb support Joins? If yes, then how can I use Joins in Voltdb ? Is there any other alternative which fulfills my requirements?
Any help much appreciated!
Regards,
Pavan