44 results found
-
Support table engine MaterializedPostgreSQL in ClickHouse
As a user of both PostgreSQL (on-prem, on another cloud provider or at Aiven) and Aiven for ClickHouse,
I want to be able to ingest my PostgreSQL data, not as a on time snapshot or a remote view of the data like the current integrations allow me to, but as tables created and stored in ClickHouse that pull updates from PostgreSQL regularly.2 votes -
Improve default JOIN Engine for Aiven for ClickHouse
As a user of Aiven for ClickHouse,
I want to use the most optimized default settings possible. From the start I want to have the default JOIN set as the most performant possible and not the ClickHouse default one. This comes without me, the user, having to change any settings. However, I should be able to tweak those settings if needed in specific cases.
See https://clickhouse.com/docs/en/engines/table-engines/special/join2 votes -
Better error messages when using the built-in query editor in console for Aiven for ClickHouse
As a user,
I want to have a better idea why queries I run in the built-in query editor in the Aiven console do not work.
Clearer error messages are a way to let users know what went wrong and modify their queries accordingly.2 votes -
Serverless experience
As developer,
I want to load data and run some queries against that data using ClickHouse,
so that I can start a new project, or learn the value of ClickHouse as a technology,
without having to worry about the size shape or cost of a hosted VM running that instance or cluster.
It would be good to have a running total of the cost per query.2 votes -
Cancel Queries for ClickHouse regardless of where I ran the query (including the query editor in the Aiven console)
As ClickHouse User
I want to be able to cancel distributed ClickHouse queries without contacting support
so that I can resolve accidental query executions by myself in a self service manner. This reduces RTT and allows for me to move faster.
I want to be able to do so regardless of the tool I use to run and cancel the query - this includes the query editor in the Aiven console2 votes -
MySQL Table engine
As someone drunning analytics queries with Clickhouse against multiple data sources,
I want to have the MySQL table engine enabled so that I can create tables in Clickhouse that span data in external MySQL instances,
so that I can bring the value of external data sources into my analysis.2 votes -
Connect to Specific ClickHouse Shard
As Data Engineer
I want to Connect to a specific ClickHouse Shard, either an assigned connection, or a random one.
so that I can leverage distributed tables for read workloads without needing to rely on them for writes.
This will reduce the overhead for high ingestion rates, and make the "Inserted Rows" metric more accurate, since it currently counts both the distributed table and the underlying table.1 vote -
ClickHouse Query Cache
As an Aiven for ClickHouse user,
I want to take advantage of ClickHouse's query cache (https://clickhouse.com/docs/en/operations/query-cache) at query level to reduce the latency of some of my queries.1 vote -
DDS support for Aiven for Clickhouse
As DevOps
I want to see Dynamic disk sizing (DDS) as available option for Aiven for ClickHouse1 vote -
Providing a Idea on Real-time Resource Optimization Assistant!
One helpful idea for improving user experience on cloud platforms like Aiven is to implement a "Real-time Resource Optimization Assistant": This feature would automatically analyze a user’s resource usage (e.g., CPU, memory, storage) and provide real--time recommendations on scaling resources up or down based on current needs: It could also suggest more cost-effective configurations or alternative services if it detects underutilized resources: For example,, if a database instance is consistently operating well below its capacity,, the assistant would recommend reducing resources to save on costs: Conversely, if there’s a spike in demand, it would suggest scaling up to prevent performance…
1 vote -
Aiven for ClickHouse on OVH Cloud
As an Aiven user and Aiven for ClickHouse user,
I want to be able to use Aiven for ClickHouse on OVH Cloud with all the Aiven capabilities available on the other cloud providers, seamlessly.1 vote -
Manage ClickHouse integrations' credentials securely & easily
As a ClickHouse user, I want to be able to use table functions & engines that require identification credentials (ex. private remote s3 bucket, remote delta lake table etc.) without hassle and risks.
With named collections in Aiven for ClickHouse, you can set your integrations credentials once and use it safely with all your remote queries.
Moreover, you can easily rotate credentials if needed: change credentials once using the Aiven console and apply it to all your integrations.1 vote -
External schema registry for kafka
As developer
I want to have a possibility to connect to external kafka and use external schema registry at once,
so that I can digest external messages encoded with external schema (AvroConfluent for example).1 vote -
Connecting Clickhouse to a PostgreSQL read replica
At this moment there are only the primary Postgres instances available for a clickhouse connect. Wouldn't it make sense to have the capability connection Clickhouse to a read replica to prevent performance impacts on the primary?
1 vote -
Option for ClickHouse Tiered Storage to use my OCI object storage
As a user of Aiven for ClickHouse,
I want to be able to choose between Aiven's object storage (the default) and my own Oracle - OCI object storage.1 vote -
Better zookeeper insights in Aiven for ClickHouse
As a user of Aiven for ClickHouse,
I want to be able to know more about Zookeeper, its current state and what it is doing at any given time (in the console or in Grafana).1 vote -
View in-progress and completed mutations in my Aiven for ClickHouse services directly in the Aiven console
As a user of at least one Aiven for ClickHouse service,
I want to be able to easily view in the Aiven console, in my ClickHouse service, the list of mutations (both in-progress and completed) and relevant information about them such as creation time, ID of the mutation, what table and databases the mutation is applied on, if it is done or in progress etc.
At the moment, this information can be found in system.mutations table and system.replication_queue for replicated tables, but it is a manual process to check them.
1 vote -
Apache Beam - ClickHouse integration
As a user of Apache Beam and ClickHouse,
I want to be able to ingest my data from Apache Beam into a ClickHouse table in near-real time with at-least-once (meaning it is acceptable that messages are read more than once). Writing the data using the ClickHouseIO (built on JDBC driver) c.f. https://beam.apache.org/releases/javadoc/2.10.0/org/apache/beam/sdk/io/clickhouse/ClickHouseIO.html1 vote -
ClickHouse query history in the query editor of the Aiven console
As a user of the console,
I want to be able to see the queries somewhere after I ran them, successfully or not. It is important that I can retrieve failed queries to modify them and run them again, as well as successful queries to be able to save them for future use or reference.1 vote -
Saving ClickHouse queries in the query editor of the Aiven console
As a user of the console,
I want to be able to save queries that I run in the Aiven console in order to retrieve them later on, or re-run saved queries without having to write them again.1 vote
- Don't see your idea?