benchmarking
Moderator: NorbertKrupa
Re: benchmarking
I don't know how to use dbadmin! Can you explain it please?
Re: benchmarking
I've installed vertica by rpm without parameters, so I don't have dbadmin! How I can create it now?
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: benchmarking
Use vsql... It's the command line editor for Vertica.
Please refer to the online programmer's guide here (starting at page 278):
https://my.vertica.com/docs/7.0.x/PDF/H ... _Guide.pdf
Please refer to the online programmer's guide here (starting at page 278):
https://my.vertica.com/docs/7.0.x/PDF/H ... _Guide.pdf
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
ok, done!
I have another problem: the dss consists of 8 tables: nation, region, part, supplier, partsupp, customer, orders, lineitem, but ssb generate data only for these tables:
(customer.tbl)
dbgen -s 1 -T c
(part.tbl)
dbgen -s 1 -T p
(supplier.tbl)
dbgen -s 1 -T s
(date.tbl)
dbgen -s 1 -T d
(fact table lineorder.tbl)
dbgen -s 1 -T l
why?
if i use dbgen -s 1-T a, who creates data for all tables, i have segmentation error(core dumped) and creates only those tables!
I have another problem: the dss consists of 8 tables: nation, region, part, supplier, partsupp, customer, orders, lineitem, but ssb generate data only for these tables:
(customer.tbl)
dbgen -s 1 -T c
(part.tbl)
dbgen -s 1 -T p
(supplier.tbl)
dbgen -s 1 -T s
(date.tbl)
dbgen -s 1 -T d
(fact table lineorder.tbl)
dbgen -s 1 -T l
why?
if i use dbgen -s 1-T a, who creates data for all tables, i have segmentation error(core dumped) and creates only those tables!
Re: benchmarking
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Fri May 08, 2015 9:19 pm, edited 1 time in total.
Re: benchmarking
sorry, I didn't see it.sKwa wrote:Hi!
>>I have another problem: the dss consists of 8 tables: nation, region, part, supplier, partsupp, customer, orders, lineitem, but ssb generate data only for these tables:
>>...why?
Just because.
PS
If you are asking a help and we provide you an info, so read it.
I gave you links to explanation of SSB. Why you don't read it?
(I don't know English too, so it isn't a reason for you do not read)
http://www.cs.umb.edu/~xuedchen/researc ... chemaB.PDF1.Create SSB LINEORDER Table.
We combine the LINEITEM and ORDER table in SSB to make a LINEORDER table. This denormalization is standard in data warehousing (see [KIMBALL02], page 121), and makes many joins unnecessary in common queries. Look at Appendix A for a reasonably detailed explanation of the columns in LINEORDER and all other SSB tables. We discuss these issues further below.
So, i have to create schema in vertica following SSB Column Definition in appendix a, its' right?
Re: benchmarking
Hi!
I've completed the load test, now I must do the performance test!
In the ssbm readme I've read that I can't use qgen, but here: http://www.cs.umb.edu/~poneil/StarSchemaB.PDF there are some queries I can use.
Now, to run these queries I must run them manually in Vertica, it's right?
I've completed the load test, now I must do the performance test!
In the ssbm readme I've read that I can't use qgen, but here: http://www.cs.umb.edu/~poneil/StarSchemaB.PDF there are some queries I can use.
Now, to run these queries I must run them manually in Vertica, it's right?