Comments (2)
First off, that isn't a realistic score. I believe you first ran the test with a scale factor of 1 and then re-ran the test with a scale factor of 3000. By default, the variables are set to not regen the data and recreate the tables. If you need to change the scale factor, you need to set RUN_GEN_DATA to "true". After that test run completes, you can change it back to false so that it doesn't recreate the data needed by the test.
I suspect this because 1 User Queries ran in 74 seconds. That is impossible for Greenplum with a size of 3TB of data.
Second, the score is based on the official TPC score calculation but it isn't the same. This test does not perform the update section of TPC-DS. This portion of the test is always skipped for data warehouse products like Greenplum. This score calculation is adjusted for that difference.
The score calculation was developed during my time at Pivotal which is now VMware. To my knowledge, it is still used today.
The score is best used to compare clusters at a macro level. For example, you can run the test in AWS and then in GCP to understand the performance difference between those two environments.
from tpc-ds.
Thank u for the ask. I will rerun the test as you suggested.
from tpc-ds.
Related Issues (20)
- imp option - clarification needed HOT 1
- Creating socket failed during dataload HOT 2
- hawq_rm_nvseg_perquery_perseg_limit clarification HOT 1
- Very poor HDFS throughput HOT 2
- Unable to load more than 50GB data in hdfs through tcpds script HOT 8
- Sharing TPC-DS test results of HAWQ & SparkSQL
- Generate data step hangs HOT 14
- relation "pg_filespace_entry" does not exist HOT 7
- Changes in Postgresql.conf causing to Stop Greenplum HOT 5
- Canceling query because of high VMEM usage. HOT 2
- ERROR: could not open file "../log/rollout_gen_data.log" for reading: No such file or directory HOT 10
- Can not execute tpcds.sh in offline environments HOT 2
- Setting RUN_COMPILE_TPCDS="false" does not disable compiling HOT 2
- 请教问题 HOT 5
- Should 02_init/rollout.sh set search path for ADMIN_USER? HOT 3
- ERROR: http response code 404 from gpfdist HOT 19
- Selected scale factor is NOT valid && Connection timed out HOT 7
- Generating data takes long time HOT 4
- Session report not avaialbe HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tpc-ds.