ClickHouse 1.1.0

pts/clickhouse-1.1.0 - 19 August 2022 - Update against upstream, fix aarch64 usage.

downloads.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <Downloads>
    <Package>
      <URL>https://github.com/ClickHouse/ClickHouse/releases/download/v22.5.4.19-stable/clickhouse-common-static-22.5.4.19-amd64.tgz</URL>
      <MD5>a5e573bae863eb852fc3b9b445d4a77c</MD5>
      <SHA256>a7ed440f46632884810c0131dc16256bdb3771f50846806003af1961edd1f82b</SHA256>
      <FileName>clickhouse-common-static-22.5.4.19-amd64.tgz</FileName>
      <FileSize>237338319</FileSize>
      <ArchitectureSpecific>x86_64</ArchitectureSpecific>
    </Package>
    <Package>
      <URL>https://github.com/ClickHouse/ClickHouse/releases/download/v22.5.4.19-stable/clickhouse-common-static-22.5.4.19-arm64.tgz</URL>
      <MD5>a3224bf28f80e461434cf9c670be87fd</MD5>
      <SHA256>5f8e17d6504958e38b211163f5ef64bbc3de51c6265edf62407054a24a770645</SHA256>
      <FileName>clickhouse-common-static-22.5.4.19-arm64.tgz</FileName>
      <FileSize>162809174</FileSize>
      <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/

if [ $OS_ARCH = "aarch64" ]
then
	tar -xf clickhouse-common-static-22.5.4.19-arm64.tgz
else
	tar -xf clickhouse-common-static-22.5.4.19-amd64.tgz
fi

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

cd ~
CLICKHOUSE_CLIENT=clickhouse-common-static-22.5.4.19/usr/bin/clickhouse
echo "#!/bin/bash
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.4-->
<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.4-->
<PhoronixTestSuite>
  <TestInformation>
    <Title>ClickHouse</Title>
    <AppVersion>22.5.4.19</AppVersion>
    <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.1.0</Version>
    <SupportedPlatforms>Linux</SupportedPlatforms>
    <SoftwareType>Application</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>