Page 1 of 1

creating schema

Posted: Mon Jul 28, 2014 5:14 pm
by Simo_Bond
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!

Re: creating schema

Posted: Mon Jul 28, 2014 6:38 pm
by NorbertKrupa
If you're manually running the example database, have you followed all the steps in the installation guide?

Otherwise, try explicitly defining the path:

Code: Select all

\i /opt/vertica/examples/VMart_Schema/vmart_define_schema.sql

Re: creating schema

Posted: Mon Sep 08, 2014 3:54 pm
by Simo_Bond
Thanks... yes it was!
I have to put the entire path but it works this way.
Thank you again,
Bye