Hi!
[DELETED]
benchmarking
Moderator: NorbertKrupa
Re: benchmarking
Last edited by id10t on Sat May 09, 2015 3:09 pm, edited 1 time in total.
Re: benchmarking
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
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
Re: benchmarking
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Fri May 08, 2015 9:20 pm, edited 1 time in total.
Re: benchmarking
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:
I've installed GCC by yum install gcc
If I write gcc and not GCC I have those errors:
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
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
Re: benchmarking
maybe I've finally solved this problem...I've added this to tcpd.h
my output now is:
It's right?
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
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
Re: benchmarking
How I can create a schema in Vertica?
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: benchmarking
With the CREATE SCHEMA command...
Example:
Example:
Code: Select all
dbadmin=> CREATE SCHEMA jim;
CREATE SCHEMA
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.