You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@doris.apache.org by 41108453 <41...@qq.com.INVALID> on 2022/03/22 09:58:25 UTC
DICUSSION]Doris official document refactoring

Dear All，


&nbsp; &nbsp; &nbsp;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 .
&nbsp; &nbsp; 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.
&nbsp; &nbsp; I have organized the official documents, the specific content is as follows.
&nbsp; &nbsp; &nbsp;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
&nbsp; &nbsp; ├── README.md
&nbsp; &nbsp; ├── admin-manual
&nbsp; &nbsp; │&nbsp; &nbsp;├── cluster-admin
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;└── doris-ha.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── config
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── be-config.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── fe-config.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;└── user-property.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── data-admin
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── backup.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── delete-recover.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;└── restore.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── elastic-expansion.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── ldap.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── maint-monitor
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── be-olap-error-code.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── disk-capacity.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── doris-error-code.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── metadata-operation.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── monitor-alert.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── monitor-metrics
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── be-metrics.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── fe-metrics.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── tablet-meta-tool.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── tablet-repair-and-balance.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;└── tablet-restore-tool.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── multi-tenant.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── optimization.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── query-profile.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── upgrade.md
&nbsp; &nbsp; │&nbsp; &nbsp;└── user-privilege.md
&nbsp; &nbsp; ├── advanced
&nbsp; &nbsp; │&nbsp; &nbsp;├── bucket-shuffle-join.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── cache
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── partition-cache.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;└── query-cache.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── colocation-join.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── materialized-view.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── orthogonal-bitmap-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── orthogonal-hll-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── partition
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── dynamic-partition.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;└── table-tmp-partition.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── runtime-filter.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── schema-change.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── small-file-mgr.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── time-zone.md
&nbsp; &nbsp; │&nbsp; &nbsp;└── variables.md
&nbsp; &nbsp; ├── benchmark
&nbsp; &nbsp; │&nbsp; &nbsp;├── ssb.md
&nbsp; &nbsp; │&nbsp; &nbsp;└── tpc-h.md
&nbsp; &nbsp; ├── data-operate
&nbsp; &nbsp; │&nbsp; &nbsp;├── export
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── export-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── export_with_mysql_dump.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;└── outfile.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── import
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── binlog-load-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── broker-load-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── external-storage-load.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── external-table-load.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── insert-into-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── jdbc-load.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── kafka-load.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── load-atomicity.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── load-data-convert.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── load-json-format.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── load-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── load-strict-mode.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── local-file-load.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── rdbms-load.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── routine-load-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── s3-load-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── spark-load-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;└── stream-load-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp;└── update-delete
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── delete-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── sequence-column-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;└── update.md
&nbsp; &nbsp; ├── data-table
&nbsp; &nbsp; │&nbsp; &nbsp;├── advance-usage.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── basic-usage.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── best-practice.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── data-model.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── data-partition.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── hit-the-rollup.md
&nbsp; &nbsp; │&nbsp; &nbsp;└── index
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── bitmap-index.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── bloomfilter.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;└── prefix-index.md
&nbsp; &nbsp; ├── doris-manager
&nbsp; &nbsp; ├── ecosystem
&nbsp; &nbsp; │&nbsp; &nbsp;├── audit-plugin.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── datax.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── external-table
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── doris-on-es.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── hive-bitmap-udf.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── hive-of-doris.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── iceberg-of-doris.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;└── odbc-of-doris.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── flink-doris-connector.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── logstash.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── plugin-development-manual.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── seatunnel
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── flink-sink.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;└── spark-sink.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── spark-doris-connector.md
&nbsp; &nbsp; │&nbsp; &nbsp;└── udf
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── contribute-udf.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── native-user-defined-function.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;└── remote-user-defined-function.md
&nbsp; &nbsp; ├── faq
&nbsp; &nbsp; │&nbsp; &nbsp;├── data-faq.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── install-faq.md
&nbsp; &nbsp; │&nbsp; &nbsp;└── sql-faq.md
&nbsp; &nbsp; ├── get-starting
&nbsp; &nbsp; │&nbsp; &nbsp;└── get-starting.md
&nbsp; &nbsp; ├── install
&nbsp; &nbsp; │&nbsp; &nbsp;├── docker-install.md
&nbsp; &nbsp; │&nbsp; &nbsp;├── install-deploy.md
&nbsp; &nbsp; │&nbsp; &nbsp;└── source-install
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── compilation-arm.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── compilation-with-ldb-toolchain.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;└── compilation.md
&nbsp; &nbsp; ├── sql-manual
&nbsp; &nbsp; │&nbsp; &nbsp;├── sql-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── aggregate-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── approx_count_distinct.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── avg.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_union.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── count.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── group_concat.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── hll_union_agg.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── max.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── min.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── percentile.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── percentile_approx.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── stddev.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── stddev_samp.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── sum.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── topn.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── var_samp.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── variance.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_and.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_and_count.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_and_not.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_and_not_count.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_contains.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_empty.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_from_string.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_has_all.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_has_any.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_hash.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_intersect.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_max.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_min.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_not.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_or.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_or_count.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_subset_in_range.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_subset_limit.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_to_string.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_union.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_xor.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitmap_xor_count.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── orthogonal_bitmap_intersect.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── orthogonal_bitmap_intersect_count.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── orthogonal_bitmap_union_count.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── sub_bitmap.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── to_bitmap.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── bitwise-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitand.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitnot.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bitor.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── bitxor.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── cast.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── conditional-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── case.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── coalesce.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── if.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── ifnull.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── nullif.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── date-time-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── convert_tz.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── curdate.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── current_timestamp.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── curtime.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── date_add.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── date_format.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── date_sub.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── datediff.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── day.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── dayname.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── dayofmonth.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── dayofweek.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── dayofyear.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── from_days.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── from_unixtime.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── hour.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── makedate.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── minute.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── month.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── monthname.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── now.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── second.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── str_to_date.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── time_round.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── timediff.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── timestampadd.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── timestampdiff.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── to_date.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── to_days.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── unix_timestamp.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── utc_timestamp.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── week.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── weekday.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── weekofyear.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── year.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── yearweek.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── digital-masking.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── encrypt-digest-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── aes.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── md5.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── md5sum.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── sm3.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── sm3sum.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── sm4.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── hash-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── murmur_hash3_32.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── json-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── get_json_double.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── get_json_int.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── get_json_string.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── json_array.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── json_object.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── json_quote.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── math-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── conv.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── pmod.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── spatial-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── st_astext.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── st_circle.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── st_contains.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── st_distance_sphere.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── st_geometryfromtext.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── st_linefromtext.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── st_point.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── st_polygon.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── st_x.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── st_y.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── string-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── append_trailing_char_if_absent.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── ascii.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── bit_length.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── char_length.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── concat.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── concat_ws.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── ends_with.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── find_in_set.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── hex.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── instr.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── lcase.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── left.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── length.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── like
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── locate.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── lower.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── lpad.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── ltrim.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── money_format.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── null_or_empty.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── regexp
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── repeat.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── replace.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── reverse.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── right.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── rpad.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── split_part.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── starts_with.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── strleft.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── strright.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── substring.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── unhex.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;├── table-functions
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── explode-bitmap.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;├── explode-json-array.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;│&nbsp; &nbsp;└── explode-split.md
&nbsp; &nbsp; │&nbsp; &nbsp;│&nbsp; &nbsp;└── window-function.md
&nbsp; &nbsp; │&nbsp; &nbsp;└── sql-reference
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── Account\ Management
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ ROLE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ USER.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DROP\ ROLE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DROP\ USER.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── GRANT.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── REVOKE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SET\ PASSWORD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SET\ PROPERTY.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ GRANTS.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;└── SHOW\ ROLES.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── Administration
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ADMIN\ CANCEL\ REPAIR.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ADMIN\ CHECK\ TABLET.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ADMIN\ CLEAN\ TRASH.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ADMIN\ COMPACT.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ADMIN\ REPAIR.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ADMIN\ SET\ CONFIG.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ADMIN\ SET\ REPLICA\ STATUS.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ADMIN\ SHOW\ CONFIG.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ADMIN\ SHOW\ REPLICA\ DISTRIBUTION.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ADMIN\ SHOW\ REPLICA\ STATUS.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ALTER\ CLUSTER.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ALTER\ SYSTEM.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CANCEL\ DECOMMISSION.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ CLUSTER.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ FILE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DROP\ CLUSTER.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DROP\ FILE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ENTER.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── INSTALL\ PLUGIN.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── LINK\ DATABASE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── MIGRATE\ DATABASE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SET\ LDAP_ADMIN_PASSWORD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ BACKENDS.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ BROKER.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ FILE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ FRONTENDS.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ FULL\ COLUMNS.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ INDEX.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ MIGRATIONS.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ PLUGINS.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ TABLE\ STATUS.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ TRASH.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ VIEW.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;└── UNINSTALL\ PLUGIN.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── Data\ Definition
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ALTER\ DATABASE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ALTER\ TABLE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ALTER\ VIEW.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── BACKUP.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CANCEL\ ALTER.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CANCEL\ BACKUP.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CANCEL\ RESTORE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ DATABASE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ ENCRYPTKEY.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ INDEX.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ MATERIALIZED\ VIEW.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ REPOSITORY.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ RESOURCE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ TABLE\ LIKE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ TABLE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ VIEW.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DROP\ DATABASE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DROP\ ENCRYPTKEY.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DROP\ INDEX.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DROP\ MATERIALIZED\ VIEW.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DROP\ REPOSITORY.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DROP\ RESOURCE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DROP\ TABLE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DROP\ VIEW.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── HLL.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── RECOVER.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── REFRESH\ DATABASE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── REFRESH\ TABLE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── RESTORE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ ENCRYPTKEYS.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ RESOURCES.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── TRUNCATE\ TABLE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── create-function.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── drop-function.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;└── show-functions.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── Data\ Manipulation
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── BEGIN.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── BROKER\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CANCEL\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CREATE\ SYNC\ JOB.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DELETE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── EXPORT.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── GROUP\ BY.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── MINI\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── MULTI\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── OUTFILE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── PAUSE\ ROUTINE\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── PAUSE\ SYNC\ JOB.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── RESUME\ ROUTINE\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── RESUME\ SYNC\ JOB.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── ROUTINE\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ ALTER.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ BACKUP.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ CREATE\ FUNCTION.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ CREATE\ ROUTINE\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ DATA\ SKEW.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ DATA.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ DATABASE\ ID.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ DATABASES.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ DELETE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ DYNAMIC\ PARTITION\ TABLES.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ EXPORT.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ PARTITION\ ID.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ PARTITIONS.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ PROPERTY.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ REPOSITORIES.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ RESTORE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ ROUTINE\ LOAD\ TASK.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ ROUTINE\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ SNAPSHOT.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ STREAM\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ SYNC\ JOB.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ TABLE\ CREATION.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ TABLE\ ID.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ TABLES.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ TABLET.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ TABLETS.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW\ TRANSACTION.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SHOW-LAST-INSERT.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SPARK\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── STOP\ ROUTINE\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── STOP\ SYNC\ JOB.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── STREAM\ LOAD.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── UPDATE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── alter-routine-load.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── insert.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;└── lateral-view.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;├── Data\ Types
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── BIGINT.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── BITMAP.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── BOOLEAN.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── CHAR.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DATE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DATETIME.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DECIMAL.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── DOUBLE.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── FLOAT.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── HLL.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── INT.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── LARGEINT.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── SMALLINT.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── STRING.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;├── TINYINT.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;│&nbsp; &nbsp;└── VARCHAR.md
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp;└── Utility
&nbsp; &nbsp; │&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;└── DESCRIBE.md
&nbsp; &nbsp; └── summary
&nbsp; &nbsp; &nbsp; &nbsp; ├── basic-summary.md
&nbsp; &nbsp; &nbsp; &nbsp; └── system-architecture.md