Previous Next JavaScript must be enabled to correctly display this content

## 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.