Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: tiup bench ch prepare时报错
tiup Version Information
~$ tiup --version
1.10.2 tiup
Go Version: go1.18.3
Git Ref: v1.10.2
GitHash: 2de5b500c9fae6d418fa200ca150b8d5264d6b19
Steps
$ mysql -uroot -P4000 -e"drop database ch;"
$ tiup bench ch prepare -U root -H localhost -P4000 -D ch --dropdata --ignore-error --warehouses 30
tiup is checking updates for component bench ...
Starting component `bench`: /home/tidb/.tiup/components/bench/v1.10.2/tiup-bench ch prepare -U root -H localhost -P4000 -D ch --dropdata --ignore-error --warehouses 30
creating nation
creating region
creating supplier
generating nation table
generate nation table done
generating region table
generate region table done
generating suppliers table
generate suppliers table done
creating view revenue1
a fatal occurred when preparing data: Error 1146: Table 'ch.order_line' doesn't exist
How do I use this tool, and why is there an error here? Is there a defect?
Are you planning to do a TPC-C test or a TPC-H test? I see your command is:
tiup bench ch prepare -U root -H localhost -P4000 -D ch --dropdata --ignore-error --warehouses 30
There is no tiup bench ch parameter, right?
Try tiup bench tpcc prepare -U root -H localhost -P4000 -D ch --dropdata --ignore-error --warehouses 30
Your tiup version is not the latest, right?
Sorry, I’m using TiDB version 6.1.0, and I checked the tiup for version 6.1 and it doesn’t have this command option. Could it be that the documentation hasn’t been updated yet?
I tried the help command in version 6.1, and indeed there are options for ch and ycsb. I also reproduced the error, but I didn’t see the documentation for the steps of these two benchmarks. 
Could it be a beta experimental feature? You might as well report a bug while you’re at it.
It should be an internal testing feature, but it was accidentally compiled into the version.
The image you provided is not accessible. Please provide the text content that needs to be translated.
I also followed the command line help of the tool for stable operation, but it reported an error.
If it’s an internal testing feature, it might have defects.
Let’s verify it together. If there really is a defect, we can get some points for free.
What a coincidence, someone beat us to it! 
Your typing speed is unbeatable 
The official documentation includes TPCC and TPCH tests. It is recommended to refer to the official documentation for relevant performance testing.
ch → clickhouse? Are you specifically testing TiFlash? Give us a spoiler.
This topic was automatically closed 60 days after the last reply. No new replies are allowed.
|
username: MrDuin
|
username: 
|
username: 
|
username: 
|
username: 
|
username: