benchmarking

Moderator: NorbertKrupa

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: benchmarking

Post by id10t » Wed Dec 04, 2013 8:18 am

Hi!

[DELETED]
Last edited by id10t on Sat May 09, 2015 3:09 pm, edited 1 time in total.

Nicola
Newbie
Newbie
Posts: 12
Joined: Mon Dec 02, 2013 10:34 pm

Re: benchmarking

Post by Nicola » Thu Dec 12, 2013 7:31 pm

hi!
sorry for delay but i had some problems.
Now, I've installed Community edition server and client v. 6.1.2..I've downloaded ssb-dbgen but I'm not understanding how I can compile it on Fedora!
Can you explain it to me please?
I've found those instructions but i didn't understand:
-- Copy makefile.suite to makefile
-- Edit the makefile to match the name of your C compiler
and to include appropriate compilation options in the CFLAGS
definition
-- make.
also for language, I'm italian
...
i've Installed Ansi C compiler, I went by terminal in ssb-dbgen directory and I wrote "make"...this is the result:

gcc -O -DDBNAME=\"dss\" -DMAC -DDB2 -DSSBM -c -o build.o build.c
In file included from dss.h:48:0,
from build.c:22:
config.h:104:0: warning: "_POSIX_SOURCE" redefined [enabled by default]
#define _POSIX_SOURCE
^
In file included from /usr/include/stdio.h:27:0,
from build.c:4:
/usr/include/features.h:223:0: note: this is the location of the previous definition
# define _POSIX_SOURCE 1
^
gcc -O -DDBNAME=\"dss\" -DMAC -DDB2 -DSSBM -c -o driver.o driver.c
driver.c: In function ‘process_options’:
driver.c:892:35: error: ‘pid_t’ undeclared (first use in this function)
pids = malloc(children * sizeof(pid_t));
^
driver.c:892:35: note: each undeclared identifier is reported only once for each function it appears in
make: *** [driver.o] Errore 1

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: benchmarking

Post by id10t » Fri Dec 13, 2013 11:37 am

Hi!

[DELETED]
Last edited by id10t on Fri May 08, 2015 9:20 pm, edited 1 time in total.

Nicola
Newbie
Newbie
Posts: 12
Joined: Mon Dec 02, 2013 10:34 pm

Re: benchmarking

Post by Nicola » Fri Dec 13, 2013 3:51 pm

maybe i've understood an error...
I've copied makefile.suite contents in makefile and I've changed this:

CC = GCC
DATABASE= VERTICA
MACHINE = LINUX
WORKLOAD = SSBM

but now I get this error:

Code: Select all

[root@localhost ssb-dbgen-master]# make
GCC -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM   -c -o driver.o driver.c
make: GCC: command not found
make: *** [driver.o] Error 127

I've installed GCC by yum install gcc
If I write gcc and not GCC I have those errors:

Code: Select all

[root@localhost ssb-dbgen-master]# make
gcc -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM   -c -o qgen.o qgen.c
qgen.c: In function ‘qsub’:
qgen.c:153:22: error: ‘SET_ROWCOUNT’ undeclared (first use in this function)
         fprintf(ofp, SET_ROWCOUNT, rowcnt);
                      ^
qgen.c:153:22: note: each undeclared identifier is reported only once for each function it appears in
qgen.c:169:45: error: ‘START_TRAN’ undeclared (first use in this function)
                         fprintf(ofp,"%s\n", START_TRAN);
                                             ^
qgen.c:175:38: error: ‘SET_DBASE’ undeclared (first use in this function)
                         fprintf(ofp, SET_DBASE, db_name);
                                      ^
qgen.c:181:45: error: ‘END_TRAN’ undeclared (first use in this function)
                         fprintf(ofp,"%s\n", END_TRAN);
                                             ^
qgen.c:196:54: error: ‘SET_OUTPUT’ undeclared (first use in this function)
                         fprintf(ofp,"%s '%s/%s.%d'", SET_OUTPUT, osuff, 
                                                      ^
qgen.c:213:46: error: ‘GEN_QUERY_PLAN’ undeclared (first use in this function)
                         fprintf(ofp, "%s\n", GEN_QUERY_PLAN);
                                              ^
make: *** [qgen.o] Error 1

Nicola
Newbie
Newbie
Posts: 12
Joined: Mon Dec 02, 2013 10:34 pm

Re: benchmarking

Post by Nicola » Fri Dec 13, 2013 6:43 pm

maybe I've finally solved this problem...I've added this to tcpd.h

Code: Select all

#ifdef VERTICA
#define GEN_QUERY_PLAN  "EXPLAIN"
#define START_TRAN      "BEGIN TRANSACTION"
#define END_TRAN        "END TRANSACTION"
#define SET_OUTPUT      ".SET FORMAT OFF\n.EXPORT REPORT file="
#define SET_ROWCOUNT    ".SET RETCANCEL ON\n.SET RETLIMIT %d\n"
#define SET_DBASE       ".LOGON %s\n"
#endif
my output now is:

Code: Select all

[root@localhost ssb-dbgen-master]# make
gcc -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM   -c -o build.o build.c
gcc -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM   -c -o bm_utils.o bm_utils.c
gcc -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM   -c -o rnd.o rnd.c
gcc -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM   -c -o bcd2.o bcd2.c
gcc -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM   -c -o speed_seed.o speed_seed.c
gcc -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM   -c -o text.o text.c
gcc -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM   -c -o permute.o permute.c
gcc -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM -O -o dbgen build.o driver.o bm_utils.o rnd.o print.o load_stub.o bcd2.o speed_seed.o text.o permute.o -lm
gcc -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM   -c -o qgen.o qgen.c
gcc -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM   -c -o varsub.o varsub.c
gcc -O -DDBNAME=\"dss\" -DLINUX  -DVERTICA -DSSBM -O -o qgen build.o bm_utils.o qgen.o rnd.o varsub.o text.o bcd2.o permute.o speed_seed.o -lm
It's right?

Nicola
Newbie
Newbie
Posts: 12
Joined: Mon Dec 02, 2013 10:34 pm

Re: benchmarking

Post by Nicola » Mon Dec 23, 2013 4:22 pm

How I can create a schema in Vertica?

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

Re: benchmarking

Post by JimKnicely » Mon Dec 23, 2013 5:49 pm

With the CREATE SCHEMA command...

Example:

Code: Select all

dbadmin=> CREATE SCHEMA jim;
CREATE SCHEMA
Jim Knicely

Image

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

Post Reply

Return to “General”