creating schema

Moderator: NorbertKrupa

Post Reply
Simo_Bond
Newbie
Newbie
Posts: 3
Joined: Mon Jul 28, 2014 5:01 pm

creating schema

Post by Simo_Bond » Mon Jul 28, 2014 5:14 pm

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!

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

Re: creating schema

Post by NorbertKrupa » Mon Jul 28, 2014 6:38 pm

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
Checkout vertica.tips for more Vertica resources.

Simo_Bond
Newbie
Newbie
Posts: 3
Joined: Mon Jul 28, 2014 5:01 pm

Re: creating schema

Post by Simo_Bond » Mon Sep 08, 2014 3:54 pm

Thanks... yes it was!
I have to put the entire path but it works this way.
Thank you again,
Bye

Post Reply

Return to “New to Vertica”