This is an old revision of the document!


TPC-DS Benchmark How To Guide

Commands:

Create Oracle user tpcds

SQL> create user tpcds with password 'ffgfh';

Generate load data

  • mkdir /tmp/tpc
  • dsdgen -scale 1 -dir /tmp/tpc

Load data

  • su - oracle
  • mkdir tpcds

Create control file:

  • vi web_site.ctl
load data
infile '/tmp/tpc/web_site.dat'
into table web_site
fields terminated by '|'
( WEB_SITE_SK, WEB_SITE_ID, WEB_REC_START_DATE date "YYYY-MM-DD", WEB_REC_END_DATE date "YYYY-MM-DD", WEB_NAME, WE
B_OPEN_DATE_SK, WEB_CLOSE_DATE_SK, WEB_CLASS, WEB_MANAGER, WEB_MKT_ID, WEB_MKT_CLASS, WEB_MKT_DESC, WEB_MARKET_MAN
AGER, WEB_COMPANY_ID, WEB_COMPANY_NAME, WEB_STREET_NUMBER, WEB_STREET_NAME, WEB_STREET_TYPE, WEB_SUITE_NUMBER, WEB
_CITY, WEB_COUNTY, WEB_STATE, WEB_ZIP, WEB_COUNTRY, WEB_GMT_OFFSET, WEB_TAX_PERCENTAGE )

Import the data using Oracle Loader

  • sqlldr tpcds/tpcds_1234 control=web_site.ctl
/var/www/wiki.inf.unibz.it/data/attic/public/tpc-ds_benchmark.1355498710.txt.gz · Last modified: 2019/01/16 10:03 (external edit)
CC Attribution-Share Alike 4.0 International
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0