Forum: Managing VoltDB

Post: load data to tpch

load data to tpch
May 7, 2012
Hello! Is there any way to upload data automatically generated by tpch to voltdb? Or I need to make a program in java to read the data and puts them in the database?

The data is on a .tbl file and in every line is a record where the fields are separated by '|'.

Thanks for your help!
sqlcmd utility a possibility
May 11, 2012
There are a couple of choices: you could write a program that inserts the data in batches (for large datasets this might get you the fastest ingestion). You could also write a SQL script and pass it to the sqlcmd utility (would insert one line at a time, vs. in batches). The bin directory has the sqlcmd utility and you can see the options via "sqlcmd --help"