Hello guys,
I have to do a comparison between Vertica and Monetdb for university...Can I use TPC-H for Vertica? I know that I can use it for Monetdb...
I'm totally noob for this world
benchmarking
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: benchmarking
Hi,
I think you should be able to use TPC-H just fine with Vertica. It supports a subset of ANSI SQL-99.
See:
https://my.vertica.com/docs/6.1.x/HTML/ ... 1596_1.htm
There may be some oddball incompatibilities you might run into, but there should be easy work rounds.
See:
https://my.vertica.com/docs/6.1.x/HTML/ ... #15398.htm
I'd be interested in seeing your test results! Vertica has a lot of its roots in PostgreSQL and it doesn't fair to well with TPC-H
http://wiki.postgresql.org/wiki/TPC-H
I think you should be able to use TPC-H just fine with Vertica. It supports a subset of ANSI SQL-99.
See:
https://my.vertica.com/docs/6.1.x/HTML/ ... 1596_1.htm
There may be some oddball incompatibilities you might run into, but there should be easy work rounds.
See:
https://my.vertica.com/docs/6.1.x/HTML/ ... #15398.htm
I'd be interested in seeing your test results! Vertica has a lot of its roots in PostgreSQL and it doesn't fair to well with TPC-H
http://wiki.postgresql.org/wiki/TPC-H
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: benchmarking
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Sat May 09, 2015 3:10 pm, edited 1 time in total.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: benchmarking
Heh heh, I never said you'd get "shiny" results from a TPC-H benchmark of Vertica... but I think you can still run one
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: benchmarking
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Sat May 09, 2015 3:09 pm, edited 1 time in total.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: benchmarking
Did I recommend it? Nope. I said it'll run. Sheesh...
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: benchmarking
Thanks guys, I've downloaded ssb-dbgen from the first topic linked by sKwa...How I can use it now? Can I use it for Monetdb too?
Excuse me but I'm a newbie also for Linux, I've installed Fedora only for using Vertica..I need simple explanations..
Excuse me but I'm a newbie also for Linux, I've installed Fedora only for using Vertica..I need simple explanations..