ClickHouse 1.0.0

pts/clickhouse-1.0.0 - 25 June 2022 - Initial commit of ClickHouse benchmark.

downloads.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.3-->
<PhoronixTestSuite>
  <Downloads>
    <Package>
      <URL>https://builds.clickhouse.com/master/amd64/clickhouse</URL>
      <FileName>clickhouse_linux_amd64</FileName>
      <ArchitectureSpecific>x86_64</ArchitectureSpecific>
    </Package>
    <Package>
      <URL>https://builds.clickhouse.com/master/aarch64/clickhouse</URL>
      <FileName>clickhouse_linux_aarch64</FileName>
      <ArchitectureSpecific>AArch64</ArchitectureSpecific>
    </Package>
    <Package>
      <URL>https://raw.githubusercontent.com/ClickHouse/ClickHouse/v22.3.7.28-lts/benchmark/clickhouse/queries.sql</URL>
      <MD5>f1acbd265ff945b7d678ebf87d6dce6c</MD5>
      <SHA256>2164b9759dd796a7718ef9ac03a0031422c1948343de7417bfd385350cff0fb1</SHA256>
      <FileName>clickhouse_queries.sql</FileName>
      <FileSize>8074</FileSize>
    </Package>
    <Package>
      <URL>https://datasets.clickhouse.com/hits/partitions/hits_100m_obfuscated_v1.tar.xz</URL>
      <MD5>40200a88cbd311918bcd597333aa1912</MD5>
      <SHA256>972553f570405a6a632e95ccba057fdf264ca75771ba02de70b6cc6b24e52a0b</SHA256>
      <FileName>hits_100m_obfuscated_v1.tar.xz</FileName>
      <FileSize>9722280160</FileSize>
    </Package>
  </Downloads>
</PhoronixTestSuite>

install.sh

#!/bin/sh

# Based on https://clickhouse.com/docs/en/operations/performance-test/

chmod +x clickhouse_*
tar -xf hits_100m_obfuscated_v1.tar.xz -C .
echo $? > ~/install-exit-status
mv hits_100m_obfuscated_v1/* .

cd ~
echo "#!/bin/bash

if [ \$OS_ARCH = \"aarch64\" ]
then
	CLICKHOUSE_CLIENT=clickhouse_linux_aarch64
else
	CLICKHOUSE_CLIENT=clickhouse_linux_amd64
fi

TRIES=3

./\$CLICKHOUSE_CLIENT server 2>/dev/null &
SERVER_PID=\$!
sleep 5

./\$CLICKHOUSE_CLIENT client --query \"SELECT count() FROM hits_100m_obfuscated\"
echo \$? > ~/test-exit-status

cat clickhouse_queries.sql | sed \"s/{table}/hits_100m_obfuscated/g\" | while read query; do
    sync
    echo \"QUERY: \$query\" >> \$LOG_FILE
    for i in \$(seq 1 \$TRIES); do
    	echo -n \"Clickhouse Query Time \$i: \" >> \$LOG_FILE
    	./\$CLICKHOUSE_CLIENT client --time --format=Null --max_memory_usage=100G --query=\"\$query\" >> \$LOG_FILE 2>&1
    	retval=\$?
	if [ \$retval -ne 0 ]; then
	    echo \$retval > ~/test-exit-status
	    kill -9 \$SERVER_PID
	    sleep 3
	    exit
	fi
    done
done

kill -9 \$SERVER_PID
sleep 2

./\$CLICKHOUSE_CLIENT server --version > ~/pts-footnote 2>/dev/null" > clickhouse
chmod +x clickhouse

results-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.3-->
<PhoronixTestSuite>
  <ResultsParser>
    <OutputTemplate>Clickhouse Query Time 1: #_RESULT_#</OutputTemplate>
    <LineHint>Clickhouse Query Time 1:</LineHint>
    <MultiMatch>GEOMETRIC_MEAN</MultiMatch>
    <DivideResultDivisor>60</DivideResultDivisor>
    <ArgumentsDescription>100M Rows Web Analytics Dataset, First Run / Cold Cache</ArgumentsDescription>
  </ResultsParser>
  <ResultsParser>
    <OutputTemplate>Clickhouse Query Time 2: #_RESULT_#</OutputTemplate>
    <LineHint>Clickhouse Query Time 2:</LineHint>
    <MultiMatch>GEOMETRIC_MEAN</MultiMatch>
    <DivideResultDivisor>60</DivideResultDivisor>
    <ArgumentsDescription>100M Rows Web Analytics Dataset, Second Run</ArgumentsDescription>
  </ResultsParser>
  <ResultsParser>
    <OutputTemplate>Clickhouse Query Time 3: #_RESULT_#</OutputTemplate>
    <LineHint>Clickhouse Query Time 3:</LineHint>
    <MultiMatch>GEOMETRIC_MEAN</MultiMatch>
    <DivideResultDivisor>60</DivideResultDivisor>
    <ArgumentsDescription>100M Rows Web Analytics Dataset, Third Run</ArgumentsDescription>
  </ResultsParser>
</PhoronixTestSuite>

test-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.3-->
<PhoronixTestSuite>
  <TestInformation>
    <Title>ClickHouse</Title>
    <Description>ClickHouse is an open-source, high performance OLAP data management system. This test profile uses ClickHouse's standard benchmark recommendations per https://clickhouse.com/docs/en/operations/performance-test/ with the 100 million rows web analytics dataset. The reported value is the query processing time using the geometric mean of all queries performed.</Description>
    <ResultScale>Queries Per Minute, Geo Mean</ResultScale>
    <Proportion>HIB</Proportion>
    <TimesToRun>3</TimesToRun>
  </TestInformation>
  <TestProfile>
    <Version>1.0.0</Version>
    <SupportedPlatforms>Linux</SupportedPlatforms>
    <SoftwareType>Utility</SoftwareType>
    <TestType>System</TestType>
    <License>Free</License>
    <Status>Verified</Status>
    <SupportedArchitectures>x86_64, AArch64</SupportedArchitectures>
    <EnvironmentSize>26900</EnvironmentSize>
    <ProjectURL>https://clickhouse.com/</ProjectURL>
    <RepositoryURL>https://github.com/ClickHouse/ClickHouse</RepositoryURL>
    <Maintainer>Michael Larabel</Maintainer>
  </TestProfile>
</PhoronixTestSuite>