Other Vertica Example Database

Moderator: NorbertKrupa

Post Reply
mrian
Newbie
Newbie
Posts: 8
Joined: Wed Jul 17, 2013 3:12 am

Other Vertica Example Database

Post by mrian » Wed Oct 16, 2013 11:47 am

Hi Guys,

If we look at the old Vertica (https://my.vertica.com/docs/4.1/HTML/Master/4314.htm) documentation there is mention of other sample database such as Clickstream, Telecom, Retail Sales, etc. I know that we have VMart Schema (example database) available by default. I was wondering if other example databases are also available for download?

Hope someone can help point to the right direction in obtaining those sample scripts.

Thanks.

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

Re: Other Vertica Example Database

Post by JimKnicely » Wed Oct 16, 2013 1:40 pm

Hi,

I think you'll be able to find what you looking for here:

https://my.vertica.com/docs/4.1/HTML/Master/4374.htm

The text for the scripts are there. You may have to create the scripts manually via cut and paste. :roll:
Jim Knicely

Image

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

mrian
Newbie
Newbie
Posts: 8
Joined: Wed Jul 17, 2013 3:12 am

Re: Other Vertica Example Database

Post by mrian » Wed Oct 16, 2013 1:48 pm

Thanks Jim, I'll try to do that.

I was hoping to have sample data too, but it looks like I'll have to generate my own :(

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

Re: Other Vertica Example Database

Post by JimKnicely » Wed Oct 16, 2013 1:54 pm

Maybe you can download the rpm for version 4.1 and install it on a spare Linux box or VM? Then you'll have access to the files and the executable programs that let you generate data for these databases...
Jim Knicely

Image

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

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: Other Vertica Example Database

Post by nnani » Tue Oct 22, 2013 9:46 am

#mrian,

Are you only looking for Clickstream, Telecom, Retail Sales schema for Vertica, If not so, You can try different schema too.
You can find schema for PostgreSQL with generated data. The script should be compatible with Vertica.
Let me know, if you need one.



Hope this helps.. :)
nnani........
Long way to go

You can check out my blogs at vertica-howto

Post Reply

Return to “Vertica Tips, Lessons and Examples”