Dear All??
For the current official documents, the structure is not clear, it is difficult for users to find the content they want, and there is also a lack of content, such as: easy to use and quickly experience the content of Doris, the best practice of each function, etc., so in order to cooperate with the official website change . This is just my personal thought and combined with the problems frequently encountered by users in the community, I organized it, and sent it out for everyone to discuss and improve. I have organized the official documents, the specific content is as follows. The overall content is divided into 11 parts: 1. Quick start: mainly to allow users to quickly complete the Doris experience through this document, from installation, connection, table building, query analysis, etc. 2.Doris architecture: divided into two parts of the basic concept and system architecture of Doris. Let users have a comprehensive and systematic understanding of Doris?? 3. Installation and deployment: This is divided into the installation and deployment of traditional physical machines or virtual machines (distributed environment), and the installation and deployment of Docker, as well as how to compile the source code of Doris, including Docker compilation, bare metal compilation and ARM platform compilation?? 4. Data table design: mainly to explain the data model and use of Doris, data distribution and index of Doris. 5. Data operation: This section mainly explains Doris's data import, data export, and data update and deletion. The data import is organized according to the data source, which makes it easier for users to choose the best data import method in combination with their own data sources. 6. Advanced use: Here are some advanced features of Doris, including materialized views, dynamic partitions, schema changes, data caching, variable and time zone settings, the use of BITMAP and HLL, etc. 7. Ecological expansion: mainly introduces the use of various ecological components around Doris. 8. SQL Manual: This part mainly includes two parts, Doris function and SQL reference?? 9. Management manual: mainly documents on cluster management, including cluster upgrade, high availability, elastic expansion and contraction, data management, operation and maintenance monitoring, configuration management, user and authority management, multi-tenancy and resource division, LDAP, etc. 10. Common problems: divided into three categories: operation and maintenance problems, data operation problems, and SQL problems, which is convenient for users to quickly find and locate 11. Performance test: mainly the use of SSB, TPC-H test tools and related test reports For example, in Chinese, the directory structure is as follows?? ?????? zh-CN ?????? README.md ?????? admin-manual ?? ?????? cluster-admin ?? ?? ?????? doris-ha.md ?? ?????? config ?? ?? ?????? be-config.md ?? ?? ?????? fe-config.md ?? ?? ?????? user-property.md ?? ?????? data-admin ?? ?? ?????? backup.md ?? ?? ?????? delete-recover.md ?? ?? ?????? restore.md ?? ?????? elastic-expansion.md ?? ?????? ldap.md ?? ?????? maint-monitor ?? ?? ?????? be-olap-error-code.md ?? ?? ?????? disk-capacity.md ?? ?? ?????? doris-error-code.md ?? ?? ?????? metadata-operation.md ?? ?? ?????? monitor-alert.md ?? ?? ?????? monitor-metrics ?? ?? ?? ?????? be-metrics.md ?? ?? ?? ?????? fe-metrics.md ?? ?? ?????? tablet-meta-tool.md ?? ?? ?????? tablet-repair-and-balance.md ?? ?? ?????? tablet-restore-tool.md ?? ?????? multi-tenant.md ?? ?????? optimization.md ?? ?????? query-profile.md ?? ?????? upgrade.md ?? ?????? user-privilege.md ?????? advanced ?? ?????? bucket-shuffle-join.md ?? ?????? cache ?? ?? ?????? partition-cache.md ?? ?? ?????? query-cache.md ?? ?????? colocation-join.md ?? ?????? materialized-view.md ?? ?????? orthogonal-bitmap-manual.md ?? ?????? orthogonal-hll-manual.md ?? ?????? partition ?? ?? ?????? dynamic-partition.md ?? ?? ?????? table-tmp-partition.md ?? ?????? runtime-filter.md ?? ?????? schema-change.md ?? ?????? small-file-mgr.md ?? ?????? time-zone.md ?? ?????? variables.md ?????? benchmark ?? ?????? ssb.md ?? ?????? tpc-h.md ?????? data-operate ?? ?????? export ?? ?? ?????? export-manual.md ?? ?? ?????? export_with_mysql_dump.md ?? ?? ?????? outfile.md ?? ?????? import ?? ?? ?????? binlog-load-manual.md ?? ?? ?????? broker-load-manual.md ?? ?? ?????? external-storage-load.md ?? ?? ?????? external-table-load.md ?? ?? ?????? insert-into-manual.md ?? ?? ?????? jdbc-load.md ?? ?? ?????? kafka-load.md ?? ?? ?????? load-atomicity.md ?? ?? ?????? load-data-convert.md ?? ?? ?????? load-json-format.md ?? ?? ?????? load-manual.md ?? ?? ?????? load-strict-mode.md ?? ?? ?????? local-file-load.md ?? ?? ?????? rdbms-load.md ?? ?? ?????? routine-load-manual.md ?? ?? ?????? s3-load-manual.md ?? ?? ?????? spark-load-manual.md ?? ?? ?????? stream-load-manual.md ?? ?????? update-delete ?? ?????? delete-manual.md ?? ?????? sequence-column-manual.md ?? ?????? update.md ?????? data-table ?? ?????? advance-usage.md ?? ?????? basic-usage.md ?? ?????? best-practice.md ?? ?????? data-model.md ?? ?????? data-partition.md ?? ?????? hit-the-rollup.md ?? ?????? index ?? ?????? bitmap-index.md ?? ?????? bloomfilter.md ?? ?????? prefix-index.md ?????? doris-manager ?????? ecosystem ?? ?????? audit-plugin.md ?? ?????? datax.md ?? ?????? external-table ?? ?? ?????? doris-on-es.md ?? ?? ?????? hive-bitmap-udf.md ?? ?? ?????? hive-of-doris.md ?? ?? ?????? iceberg-of-doris.md ?? ?? ?????? odbc-of-doris.md ?? ?????? flink-doris-connector.md ?? ?????? logstash.md ?? ?????? plugin-development-manual.md ?? ?????? seatunnel ?? ?? ?????? flink-sink.md ?? ?? ?????? spark-sink.md ?? ?????? spark-doris-connector.md ?? ?????? udf ?? ?????? contribute-udf.md ?? ?????? native-user-defined-function.md ?? ?????? remote-user-defined-function.md ?????? faq ?? ?????? data-faq.md ?? ?????? install-faq.md ?? ?????? sql-faq.md ?????? get-starting ?? ?????? get-starting.md ?????? install ?? ?????? docker-install.md ?? ?????? install-deploy.md ?? ?????? source-install ?? ?????? compilation-arm.md ?? ?????? compilation-with-ldb-toolchain.md ?? ?????? compilation.md ?????? sql-manual ?? ?????? sql-functions ?? ?? ?????? aggregate-functions ?? ?? ?? ?????? approx_count_distinct.md ?? ?? ?? ?????? avg.md ?? ?? ?? ?????? bitmap_union.md ?? ?? ?? ?????? count.md ?? ?? ?? ?????? group_concat.md ?? ?? ?? ?????? hll_union_agg.md ?? ?? ?? ?????? max.md ?? ?? ?? ?????? min.md ?? ?? ?? ?????? percentile.md ?? ?? ?? ?????? percentile_approx.md ?? ?? ?? ?????? stddev.md ?? ?? ?? ?????? stddev_samp.md ?? ?? ?? ?????? sum.md ?? ?? ?? ?????? topn.md ?? ?? ?? ?????? var_samp.md ?? ?? ?? ?????? variance.md ?? ?? ?????? bitmap-functions ?? ?? ?? ?????? bitmap_and.md ?? ?? ?? ?????? bitmap_and_count.md ?? ?? ?? ?????? bitmap_and_not.md ?? ?? ?? ?????? bitmap_and_not_count.md ?? ?? ?? ?????? bitmap_contains.md ?? ?? ?? ?????? bitmap_empty.md ?? ?? ?? ?????? bitmap_from_string.md ?? ?? ?? ?????? bitmap_has_all.md ?? ?? ?? ?????? bitmap_has_any.md ?? ?? ?? ?????? bitmap_hash.md ?? ?? ?? ?????? bitmap_intersect.md ?? ?? ?? ?????? bitmap_max.md ?? ?? ?? ?????? bitmap_min.md ?? ?? ?? ?????? bitmap_not.md ?? ?? ?? ?????? bitmap_or.md ?? ?? ?? ?????? bitmap_or_count.md ?? ?? ?? ?????? bitmap_subset_in_range.md ?? ?? ?? ?????? bitmap_subset_limit.md ?? ?? ?? ?????? bitmap_to_string.md ?? ?? ?? ?????? bitmap_union.md ?? ?? ?? ?????? bitmap_xor.md ?? ?? ?? ?????? bitmap_xor_count.md ?? ?? ?? ?????? orthogonal_bitmap_intersect.md ?? ?? ?? ?????? orthogonal_bitmap_intersect_count.md ?? ?? ?? ?????? orthogonal_bitmap_union_count.md ?? ?? ?? ?????? sub_bitmap.md ?? ?? ?? ?????? to_bitmap.md ?? ?? ?????? bitwise-functions ?? ?? ?? ?????? bitand.md ?? ?? ?? ?????? bitnot.md ?? ?? ?? ?????? bitor.md ?? ?? ?? ?????? bitxor.md ?? ?? ?????? cast.md ?? ?? ?????? conditional-functions ?? ?? ?? ?????? case.md ?? ?? ?? ?????? coalesce.md ?? ?? ?? ?????? if.md ?? ?? ?? ?????? ifnull.md ?? ?? ?? ?????? nullif.md ?? ?? ?????? date-time-functions ?? ?? ?? ?????? convert_tz.md ?? ?? ?? ?????? curdate.md ?? ?? ?? ?????? current_timestamp.md ?? ?? ?? ?????? curtime.md ?? ?? ?? ?????? date_add.md ?? ?? ?? ?????? date_format.md ?? ?? ?? ?????? date_sub.md ?? ?? ?? ?????? datediff.md ?? ?? ?? ?????? day.md ?? ?? ?? ?????? dayname.md ?? ?? ?? ?????? dayofmonth.md ?? ?? ?? ?????? dayofweek.md ?? ?? ?? ?????? dayofyear.md ?? ?? ?? ?????? from_days.md ?? ?? ?? ?????? from_unixtime.md ?? ?? ?? ?????? hour.md ?? ?? ?? ?????? makedate.md ?? ?? ?? ?????? minute.md ?? ?? ?? ?????? month.md ?? ?? ?? ?????? monthname.md ?? ?? ?? ?????? now.md ?? ?? ?? ?????? second.md ?? ?? ?? ?????? str_to_date.md ?? ?? ?? ?????? time_round.md ?? ?? ?? ?????? timediff.md ?? ?? ?? ?????? timestampadd.md ?? ?? ?? ?????? timestampdiff.md ?? ?? ?? ?????? to_date.md ?? ?? ?? ?????? to_days.md ?? ?? ?? ?????? unix_timestamp.md ?? ?? ?? ?????? utc_timestamp.md ?? ?? ?? ?????? week.md ?? ?? ?? ?????? weekday.md ?? ?? ?? ?????? weekofyear.md ?? ?? ?? ?????? year.md ?? ?? ?? ?????? yearweek.md ?? ?? ?????? digital-masking.md ?? ?? ?????? encrypt-digest-functions ?? ?? ?? ?????? aes.md ?? ?? ?? ?????? md5.md ?? ?? ?? ?????? md5sum.md ?? ?? ?? ?????? sm3.md ?? ?? ?? ?????? sm3sum.md ?? ?? ?? ?????? sm4.md ?? ?? ?????? hash-functions ?? ?? ?? ?????? murmur_hash3_32.md ?? ?? ?????? json-functions ?? ?? ?? ?????? get_json_double.md ?? ?? ?? ?????? get_json_int.md ?? ?? ?? ?????? get_json_string.md ?? ?? ?? ?????? json_array.md ?? ?? ?? ?????? json_object.md ?? ?? ?? ?????? json_quote.md ?? ?? ?????? math-functions ?? ?? ?? ?????? conv.md ?? ?? ?? ?????? pmod.md ?? ?? ?????? spatial-functions ?? ?? ?? ?????? st_astext.md ?? ?? ?? ?????? st_circle.md ?? ?? ?? ?????? st_contains.md ?? ?? ?? ?????? st_distance_sphere.md ?? ?? ?? ?????? st_geometryfromtext.md ?? ?? ?? ?????? st_linefromtext.md ?? ?? ?? ?????? st_point.md ?? ?? ?? ?????? st_polygon.md ?? ?? ?? ?????? st_x.md ?? ?? ?? ?????? st_y.md ?? ?? ?????? string-functions ?? ?? ?? ?????? append_trailing_char_if_absent.md ?? ?? ?? ?????? ascii.md ?? ?? ?? ?????? bit_length.md ?? ?? ?? ?????? char_length.md ?? ?? ?? ?????? concat.md ?? ?? ?? ?????? concat_ws.md ?? ?? ?? ?????? ends_with.md ?? ?? ?? ?????? find_in_set.md ?? ?? ?? ?????? hex.md ?? ?? ?? ?????? instr.md ?? ?? ?? ?????? lcase.md ?? ?? ?? ?????? left.md ?? ?? ?? ?????? length.md ?? ?? ?? ?????? like ?? ?? ?? ?????? locate.md ?? ?? ?? ?????? lower.md ?? ?? ?? ?????? lpad.md ?? ?? ?? ?????? ltrim.md ?? ?? ?? ?????? money_format.md ?? ?? ?? ?????? null_or_empty.md ?? ?? ?? ?????? regexp ?? ?? ?? ?????? repeat.md ?? ?? ?? ?????? replace.md ?? ?? ?? ?????? reverse.md ?? ?? ?? ?????? right.md ?? ?? ?? ?????? rpad.md ?? ?? ?? ?????? split_part.md ?? ?? ?? ?????? starts_with.md ?? ?? ?? ?????? strleft.md ?? ?? ?? ?????? strright.md ?? ?? ?? ?????? substring.md ?? ?? ?? ?????? unhex.md ?? ?? ?????? table-functions ?? ?? ?? ?????? explode-bitmap.md ?? ?? ?? ?????? explode-json-array.md ?? ?? ?? ?????? explode-split.md ?? ?? ?????? window-function.md ?? ?????? sql-reference ?? ?????? Account\ Management ?? ?? ?????? CREATE\ ROLE.md ?? ?? ?????? CREATE\ USER.md ?? ?? ?????? DROP\ ROLE.md ?? ?? ?????? DROP\ USER.md ?? ?? ?????? GRANT.md ?? ?? ?????? REVOKE.md ?? ?? ?????? SET\ PASSWORD.md ?? ?? ?????? SET\ PROPERTY.md ?? ?? ?????? SHOW\ GRANTS.md ?? ?? ?????? SHOW\ ROLES.md ?? ?????? Administration ?? ?? ?????? ADMIN\ CANCEL\ REPAIR.md ?? ?? ?????? ADMIN\ CHECK\ TABLET.md ?? ?? ?????? ADMIN\ CLEAN\ TRASH.md ?? ?? ?????? ADMIN\ COMPACT.md ?? ?? ?????? ADMIN\ REPAIR.md ?? ?? ?????? ADMIN\ SET\ CONFIG.md ?? ?? ?????? ADMIN\ SET\ REPLICA\ STATUS.md ?? ?? ?????? ADMIN\ SHOW\ CONFIG.md ?? ?? ?????? ADMIN\ SHOW\ REPLICA\ DISTRIBUTION.md ?? ?? ?????? ADMIN\ SHOW\ REPLICA\ STATUS.md ?? ?? ?????? ALTER\ CLUSTER.md ?? ?? ?????? ALTER\ SYSTEM.md ?? ?? ?????? CANCEL\ DECOMMISSION.md ?? ?? ?????? CREATE\ CLUSTER.md ?? ?? ?????? CREATE\ FILE.md ?? ?? ?????? DROP\ CLUSTER.md ?? ?? ?????? DROP\ FILE.md ?? ?? ?????? ENTER.md ?? ?? ?????? INSTALL\ PLUGIN.md ?? ?? ?????? LINK\ DATABASE.md ?? ?? ?????? MIGRATE\ DATABASE.md ?? ?? ?????? SET\ LDAP_ADMIN_PASSWORD.md ?? ?? ?????? SHOW\ BACKENDS.md ?? ?? ?????? SHOW\ BROKER.md ?? ?? ?????? SHOW\ FILE.md ?? ?? ?????? SHOW\ FRONTENDS.md ?? ?? ?????? SHOW\ FULL\ COLUMNS.md ?? ?? ?????? SHOW\ INDEX.md ?? ?? ?????? SHOW\ MIGRATIONS.md ?? ?? ?????? SHOW\ PLUGINS.md ?? ?? ?????? SHOW\ TABLE\ STATUS.md ?? ?? ?????? SHOW\ TRASH.md ?? ?? ?????? SHOW\ VIEW.md ?? ?? ?????? UNINSTALL\ PLUGIN.md ?? ?????? Data\ Definition ?? ?? ?????? ALTER\ DATABASE.md ?? ?? ?????? ALTER\ TABLE.md ?? ?? ?????? ALTER\ VIEW.md ?? ?? ?????? BACKUP.md ?? ?? ?????? CANCEL\ ALTER.md ?? ?? ?????? CANCEL\ BACKUP.md ?? ?? ?????? CANCEL\ RESTORE.md ?? ?? ?????? CREATE\ DATABASE.md ?? ?? ?????? CREATE\ ENCRYPTKEY.md ?? ?? ?????? CREATE\ INDEX.md ?? ?? ?????? CREATE\ MATERIALIZED\ VIEW.md ?? ?? ?????? CREATE\ REPOSITORY.md ?? ?? ?????? CREATE\ RESOURCE.md ?? ?? ?????? CREATE\ TABLE\ LIKE.md ?? ?? ?????? CREATE\ TABLE.md ?? ?? ?????? CREATE\ VIEW.md ?? ?? ?????? DROP\ DATABASE.md ?? ?? ?????? DROP\ ENCRYPTKEY.md ?? ?? ?????? DROP\ INDEX.md ?? ?? ?????? DROP\ MATERIALIZED\ VIEW.md ?? ?? ?????? DROP\ REPOSITORY.md ?? ?? ?????? DROP\ RESOURCE.md ?? ?? ?????? DROP\ TABLE.md ?? ?? ?????? DROP\ VIEW.md ?? ?? ?????? HLL.md ?? ?? ?????? RECOVER.md ?? ?? ?????? REFRESH\ DATABASE.md ?? ?? ?????? REFRESH\ TABLE.md ?? ?? ?????? RESTORE.md ?? ?? ?????? SHOW\ ENCRYPTKEYS.md ?? ?? ?????? SHOW\ RESOURCES.md ?? ?? ?????? TRUNCATE\ TABLE.md ?? ?? ?????? create-function.md ?? ?? ?????? drop-function.md ?? ?? ?????? show-functions.md ?? ?????? Data\ Manipulation ?? ?? ?????? BEGIN.md ?? ?? ?????? BROKER\ LOAD.md ?? ?? ?????? CANCEL\ LOAD.md ?? ?? ?????? CREATE\ SYNC\ JOB.md ?? ?? ?????? DELETE.md ?? ?? ?????? EXPORT.md ?? ?? ?????? GROUP\ BY.md ?? ?? ?????? LOAD.md ?? ?? ?????? MINI\ LOAD.md ?? ?? ?????? MULTI\ LOAD.md ?? ?? ?????? OUTFILE.md ?? ?? ?????? PAUSE\ ROUTINE\ LOAD.md ?? ?? ?????? PAUSE\ SYNC\ JOB.md ?? ?? ?????? RESUME\ ROUTINE\ LOAD.md ?? ?? ?????? RESUME\ SYNC\ JOB.md ?? ?? ?????? ROUTINE\ LOAD.md ?? ?? ?????? SHOW\ ALTER.md ?? ?? ?????? SHOW\ BACKUP.md ?? ?? ?????? SHOW\ CREATE\ FUNCTION.md ?? ?? ?????? SHOW\ CREATE\ ROUTINE\ LOAD.md ?? ?? ?????? SHOW\ DATA\ SKEW.md ?? ?? ?????? SHOW\ DATA.md ?? ?? ?????? SHOW\ DATABASE\ ID.md ?? ?? ?????? SHOW\ DATABASES.md ?? ?? ?????? SHOW\ DELETE.md ?? ?? ?????? SHOW\ DYNAMIC\ PARTITION\ TABLES.md ?? ?? ?????? SHOW\ EXPORT.md ?? ?? ?????? SHOW\ LOAD.md ?? ?? ?????? SHOW\ PARTITION\ ID.md ?? ?? ?????? SHOW\ PARTITIONS.md ?? ?? ?????? SHOW\ PROPERTY.md ?? ?? ?????? SHOW\ REPOSITORIES.md ?? ?? ?????? SHOW\ RESTORE.md ?? ?? ?????? SHOW\ ROUTINE\ LOAD\ TASK.md ?? ?? ?????? SHOW\ ROUTINE\ LOAD.md ?? ?? ?????? SHOW\ SNAPSHOT.md ?? ?? ?????? SHOW\ STREAM\ LOAD.md ?? ?? ?????? SHOW\ SYNC\ JOB.md ?? ?? ?????? SHOW\ TABLE\ CREATION.md ?? ?? ?????? SHOW\ TABLE\ ID.md ?? ?? ?????? SHOW\ TABLES.md ?? ?? ?????? SHOW\ TABLET.md ?? ?? ?????? SHOW\ TABLETS.md ?? ?? ?????? SHOW\ TRANSACTION.md ?? ?? ?????? SHOW-LAST-INSERT.md ?? ?? ?????? SPARK\ LOAD.md ?? ?? ?????? STOP\ ROUTINE\ LOAD.md ?? ?? ?????? STOP\ SYNC\ JOB.md ?? ?? ?????? STREAM\ LOAD.md ?? ?? ?????? UPDATE.md ?? ?? ?????? alter-routine-load.md ?? ?? ?????? insert.md ?? ?? ?????? lateral-view.md ?? ?????? Data\ Types ?? ?? ?????? BIGINT.md ?? ?? ?????? BITMAP.md ?? ?? ?????? BOOLEAN.md ?? ?? ?????? CHAR.md ?? ?? ?????? DATE.md ?? ?? ?????? DATETIME.md ?? ?? ?????? DECIMAL.md ?? ?? ?????? DOUBLE.md ?? ?? ?????? FLOAT.md ?? ?? ?????? HLL.md ?? ?? ?????? INT.md ?? ?? ?????? LARGEINT.md ?? ?? ?????? SMALLINT.md ?? ?? ?????? STRING.md ?? ?? ?????? TINYINT.md ?? ?? ?????? VARCHAR.md ?? ?????? Utility ?? ?????? DESCRIBE.md ?????? summary ?????? basic-summary.md ?????? system-architecture.md