search

heavyai / heavydb

HeavyDB (formerly OmniSciDB)
https://heavy.ai
Apache License 2.0
2.95k stars 448 forks source link

TPC-H Benchmark on omniscidb #605

Open Eilowangfang opened 3 years ago

Eilowangfang commented 3 years ago

Hi. I' a new user for omniscidb. My target is to test TPC-H benchmark on omniscidb.

Currently, I startup the omniscidb and pass the simple test of "flights_2008_10k" successfully. Then I turned to the provided benchmarks test: https://github.com/omnisci/omniscidb/tree/master/Benchmarks. I have run "Synthetic benchmark queries" successfully. The README mentioned Current list of data sources and availability includes TPC-H. However, I have no idea how to import the TPC-H into the databases.

Could you please give any hint how to run the command like:

python ./run_benchmark.py -u admin -p HyperInteractive -n omnisci -t flights_2008_10k -l TestLabel -d ./queries/flights -i 10 -g 1 -S localhost

so that I can run the TPC-H benchmark queries.

cdessanti commented 3 years ago

Hi @Eilowangfang ,

I'm sorry for the low reply, but I can supppl everything you asked for, to run the TPCH benchmark (DDLs, data, queries (modified or not)

Please contact me at candido.dessanti@omnisci.com.

cyberspicecai commented 3 years ago

Hi @Eilowangfang ,

I'm sorry for the low reply, but I can supppl everything you asked for, to run the TPCH benchmark (DDLs, data, queries (modified or not)

Please contact me at candido.dessanti@omnisci.com.

Hi， @cdessanti 

   I mail you for  TPCH benchmark tool ，would you pls check your mail? Or you can send the tool to cyberspice@163.com.

   Thanks.
cdessanti commented 3 years ago

Hi @cyberspicecai,

Sent an email with some files to help you run a tpch benchmark with the omnisci database. Hope to get a feedback from you soon

Regards, Candido

cyberspicecai commented 3 years ago

Hi，@cdessanti 

 Got the mail from you. I will check the system soon.

 BR
 Cyberspice
cdessanti commented 3 years ago

Hi @cyberspicecai,

Feel free to ask everything you need assistance to run the benchmark or fix performance issues or whatever.

Regards, Candido

jiashenC commented 2 years ago

Hi @cdessanti, is this still relevant if I want to study performance of HeavyDB?

cdessanti commented 2 years ago

I wouldnt take this as a the best benchmark to track the performances of heavydb, but It could be useful. We have some queris of tpc-h benchmark running on nightly builds to check the performance of the latests PR on master.

Candido