Hi Saleh, The dev list is a good place for this question. For a faster, more interactive discussion, I’d also suggest joining the Apache Doris Slack community.
Doris doesn’t currently offer the same integrated HTAP capabilities as TiDB. We support PostgreSQL CDC through Doris Streaming Jobs (https://doris.apache.org/docs/dev/data-operate/import/import-way/streaming-job/continuous-load-overview), so you can replicate changes into Doris in near real time and run analytical queries there. Those queries see the data that has already been applied in Doris. They don’t automatically include changes that have committed in PostgreSQL but haven’t been replicated yet. In practice, we often see OLTP and OLAP owned by different teams and run on separate clusters, even when the database technology supports both. That keeps analytical workloads from competing with transactional traffic and lets each team scale independently. For your setup, I’d start by keeping writes and point lookups on the transactional side and sending analytical queries to Doris explicitly. We don’t currently provide a PostgreSQL extension like pg_clickhouse or pg_duckdb that lets you query Doris from a PostgreSQL session. If you share which queries need to see a write immediately and how much lag the rest can tolerate, we can discuss what would be practical for your setup on Slack. Best, Rayner On Fri, 13 Nov 2026 at 13:57, <dev-reject-1794549464.2725509.pagamicmfbckjbjhn...@doris.apache.org> wrote: > > > To approve: > dev-accept-1794549464.2725509.pagamicmfbckjbjhn...@doris.apache.org > To reject: > dev-reject-1794549464.2725509.pagamicmfbckjbjhn...@doris.apache.org > To give a reason to reject: > %%% Start comment > %%% End comment > > > > > ---------- Forwarded message ---------- > From: [email protected] > To: [email protected] > Cc: > Bcc: > Date: Fri, 13 Nov 2026 05:57:36 +0000 > Subject: Composable HTAP with Apache Doris > Hello, > I apologize for the previous message I sent. I accidentally sent it > before completing the message. > I hope that I am sending this inquiry to the right place. We are > evaluating OLAP solutions for composable HTAP with distributed > PostgreSQL databases such as YugabyteDB and Citus. For this, we have > identified some specific features that would be required, similar to > what exists in purpose-built HTAP databases (e.g. OceanBase and TiDB), > and I would like to ask about the existence of each one in Apache Doris, > either now or in the near future, below: > > 1) Sub-Second replication from PostgreSQL to Apache Doris (without any > transformations). An example of what I mean is something like to > ClickHouse's recently released "WALShadow" feature. > > 2) Consistent views of state, similar to what is achieved in HTAP > databases such as OceanBase and TiDB. So that OLAP queries in Apache > Doris include ALL data from the source database, meaning both what has > already been stored in Apache Doris AND what has yet to be replicated > into Apache Doris from the source database. > > 3) Automatic routing of queries between Apache Doris and PostgreSQL > based on which engine would handle it best. For example, if the query > is a DML or point-lookup operation then it should be routed to > PostgreSQL, and if the query is an OLAP query it should be processed by > Apache Doris. If this is not available within Apache Doris itself, then > compatibility with a proxy tools such as ProxySQL and QueryFlux would be > required. > > 4) PostgreSQL interface compatibility and/or SQLGlot/QueryFlux > integration. I previously read an article on Dev.to describing SQLGlot > integration within Apache Doris for handling multiple SQL dialects. But > I could not find reference to this capability in the documentation. Has > this feature been removed? Also, are there plans to add PostgreSQL wire > protocol support to Apache Doris? If not, then the QueryFlux proxy can > be used for conversion of SQL dialect and wire protocol. QueryFlux is > relatively new, but looks very promising, and it lists compatibility > with StarRocks. Are you familiar with this project, and have you > used/tested QueryFlux with Apache Doris (especially in an HTAP > architecture)? > > I look forward to your kind clarifications on the points above, > including both what exists today and what is planned. And if there is a > better place for me to send such inquiries, please do let me know. > > Thank You and Best Regards, > Saleh > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
