User-defined Playground

ClickHouse Playground

by Márk Sági-Kazár
on
Linux

A fast, open-source, column-oriented, analytical database.

Startup configuration
clickhouse
ClickHouse playground: A fast, open-source, column-oriented, analytical database.

💡 To explore ClickHouse's scaling capabilities, check out the this multi-node playground.

🔧 System Components

  • ClickHouse Server: High-performance columnar database engine optimized for analytics

🛠️ Tools

  • clickhouse-client: Interactive command-line client for running queries
  • clickhouse-local: Tool for processing local files with ClickHouse SQL

🎯 Getting Started

Connecting to ClickHouse

# Connect using the interactive client
clickhouse-client

# Connect with specific database
clickhouse-client --database=default

# Execute single query
clickhouse-client --query "SELECT version()"
Credentials

If you need to connect from another client, use the following credentials:

  • Host: localhost
  • Port: 9000 (native) or 8123 (HTTP)
  • Username: default
  • Password: iximiuz
  • Database: default

Running Queries

Interactive Mode
From Files
Multiple Queries
# Start interactive session
clickhouse-client

# Example queries in the client
SHOW DATABASES;
SELECT version();
SELECT name FROM system.tables LIMIT 5;

# Save your query to a file
echo "SELECT version()" > query.sql

# Run query from file
clickhouse-client < query.sql

# Run with output formatting
clickhouse-client --format=Pretty < query.sql

# Create file with multiple queries
cat << EOF > queries.sql
SHOW DATABASES;
SELECT version();
SELECT count() FROM system.tables;
EOF

# Run all queries
clickhouse-client --multiquery < queries.sql

📚 Learn More

🧩 Related Content

🧪 Playgrounds

Happy learning! 🚀

Start
Settings