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