Assume the following:
- File to be loaded: 2010MarchSales_data.txt (assume current working directory)
- Number of rows: 1000 rows encoded in text format
- Delimiter: delimited by character "~"
- Password: beehive
- Destination table: sales_fact
- Destination Aster Database: IP address 10.50.25.100
- Username: assume default
- Database: assume default
This is what you would type:
$ ./ncluster_loader -h 10.50.25.100 –w beehive -D "~" sales_fact 2010MarchSales_data.txt
After successful completion, you will see the following output indicating 1000 rows loaded:
1000 tuples were successfully loaded into table customers.