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.
Other Vertica Example Database
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Other Vertica Example Database
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.
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.
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Other Vertica Example Database
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
I was hoping to have sample data too, but it looks like I'll have to generate my own
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Other Vertica Example Database
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Other Vertica Example Database
#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..
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..