mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
31 lines
850 B
Bash
Executable File
31 lines
850 B
Bash
Executable File
#!/bin/bash
|
|
set -euo pipefail
|
|
|
|
# Creates TPC-DS SF1 tables in tpcds database by transforming tests/benchmarks/tpc-ds/init.sql to use S3 web disk.
|
|
|
|
REPO_ROOT="$(cd "$(dirname "$0")/../.." && pwd)"
|
|
INIT_SQL="$REPO_ROOT/tests/benchmarks/tpc-ds/init.sql"
|
|
S3_BASE="https://tpc-ds-sf1.s3.amazonaws.com"
|
|
|
|
clickhouse-client --query "CREATE DATABASE IF NOT EXISTS tpcds"
|
|
|
|
awk -v s3="$S3_BASE" '
|
|
/^---/ { next }
|
|
/^[[:space:]]*$/ { next }
|
|
/^CREATE TABLE / {
|
|
name = $3
|
|
gsub(/\(.*/, "", name)
|
|
current_table = name
|
|
sub(/CREATE TABLE /, "CREATE TABLE tpcds.")
|
|
}
|
|
/^);/ {
|
|
print ")"
|
|
print "ENGINE = MergeTree"
|
|
print "SETTINGS"
|
|
print " table_disk = 1,"
|
|
printf " disk = disk(type = web, endpoint = \047%s/%s/\047);\n\n", s3, current_table
|
|
next
|
|
}
|
|
{ print }
|
|
' "$INIT_SQL" | clickhouse-client -m --data_type_default_nullable=1
|