Hi there,
I'm facing my wonderful first stucking phase...
I'm using the free Vertica image available from Vertica official website and I'm trying to make practise with the product documentation.
After I stopped the other dbs I created and I connected to the new db for test, I'd like to create its schema as said in the guide, before loading all the demo data (until now I've made this process only for the VMart example database).
Here's the matter:
when I enter the vsql, and i try to launch:
vmartdb=> \i vmart_define_schema.sql
it returns that there's "no such file or directory".
Where should that file be placed and why it's not present after the creation of that db?
Thanks in advance!
creating schema
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: creating schema
If you're manually running the example database, have you followed all the steps in the installation guide?
Otherwise, try explicitly defining the path:
Otherwise, try explicitly defining the path:
Code: Select all
\i /opt/vertica/examples/VMart_Schema/vmart_define_schema.sql
Checkout vertica.tips for more Vertica resources.
Re: creating schema
Thanks... yes it was!
I have to put the entire path but it works this way.
Thank you again,
Bye
I have to put the entire path but it works this way.
Thank you again,
Bye