{"id":1914,"date":"2012-12-13T19:23:46","date_gmt":"2012-12-14T00:23:46","guid":{"rendered":"http:\/\/hstore.cs.brown.edu\/?page_id=1914"},"modified":"2013-01-05T15:44:46","modified_gmt":"2013-01-05T20:44:46","slug":"loadmultipartitiontable","status":"publish","type":"page","link":"https:\/\/hstore.cs.brown.edu\/documentation\/system-procedures\/loadmultipartitiontable\/","title":{"rendered":"@LoadMultipartitionTable"},"content":{"rendered":"

\u00ab<\/B> @SetConfiguration<\/a><\/div>
@MarkovUpdate<\/a> \u00bb<\/B><\/div>
<\/div><\/p>\n

@LoadMultipartitionTable<\/h2>\n

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.<\/p>\n

Input Parameters<\/h3>\n\n\n\n\n
Name<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
TABLE_NAME<\/td>\nString<\/td>\nThe name of the table to load data into.<\/td>\n<\/tr>\n
TABLE_CONTENTS<\/td>\nVoltTable<\/td>\nThe VoltTable instance to load into TABLE_NAME<\/tt>.<\/td>\n<\/tr>\n<\/table>\n

\nReturn Values<\/h3>\n

The number of tuples that were inserted in the database.<\/p>\n

Java Example<\/h3>\n\n
Client client =<\/span> ClientFactory.createClient<\/span>(<\/span>)<\/span>;<\/span>\nclient =<\/span> client.createConnection<\/span>(<\/span>hostname, port)<\/span>;<\/span>\nString<\/span> tableName =<\/span> "WAREHOUSE"<\/span>;<\/span>\nVoltTable tableContents =<\/span> new<\/span> VoltTable(<\/span>...)<\/span>;<\/span> \/\/ See additional documentation<\/span>\nClientResponse cresponse =<\/span> client.callProcedure<\/span>(<\/span>"@LoadMultipartitionTable"<\/span>, tableName, tableContents)<\/span>;<\/span><\/pre><\/td><\/tr><\/table><\/div>\n\n
Command-Line Example<\/h3>\n
Not supported at this time<\/em><\/p>\n
\u00ab<\/B> @SetConfiguration<\/a><\/div> 
@MarkovUpdate<\/a> \u00bb<\/B><\/div>
<\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
@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. […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":1891,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/1914"}],"collection":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/comments?post=1914"}],"version-history":[{"count":9,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/1914\/revisions"}],"predecessor-version":[{"id":2040,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/1914\/revisions\/2040"}],"up":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/1891"}],"wp:attachment":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/media?parent=1914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}