Step 5: Loading Data
Now that you have created the schemas and tables, you can load data into a table by running the vmart_load_data.sql
script. This script loads data from the 15 .tbl
text files in opt/vertica/examples/VMart_Schema
into the tables that vmart_design_schema.sql
created.
It might take several minutes to load the data on a typical hardware cluster. Check the load status by monitoring the vertica.log
file, as described in Monitoring Log Files in the Administrator’s Guide.
VMart=> \i vmart_load_data.sql Rows Loaded ------------- 1826
(1 row)
Rows Loaded ------------- 60000 (1 row)
Rows Loaded ------------- 250 (1 row)
Rows Loaded ------------- 1000 (1 row)
Rows Loaded ------------- 50 (1 row)
Rows Loaded ------------- 50000 (1 row)
Rows Loaded ------------- 10000 (1 row)
Rows Loaded ------------- 100 (1 row)
Rows Loaded ------------- 100 (1 row)
Rows Loaded ------------- 1000
(1 row)
Rows Loaded ------------- 200 (1 row)
Rows Loaded ------------- 5000000 (1 row)
Rows Loaded ------------- 300000 (1 row)
VMart=>