shell scripts for generating tpch-xxx using go-tpc.
- Build go-tpc binary: git clone git@github.com:pingcap/go-tpc.git && cd go-tpc && make build
- Start a tidb cluster for go-tpc to create schema: tiup playground v6.5.0 --without-monitor --tiflash 0
- Start to generate CSV files of tpch-xxx: ./gen.sh GO_TPC_BIN SF
- import to tidb cluster:
- load data SQL:
source /home/guojiangtao/work/go-tpc/bin/shell/tpch10/tpch10.lineitem-schema.sql load data local infile '/home/guojiangtao/work/go-tpc/bin/shell/tpch10/tpch10.lineitem-schema.sql' into table t1 fields terminated by '|';
- tidb-lightning:
- change lightning.toml
- lightning import: tiup tidb-lightning -config lightning.toml
- load data SQL: