Documentation > System Stored Procedures > @LoadMultipartitionTable
@LoadMultipartitionTable
Load a VoltTable into the database. The system procedure will automatically split the input VoltTable based on the table’s partitioning column and route rows to the proper node. If the target table is replicated or contains a replicated secondary index, then the system procedure will automatically send copies to each node in the cluster.
Input Parameters
| Name | Type | Description |
|---|---|---|
| TABLE_NAME | String | The name of the table to load data into. |
| TABLE_CONTENTS | VoltTable | The VoltTable instance to load into TABLE_NAME. |
Return Values
The number of tuples that were inserted in the database.
Java Example
Client client = ClientFactory.createClient(); client = client.createConnection(hostname, port); String tableName = "WAREHOUSE"; VoltTable tableContents = new VoltTable(...); // See additional documentation ClientResponse cresponse = client.callProcedure("@LoadMultipartitionTable", tableName, tableContents); |
Command-Line Example
Not supported at this time
