https://doris.incubator.apache.org/zh-CN/docs/3.x/sql-manual/sql-statements/data-modification/backup-and-restore/RESTORE/
RESTORE - Apache Doris
该语句用于将之前通过 BACKUP 命令备份的数据，恢复到指定数据库下。该命令为异步操作。提交成功后，需通过 SHOW RESTORE命令查看进度。
apache dorisrestore
https://doris-forum.org.cn/questions/D1oZ2/zen-me-xiu-gai-zhu-jian-mo-xing-de-dao-ru-cao-zuo-mo-ren-fang-shi-gai-cheng-fang-shi
怎么修改主键模型的导入操作默认“upsert”方式改成“update”方式 - Apache Doris 中文技术论坛
目前Stream Load导入操作，主键模型默认是 UPSERT语义 （UPDATE OR INSERT），如何修改成单UPDATE方式
apache doris
https://doris.apache.org/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-RENAME
找不到页面 - Apache Doris
apache doris
https://doris.incubator.apache.org/zh-CN/docs/2.1/lakehouse/lakehouse-overview/
湖仓一体概述 - Apache Doris
湖仓一体是将数据湖和数据仓库的优势相结合的现代化大数据解决方案。其融合了数据湖的低成本、高扩展性与数据仓库的高性能、强数据治理能力，从而实现对大数据时代各类数据的高效、安全、质量可控的存储和处理分析。同时通过标准化的数据格式和元数据管理，统一了实时、历史数据，批处理和流处理，
apache doris
https://doris.incubator.apache.org/docs/3.x/install/preparation/os-checking/
OS Checking - Apache Doris
When deploying Doris, ensure the following operating system configurations:
apache dorischecking
https://doris.apache.org/blog/release-note-1.2.7/
Apache Doris announced the official release of version 1.2.7 - Apache Doris
Sep 4, 2023 - Dear community, Apache Doris 1.2.7 is now available, with several enhancements and bug fixes based on 1.2.0，enabling smoother user experience.
apache dorisannouncedofficialreleaseversion
Sponsored https://www.camsoda.com/?id=robuta&ad_id=cs_300x250_b2.gif
Free Live Sex Cams, Cam Girls, Adult Chat, and Pornstar Cams | Camsoda
Join Camsoda for the hottest live cam girls! Free HD webcam shows, private sessions, and real-time chat with sexy models. Watch live now and enjoy!
https://doris.apache.org/zh-CN/docs/dev/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-string/
BITMAP_TO_STRING - Apache Doris
将一个 Bitmap 转化成一个逗号分隔的字符串，字符串中包含所有设置的 Bit 位。
apache dorisbitmapstring
https://doris.incubator.apache.org/docs/dev/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff/
TIMEDIFF - Apache Doris
Calculates the difference between DATE, DATETIME, or TIMESTAMP_NS values and returns a TIME value.
apache doris
https://doris.incubator.apache.org/zh-CN/docs/dev/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY/
CREATE ENCRYPTKEY - Apache Doris
apache doriscreate
Sponsored https://www.xlovecam.com/prm03/textlink?id_affilie=26457&p=online&tri=10
Best Live Sex Cam Shows with Free Live Chat | XLoveCam
Watch thousands of cam girls get naked on XLoveCam.
https://doris.incubator.apache.org/docs/2.1/sql-manual/sql-statements/cluster-management/compute-management/CREATE-WORKLOAD-POLICY/
CREATE WORKLOAD POLICY - Apache Doris
Create a Workload Policy to execute corresponding actions on a query when it meets certain conditions.
apache doriscreateworkloadpolicy
https://doris.apache.org/docs/dev/connection-integration/data-integration/flink-doris-connector/data-type-mapping/
Data Type Mapping - Apache Doris
How Doris and Flink data types map to each other when reading and writing with Flink Doris Connector.
data typeapache dorismapping
https://doris.apache.org/docs/3.x/sql-manual/sql-functions/scalar-functions/json-functions/json-replace/
JSON_REPLACE - Apache Doris
The JSONREPLACE function is used to update data in a JSON and return the result.
apache dorisjsonreplace
https://doris.incubator.apache.org/zh-CN/docs/4.x/sql-manual/sql-statements/account-management/SET-LDAP_ADMIN_PASSWORD/
SET LDAP_ADMIN_PASSWORD - Apache Doris
SET LDAPADMINPASSWORD 命令用于设置 LDAP 管理员密码。使用 LDAP 认证时，doris 需使用管理员账户和密码来向 LDAP 服务查询登录用户的信息。
ldap adminapache dorissetpassword
https://doris.incubator.apache.org/zh-CN/docs/3.x/sql-manual/sql-functions/scalar-functions/string-functions/int-to-uuid/
INT_TO_UUID - Apache Doris
对于输入的已编码 LARGEINT，转译为原始的 uuid 字符串。
apache dorisintuuid
https://doris.apache.org/docs/4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/ln/
LN - Apache Doris
Returns the natural logarithm of x to base e.
apache doris
Sponsored https://ctwmsg.com/?siteId=jasmin&cobrandId=&superCategoryName=&categoryName=mature&pageName=listpage&prm[psid]=robuta&prm[pstool]=211_15&prm[psprogram]=revs&prm[campaign_id]=&subAffId=
Live Sex Cams and Adult Chat with Webcam Girls | LiveJasmin
Chat for free on LiveJasmin and watch HD Live Sex cam shows! 2000+ Models are waiting for You, no registration required.
https://doris.apache.org/zh-CN/docs/dev/sql-manual/sql-functions/scalar-functions/numeric-functions/e/
E - Apache Doris
apache doris
https://doris.incubator.apache.org/zh-CN/docs/4.x/sql-manual/sql-functions/aggregate-functions/group-bit-xor/
GROUP_BIT_XOR - Apache Doris
对单个整数列或表达式中的所有值执行按位 xor 运算。
bit xorapache dorisgroup
https://doris-forum.org.cn/questions/D1DQ3/guan-fang-shi-li-han-shu-wu-fa-shi-yong
官方示例posexplode函数无法使用 - Apache Doris 中文技术论坛
select id,name,score, k,v from table_test lateral view posexplode(score) tmp as k,v order by id;
apache doris
https://doris.apache.org/docs/2.1/sql-manual/sql-functions/scalar-functions/ip-functions/ipv4-cidr-to-range/
IPV4_CIDR_TO_RANGE - Apache Doris
Receive an IPv4 and an Int16 value containing CIDR. Returns a struct that contains two IPv4 fields representing the lower range (min) and higher
apache doriscidrrange
https://doris.apache.org/blog/archive/
Archive - Apache Doris
apache dorisarchive
https://doris.apache.org/zh-CN/docs/4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT/
SHOW TABLET STORAGE FORMAT - Apache Doris
该语句用于显示 Backend 上的存储格式信息
apache dorisshowtabletstorageformat
https://doris.apache.org/docs/2.1/data-operate/import/import-way/mysql-load-manual/
MySQL Load - Apache Doris
Apache Doris is compatible with the MySQL protocol and supports the use of the standard MySQL LOAD DATA syntax to import local files.
apache dorismysqlload
https://doris.apache.org/blog/Doris-onelake-fabric-integration/
From OneLake to Insights: Building Modern Analytics with Apache Doris and Microsoft Fabric - Apache...
Nov 17, 2025 - Connect Apache Doris to Microsoft Fabric’s OneLake, the unified data lake behind Fabric. See how to set up data and authentication in Fabric, creating an...
apache dorismicrosoft fabricinsightsbuildingmodern
https://doris.apache.org/docs/3.x/install/deploy-on-kubernetes/separating-storage-compute/install-fdb/
Install FoundationDB - Apache Doris
FoundationDB is an open-source distributed database released under the Apache 2.0 license, it provides strong consistency for structured data storage.
apache dorisinstallfoundationdb
https://doris.apache.org/docs/3.x/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITIONS/
SHOW PARTITIONS - Apache Doris
This statement is used to display partition information. It supports both Internal catalog and Hive Catalog.
apache dorisshowpartitions
https://doris.apache.org/zh-CN/docs/2.1/sql-manual/sql-functions/aggregate-functions/sum/
SUM - Apache Doris
apache dorissum
https://doris.apache.org/docs/2.1/sql-manual/sql-statements/statistics/SHOW-STATS/
SHOW COLUMN STATS - Apache Doris
This statement is used to show the column statistics of a table.
apache dorisshowcolumnstats
https://doris.apache.org/docs/2.1/admin-manual/workload-management/analysis-diagnosis/
Workload Analysis Diagnosis - Apache Doris
The workload analysis for clusters is primarily divided into two stages:
apache dorisworkloadanalysisdiagnosis
https://doris.apache.org/docs/4.x/sql-manual/basic-element/operators/conditional-operators/boolean-testing-operators/
Boolean Testing Operators - Apache Doris
This operator is used exclusively to check for TRUE, FALSE, or NULL. For an introduction to NULL, please refer to the "Nulls" section.
apache dorisbooleantestingoperators
https://doris.apache.org/zh-CN/docs/4.x/admin-manual/system-tables/information_schema/backend_configuration/
backend_configuration - Apache Doris
apache dorisbackendconfiguration
https://doris.apache.org/docs/4.x/sql-manual/sql-functions/window-functions/rank/
RANK - Apache Doris
RANK() is a window function that returns the rank of values in an ordered dataset. Rankings start at 1 and increment sequentially.
apache dorisrank
https://doris.incubator.apache.org/zh-CN/docs/2.1/sql-manual/sql-functions/aggregate-functions/bitmap-union/
BITMAP_UNION - Apache Doris
计算输入 Bitmap 的并集，返回新的 bitmap
apache dorisbitmapunion
https://doris.apache.org/zh-CN/docs/3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-pushback/
ARRAY_PUSHBACK - Apache Doris
apache dorisarraypushback
https://doris.incubator.apache.org/docs/dev/table-design/index/ngram-bloomfilter-index/
NGram BloomFilter Index - Apache Doris
The NGram BloomFilter index is based on N-Gram tokenization and BloomFilter. It accelerates LIKE fuzzy queries on string columns by skipping data blocks that...
apache dorisngrambloomfilterindex
https://doris.apache.org/zh-CN/docs/3.x/admin-manual/open-api/fe-http/upload-action/
Upload Action - Apache Doris
Upload Action 目前主要服务于 FE 的前端页面，用于用户导入一些测试性质的小文件。
apache dorisuploadaction
https://doris.apache.org/zh-CN/docs/2.1/sql-manual/sql-functions/aggregate-functions/array-agg/
ARRAY_AGG - Apache Doris
将一列中的值（包括空值 null）串联成一个数组，可以用于多行转一行（行转列）。
apache dorisarrayagg
https://doris.incubator.apache.org/docs/3.x/admin-manual/open-api/fe-http/debug-point-action/
Debug Point - Apache Doris
Debug point is a piece of code, inserted into FE or BE code, when program running into this code,
apache dorisdebugpoint
https://doris.apache.org/zh-CN/docs/2.0/sql-manual/sql-functions/conditional-functions/case/
找不到页面 - Apache Doris
apache doris
https://doris.incubator.apache.org/docs/3.x/sql-manual/basic-element/operators/conditional-operators/logical-operators/
Logic Operators - Apache Doris
Logical conditions combine the results of two components' conditions to generate a single result based on them,
logic operatorsapache doris
https://doris.incubator.apache.org/zh-CN/docs/3.x/compute-storage-decoupled/file-cache/
文件缓存功能介绍 - Apache Doris
在存算分离的架构中，数据被存储在远程存储。Doris 数据库通过利用本地硬盘上的缓存来加速数据访问，并采用了一种先进的多队列 LRU（Least Recently Used）策略来高效管理缓存空间。这种策略特别优化了索引和元数据的访问路径，旨在最大化地缓存用户频繁访问的数据。
apache doris
https://doris.apache.org/docs/4.x/sql-manual/sql-functions/aggregate-functions/sequence-count/
SEQUENCE_COUNT - Apache Doris
Counts the number of event chains that matched the pattern. The function searches event chains that do not overlap.
apache dorissequencecount
https://doris.apache.org/zh-CN/docs/2.1/sql-manual/sql-functions/scalar-functions/map-functions/map/
MAP | Map Functions - Apache Doris
apache dorismapfunctions
https://doris.apache.org/blog/auto-increment-columns-in-databases/
Auto-increment columns in databases: a simple magic that makes a big difference - Apache Doris
Apr 8, 2024 - Auto-increment columns in Apache Doris accelerates dictionary encoding and pagination without damaging data writing performance. This is an introduction to its...
big differenceapache dorisautoincrementcolumns
https://doris.apache.org/docs/4.x/lakehouse/lakehouse-overview/
Lakehouse Overview - Apache Doris
The lakehouse is a modern big data solution that combines the advantages of data lakes and data warehouses.
apache dorislakehouseoverview
https://doris.incubator.apache.org/zh-CN/docs/3.x/sql-manual/sql-statements/transaction/COMMIT/
COMMIT - Apache Doris
提交一个显式事务。与 BEGIN 成对使用。
apache doriscommit
https://doris.apache.org/zh-CN/docs/4.x/sql-manual/sql-functions/aggregate-functions/histogram/
HISTOGRAM - Apache Doris
HISTOGRAM（直方图）函数用于描述数据分布情况，它使用“等高”的分桶策略，并按照数据的值大小进行分桶，并用一些简单的数据来描述每个桶，比如落在桶里的值的个数。仅统计非 NULL 的数据。
apache dorishistogram
https://www.selectdb.com/blog/840
AI大模型独角兽 MiniMax 基于 Apache Doris 升级日志系统，PB 数据秒级查询响应 — SelectDB 博客
AI 大模型独角兽 MiniMax 在面临早期日志系统资源消耗、写入性能等巨大挑战后，开始寻找全新的日志系统方案，并基于 Apache Doris 升级了日志系统，新系统已接入 MiniMax 内部所有业务线日志数据，数据规模为 PB 级， 整体可用性达到 99.9% 以上，10 亿级日志数据的检索速度可实现秒级响应。
apache dorisminimax
https://doris.apache.org/docs/dev/sql-manual/sql-functions/scalar-functions/date-time-functions/day-floor/
DAY_FLOOR - Apache Doris
The DAYFLOOR function is used to round down a specified date or time value to the start of the nearest specified day period.
apache dorisdayfloor
https://doris.apache.org/zh-CN/docs/dev/data-operate/import/data-source/amazon-s3/
Amazon S3 - Apache Doris
如何从 Amazon S3 导入数据到 Doris：使用 S3 Load 异步导入与 TVF 同步导入的完整步骤、参数与示例。
apache dorisamazon
https://doris.apache.org/blog/Improving-Query-Speed-to-Make-the-Most-out-of-Your-Data/
Best practice in Duyansoft, improving query speed to make the most out of your data - Apache Doris
Feb 27, 2023 - This is about how Duyansoft improved its overall data processing efficiency by optimizing the choice and usage of data warehouses.
make the mostbest practiceout ofyour dataapache doris
https://doris.apache.org/docs/dev/admin-manual/config/config-dir/
Config Dir - Apache Doris
The configuration file directory for FE and BE is conf/. In addition to storing the default fe.conf, be.conf and other files,
apache dorisconfigdir
https://doris.incubator.apache.org/zh-CN/why-doris/benchmarks/
Apache Doris Benchmarks: SQL Analytics and Agent Observability - Apache Doris
Apache Doris benchmark results against ClickHouse, Redshift, Snowflake, Trino, Elasticsearch, OpenSearch, PostgreSQL, and DuckDB on structured analytics (SSB,...
apache dorisbenchmarkssqlanalyticsagent
https://doris.apache.org/docs/dev/sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext/
ST_ASTEXT - Apache Doris
Converts a geometric object into its WKT (Well-Known Text) text representation. WKT is a text-based format for representing geospatial data,
apache doris
https://doris.apache.org/zh-CN/docs/4.x/query-acceleration/tuning/tuning-plan/controlling-hints-with-cbo-rule/
使用 Hint 控制 CBO 规则进行代价改写 - Apache Doris
如何在 Doris 中通过 USE_CBO_RULE Hint 显式启用 CBO 代价改写规则？本文介绍语法、可用规则及聚合下推等典型场景示例。
apache dorishintcbo
https://doris.apache.org/zh-CN/docs/2.1/sql-manual/sql-statements/table-and-view/view/ALTER-VIEW/
ALTER VIEW - Apache Doris
apache dorisalterview
https://doris.apache.org/zh-CN/docs/2.1/sql-manual/sql-functions/window-functions/lead/
LEAD - Apache Doris
LEAD() 是一个窗口函数，用于访问当前行之后的行数据，而无需进行自连接。它可以获取分区内当前行之后第 N 行的值。
apache dorislead
https://doris.incubator.apache.org/zh-CN/docs/2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/sin/
SIN - Apache Doris
apache dorissin
https://doris.apache.org/docs/4.x/data-operate/import/import-way/streaming-job/continuous-load-s3/
S3 ingestion overview - Apache Doris
Choose ordered, notification, or one-time S3 ingestion with Doris Streaming Job, with guides for shared options, monitoring, and job management.
apache dorisingestionoverview
https://doris.apache.org/zh-CN/docs/2.1/table-design/data-partitioning/data-distribution/
数据分布概念 - Apache Doris
在 Doris 中，数据分布通过合理的分区和分桶策略，将数据高效地映射到各个数据分片（Tablet）上，从而充分利用多节点的存储和计算能力，支持大规模数据的高效存储和查询。
apache doris
https://doris.incubator.apache.org/docs/dev/admin-manual/workload-management/sql-blocking/
Query Circuit Breaking: SQL Block Rule and Workload Policy Configuration Guide - Apache Doris
Learn how to use SQL Block Rule and Workload Policy to block full table scans, limit query resource consumption, and prevent abnormal large queries from...
circuit breakingconfiguration guideapache dorisquerysql
https://doris.apache.org/zh-CN/docs/2.1/sql-manual/sql-statements/character-set/SHOW-CHARSET/
SHOW CHARSET - Apache Doris
"SHOW CHARSET" 命令用于显示当前数据库管理系统中可用的字符集（character set）以及与每个字符集相关联的一些属性。
apache dorisshowcharset
Sponsored https://www.amazingasianz.com/enter.php?prg=1&id=robuta&t=best&ad_id=amazingasianz_300x250_bluehpimg.gif
AmazingAsianz
Meet hot local Asian girls today on AmazingAsianz.
https://doris.apache.org/docs/3.x/sql-manual/sql-functions/scalar-functions/ip-functions/cut-ipv6/
CUT_IPV6 - Apache Doris
Accept an IPv6 type address and return a string containing the address of the specified number of bytes removed in text format.
apache doriscut
https://doris.incubator.apache.org/zh-CN/docs/2.1/admin-manual/config/config-dir/
配置文件目录 - Apache Doris
FE 和 BE 的配置文件目录为 conf/。这个目录除了存放默认的 fe.conf, be.conf 等文件外，也被用于公用的配置文件存放目录。
apache doris
https://doris.incubator.apache.org/docs/dev/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITIONS/
SHOW PARTITIONS - Apache Doris
This statement is used to display partition information. It supports both Internal catalog and Hive Catalog.
apache dorisshowpartitions
https://doris.incubator.apache.org/zh-CN/docs/dev/lakehouse/catalogs/jdbc-catalog-overview/
JDBC Catalog - Apache Doris
JDBC Catalog 支持通过标准 JDBC 接口连接支持 JDBC 协议的数据库。
apache dorisjdbccatalog
https://doris.incubator.apache.org/docs/4.x/admin-manual/system-tables/information_schema/rowsets/
rowsets - Apache Doris
Returns basic information about the Rowset.
apache dorisrowsets
https://doris.incubator.apache.org/zh-CN/docs/4.x/admin-manual/system-tables/information_schema/routines/
routines - Apache Doris
此表仅用于兼容 MySQL 行为。永远为空。
apache dorisroutines
https://doris.apache.org/docs/4.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-isnull/
JSON_EXTRACT_ISNULL - Apache Doris
apache dorisjsonextractisnull
https://doris.apache.org/zh-CN/docs/3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-join/
ARRAY_JOIN - Apache Doris
根据分隔符 (sep) 和替换 NULL 的字符串 (nullreplace), 将数组中的所有元素组合成一个新的字符串。
apache dorisarrayjoin
https://doris.incubator.apache.org/zh-CN/docs/dev/admin-manual/cluster-management/fqdn/
FQDN - Apache Doris
本文介绍如何在 Apache Doris 中启用 FQDN（完全限定域名）模式，覆盖新集群启用、旧集群迁移、K8s 部署及服务器变更 IP 等场景。
apache dorisfqdn
https://doris.incubator.apache.org/zh-CN/docs/4.x/sql-manual/sql-functions/window-functions/cume-dist/
CUME_DIST - Apache Doris
CUMEDIST (Cumulative Distribution) 是一种窗口函数，它计算当前行值在排序后结果集中的相对排名。它返回的是当前行值在结果集中的累积分布值，范围从 0 到 1。对于给定的行，其累积分布值等于：(小于或等于当前行值的行数) / (窗口分区中的总行数)。
apache doriscumedist
https://doris.apache.org/docs/4.x/data-operate/import/import-way/streaming-job/schema-change-mysql/
MySQL Schema Change Sync - Apache Doris
Describes the supported schema changes and synchronization behavior of MySQL CDC Auto Table Creation Sync.
apache dorismysqlschemachangesync
https://docs.sync.cdata.com/26.3/ja/connections/destinations/apache-doris-destination
Apache Doris - CData Sync Documentation
apache doriscdatasyncdocumentation
https://doris.incubator.apache.org/zh-CN/docs/dev/sql-manual/sql-functions/scalar-functions/map-functions/deduplicate-map/
DEDUPLICATE_MAP - Apache Doris
去掉 Map 中的重复 key。 默认情况下 Doris 会对生成的 Map （比如在导入数据的时候）去重。 但是某些特殊场景得到的 Map 可能是未去重的，比如从外表读取的数据，比如从字符串转换为 Map 类型。 可以使用该函数对 Map 类型去重。
apache dorisdeduplicatemap
https://doris.incubator.apache.org/docs/dev/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-empty/
BITMAP_EMPTY - Apache Doris
Construct an empty BITMAP. Mainly used to fill default values during insert or stream load. For example:
apache dorisbitmapempty
https://doris.incubator.apache.org/docs/3.x/sql-manual/basic-element/operators/bitwise-operators/
Bitwise Operators - Apache Doris
Bitwise operators perform specified operations on one or two expressions at the bit level. These operators only accept arguments of the BIGINT type.
bitwise operatorsapache doris
https://doris.apache.org/zh-CN/docs/2.1/sql-manual/sql-statements/plugin/SHOW-PLUGINS/
SHOW PLUGINS - Apache Doris
apache dorisshowplugins
https://doris.apache.org/docs/4.x/sql-manual/sql-functions/scalar-functions/map-functions/deduplicate-map/
DEDUPLICATE_MAP - Apache Doris
Removes duplicate keys from a Map. By default, Doris deduplicates generated Maps (such as when importing data). However,
apache dorisdeduplicatemap
https://doris.incubator.apache.org/zh-CN/docs/4.x/lakehouse/meta-cache/
元数据缓存 - Apache Doris
为了提升访问外部数据源的性能，Apache Doris 会对外部数据源的元数据进行缓存。
apache doris
https://doris.apache.org/zh-CN/docs/4.x/lakehouse/catalogs/delta-lake-catalog/
Delta Lake Catalog - Apache Doris
Apache Doris Delta Lake Catalog 使用指南：通过 Trino Connector 框架连接 Delta Lake 数据湖，实现 Delta Lake 表数据的查询和集成。支持 Hive Metastore、多种数据类型映射，快速完成 Delta Lake 与 Doris 的数据集成。
delta lakeapache doriscatalog
https://doris.incubator.apache.org/docs/dev/data-operate/import/data-source/migrate-data-from-other-oltp/
Migrating Data from Other TP Systems - Apache Doris
How to migrate data from OLTP systems such as MySQL, SQL Server, Oracle, and PostgreSQL into Apache Doris, covering both offline and real-time synchronization...
apache dorismigratingdatasystems
https://doris.apache.org/docs/2.1/data-operate/update/update-of-aggregate-model/
Updating Data on Aggregate Key Model - Apache Doris
This document primarily introduces how to update the Doris Aggregate model based on data load.
on aggregateapache dorisupdatingdatakey
https://doris.incubator.apache.org/zh-CN/docs/dev/sql-manual/sql-statements/data-modification/load-and-export/CREATE-ROUTINE-LOAD/
CREATE ROUTINE LOAD - Apache Doris
例行导入（Routine Load）功能支持用户提交一个常驻的导入任务，通过不断地从指定的数据源读取数据，将数据导入到 Doris 中。
apache doriscreateroutineload
https://doris.incubator.apache.org/zh-CN/docs/2.1/admin-manual/workload-management/resource-group/
Resource Group - Apache Doris
Resource Group 是存算一体架构下，实现不同的负载之间物理隔离的一种机制，它的基本原理如下图所示：
apache dorisresourcegroup
https://doris.apache.org/zh-CN/docs/2.1/sql-manual/sql-statements/table-and-view/async-materialized-view/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW/
SHOW CREATE ASYNC MATERIALIZED VIEW - Apache Doris
materialized viewapache dorisshowcreateasync
https://doris.apache.org/zh-CN/docs/4.x/sql-manual/sql-functions/table-functions/explode-bitmap/
EXPLODE_BITMAP - Apache Doris
explodebitmap 表函数，接受一个位图（bitmap）类型的数据，将位图中的每个 bit（位）映射为单独的行。 通常用于处理位图数据，将位图中的每个元素展开成单独的记录。需配合 LATERAL VIEW 使用。 explodebitmapouter 与 explodebitmap 类似，
apache dorisexplodebitmap
https://doris.apache.org/docs/4.x/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX/
CREATE INDEX - Apache Doris
Create a new index on a table. The table name and index name must be specified. Optionally, you can specify the index type, properties, and comments.
create indexapache doris
https://doris.apache.org/docs/dev/connection-integration/data-integration/flink-doris-connector/cdc-sync/
Full-Database Sync (Flink CDC) - Apache Doris
Sync MySQL, Oracle, PostgreSQL, SQLServer, DB2, and MongoDB databases to Doris with Flink Doris Connector: the full-database sync tool, single-table sync with...
apache dorisfulldatabasesyncflink
https://doris.apache.org/zh-CN/docs/dev/sql-manual/sql-functions/scalar-functions/array-functions/array-first/
ARRAY_FIRST - Apache Doris
返回数组中第一个满足 lambda 表达式条件的元素。函数会对数组中的元素应用 lambda 表达式，找到第一个满足条件的元素并返回。
apache dorisarrayfirst
https://doris.apache.org/zh-CN/docs/4.x/sql-manual/sql-functions/aggregate-functions/sum/
SUM - Apache Doris
apache dorissum
https://doris.apache.org/blog/release-note-2.0.15/
Apache Doris version 2.0.15 has been released - Apache Doris
Sep 30, 2024 - Thanks to our community users and developers, about 157 improvements and bug fixes have been made in Doris 2.0.15 version
apache dorishas beenversionreleased
https://doris-forum.org.cn/questions/D1lC4/lian-jie-bao-cuo
spring AI连接doris mcp server报错 - Apache Doris 中文技术论坛
apache dorisspringmcp
https://doris.apache.org/zh-CN/docs/dev/sql-manual/sql-statements/data-query/SELECT/
SELECT - Apache Doris
apache dorisselect
https://doris-forum.org.cn/questions/D1PY3/de-shi-yong-wen-ti
doris的group commit使用问题 - Apache Doris 中文技术论坛
背景：项目中是使用mysql协议直接连接doris，发现保存数据时，insert into mytable values ..语句执行效率和mysql库相差较大，所以想试试group commit配置。...
apache doris
https://doris.incubator.apache.org/docs/dev/sql-manual/sql-functions/scalar-functions/string-functions/mask/
MASK - Apache Doris
The MASK function is used to mask data to protect sensitive information. The default behavior is to convert uppercase letters to X,
apache dorismask
https://doris.incubator.apache.org/zh-CN/docs/2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/months-sub/
MONTHS_SUB - Apache Doris
MONTHSSUB 函数用于对指定日期添加或减去指定的月份数，并返回计算后的新日期
apache dorismonthssub
https://doris.incubator.apache.org/zh-CN/docs/3.x/sql-manual/sql-statements/table-and-view/view/ALTER-VIEW/
ALTER VIEW - Apache Doris
apache dorisalterview
https://doris.incubator.apache.org/docs/3.x/sql-manual/sql-functions/aggregate-functions/bitmap-union-int/
BITMAP-UNION-INT - Apache Doris
Counts the number of distinct values in columns of type TINYINT, SMALLINT and INT. The return value is the same as COUNT(DISTINCT expr)
apache dorisbitmapunionint
https://doris.apache.org/zh-CN/docs/dev/sql-manual/sql-functions/scalar-functions/date-time-functions/hours-sub/
HOURS_SUB - Apache Doris
HOURS_SUB 函数用于从输入的日期或日期时间值中减去指定的小时数，并返回计算后的新日期时间。该函数支持 DATE, DATETIME, TIMESTAMP_NS 和 TIMESTAMPTZ 作为输入类型，若输入为 DATE 类型（仅包含年月日），会默认其时间部分为 00:00:00 转换为 DATETIME...
apache dorishourssub
https://doris.apache.org/docs/dev/key-features/hybrid-search/
Hybrid Search - Apache Doris
Apache Doris combines full-text matching and vector similarity in one SQL query on one table, with no separate search cluster to run.
hybrid searchapache doris
