Can't populate VMart Database!

Moderator: NorbertKrupa

User avatar
usli06
Intermediate
Intermediate
Posts: 93
Joined: Wed Jan 25, 2012 4:53 am

Can't populate VMart Database!

Post by usli06 » Thu Mar 05, 2015 9:08 pm

Hi guys!

I am trying to set up the VMart sample database provided by Vertica. I am using Vertica 7.1.1. I know I did this okay back with 6.1.x.

So I created the DB and the schema. Then I ran the vmart_gen program:

Code: Select all

[dbadmin@vertica01 VMart_Schema]$ ./vmart_gen
Using default parameters
datadirectory = ./
numfiles = 1
seed = 20177
null = ''
timefile = Time.txt
numfactsalesrows = 5000000
numfactorderrows = 300000
numprodkeys = 60000
numstorekeys = 250
numpromokeys = 1000
numvendkeys = 50
numcustkeys = 50000
numempkeys = 10000
numwarehousekeys = 100
numshippingkeys = 100
numonlinepagekeys = 1000
numcallcenterkeys = 200
numfactonlinesalesrows = 5000000
numinventoryfactrows = 300000
gen_load_script = false
Data Generated successfully !
It says it finished successfully, however, none of the tables have data:

Code: Select all

[dbadmin@vertica01 VMart_Schema]$ vsql -c "select count(*) from public.inventory_fact;"
 count
-------
     0
(1 row)

[dbadmin@vertica01 VMart_Schema]$ vsql -c "select count(*) from store.store_sales_fact;"
 count
-------
     0
(1 row)

[dbadmin@vertica01 VMart_Schema]$ vsql -c "select count(*) from store.store_orders_fact;"
 count
-------
     0
(1 row)

[dbadmin@vertica01 VMart_Schema]$ vsql -c "select count(*) from online_sales.online_sales_fact;"
 count
-------
     0
(1 row)
Anyone know what I am doing wrong?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1775
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Can't populate VMart Database!

Post by JimKnicely » Fri Mar 06, 2015 1:03 pm

The /opt/vertica/examples/VMart_Schema/vmart_gen program generates data files that you need to load. To load the data, run the /opt/vertica/examples/VMart_Schema/vmart_load_data.sql script.
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

User avatar
usli06
Intermediate
Intermediate
Posts: 93
Joined: Wed Jan 25, 2012 4:53 am

Re: Can't populate VMart Database!

Post by usli06 » Mon Mar 09, 2015 2:28 pm

Oh my. Thanks, Jim. I feel stupid :roll: I forgot that step...

slahaie1
Newbie
Newbie
Posts: 3
Joined: Thu Dec 10, 2015 8:37 pm

Re: Can't populate VMart Database!

Post by slahaie1 » Thu Dec 10, 2015 8:42 pm

Afternoon,
Having a similar issue but getting an error when attempting to load the db with the following error. Seems to elude that the file is not found. I am new to vertica and Linux.

Any help would be appreciated.
thanks.

VMart-> \i /opt/vertica/examples/VMart_Schema/vmart_load_data.sql
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:4: ERROR 2886: Could not open file [/opt/Date_Dimension.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:7: ERROR 2886: Could not open file [/opt/Product_Dimension.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:10: ERROR 2886: Could not open file [/opt/Store_Dimension.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:13: ERROR 2886: Could not open file [/opt/Promotion_Dimension.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:16: ERROR 2886: Could not open file [/opt/Vendor_Dimension.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:19: ERROR 2886: Could not open file [/opt/Customer_Dimension.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:22: ERROR 2886: Could not open file [/opt/Employee_Dimension.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:25: ERROR 2886: Could not open file [/opt/Warehouse_Dimension.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:28: ERROR 2886: Could not open file [/opt/Shipping_Dimension.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:31: ERROR 2886: Could not open file [/opt/Online_Page_Dimension.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:34: ERROR 2886: Could not open file [/opt/Call_Center_Dimension.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:37: ERROR 2886: Could not open file [/opt/Store_Sales_Fact.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:40: ERROR 2886: Could not open file [/opt/Store_Orders_Fact.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:43: ERROR 2886: Could not open file [/opt/Online_Sales_Fact.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file
vsql:/opt/vertica/examples/VMart_Schema/vmart_load_data.sql:46: ERROR 2886: Could not open file [/opt/Inventory_Fact.tbl] for reading; No such file or directory
HINT: Make sure the file is available on the specified node. If using ON ANY NODE, it must be available at this path on all nodes in the cluster since any node could load the file

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Can't populate VMart Database!

Post by NorbertKrupa » Fri Dec 11, 2015 4:17 am

I would try to regenerate the sample files. See the documentation for steps.
Checkout vertica.tips for more Vertica resources.

slahaie1
Newbie
Newbie
Posts: 3
Joined: Thu Dec 10, 2015 8:37 pm

Re: Can't populate VMart Database!

Post by slahaie1 » Fri Dec 11, 2015 8:05 pm

executing g++ vmart_gen.cpp -o vmart_gen I am getting "bash: g++: command not found..."
How can I get around this?

thanks.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1775
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Can't populate VMart Database!

Post by JimKnicely » Sat Dec 12, 2015 12:34 pm

You need to install g++. Doing so depends on which Linux distro. you are using. For example, on RedHat and CentOS the following command should work:

yum install gcc-c++
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica Database Administration”