In this example, all the data in the object store identified by the LOCATION is loaded into the database.
The examples and results show a sample river flow data set. To use your own data, replace the table and column names, and authorization object.
- To run NOS-related commands, log on to the database as a user with the required privileges.
- Create and load the table:
CREATE MULTISET TABLE riverflowperm_csv AS ( SELECT site_no, Flow, GageHeight, Precipitation, datetime, GageHeight2 FROM ( LOCATION='YOUR-OBJECT-STORE-URI' AUTHORIZATION=authorization_object ) AS d ) WITH DATA;
See Variable Substitutions for Examples for the credentials and location values for the sample river flow data set.
- Show the number of rows in the table:
SELECT COUNT (*) FROM riverflowperm_csv;
Your result will be similar to the following:
Count(*) ----------- 17058