load
load -file <path to file>
Load the named file and interpret its contents as a script of commands to be executed. If any command in the script fails execution will end.
For example, suppose the following commands are collected in the script file test.sql
:
### Begin Script ###
load -file test.ddl
import -table users -file users.json
### End Script ###
Where the file test.ddl
would contain content like this:
DROP TABLE IF EXISTS users;
CREATE TABLE users(id INTEGER, firstname STRING, lastname STRING,
age INTEGER, primary key (id));
And the file users.json
would contain content like this:
{"id":1,"firstname":"Dean","lastname":"Morrison","age":51}
{"id":2,"firstname":"Idona","lastname":"Roman","age":36}
{"id":3,"firstname":"Bruno","lastname":"Nunez","age":49}
Then, the script can be run by using the load
command in the shell:
> java -jar KVHOME/lib/sql.jar -helper-hosts node01:5000 \
-store kvstore
sql-> load -file ./test.sql
Statement completed successfully.
Statement completed successfully.
Loaded 3 rows to users.