> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Landing page for Regular Functions

# Regular functions

| Page                                                                                    | Description                                                                                                                     |
| --------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------- |
| [Overview](/reference/functions/regular-functions/overview)                             | Overview of all functions.                                                                                                      |
| [Machine Learning](/reference/functions/regular-functions/machine-learning-functions)   | Functions for machine learning.                                                                                                 |
| [Introspection](/reference/functions/regular-functions/introspection)                   | Functions for introspection of ClickHouse.                                                                                      |
| [arrayJoin](/reference/functions/regular-functions/array-join)                          | The arrayJoin function which takes each row and generates a set of rows (unfold)                                                |
| [Searching in Strings](/reference/functions/regular-functions/string-search-functions)  | Functions for searching within strings.                                                                                         |
| [Hash](/reference/functions/regular-functions/hash-functions)                           | Hashing functions.                                                                                                              |
| [UUIDs](/reference/functions/regular-functions/uuid-functions)                          | Functions for Working with UUIDs.                                                                                               |
| [Time-Series](/reference/functions/regular-functions/time-series-functions)             | Functions for working with time series                                                                                          |
| [Random Numbers](/reference/functions/regular-functions/random-functions)               | Functions for random number generation.                                                                                         |
| [NLP](/reference/functions/regular-functions/nlp-functions)                             | Functions for Natural Language Processing.                                                                                      |
| [Conditional](/reference/functions/regular-functions/conditional-functions)             | Conditional functions.                                                                                                          |
| [Nullable](/reference/functions/regular-functions/functions-for-nulls)                  | Functions for working with NULL.                                                                                                |
| [Bit](/reference/functions/regular-functions/bit-functions)                             | Bitwise functions.                                                                                                              |
| [Time Window](/reference/functions/regular-functions/time-window-functions)             | Functions which return the inclusive lower and exclusive upper bound of the corresponding window.                               |
| [IP Address](/reference/functions/regular-functions/ip-address-functions)               | Functions for Working with IPv4 and IPv6 Addresses.                                                                             |
| [Splitting Strings](/reference/functions/regular-functions/splitting-merging-functions) | Functions for splitting strings.                                                                                                |
| [Tuples](/reference/functions/regular-functions/tuple-functions)                        | Functions for working with tuples.                                                                                              |
| [String replacement](/reference/functions/regular-functions/string-replace-functions)   | Functions for string replacement.                                                                                               |
| [User Defined Functions](/reference/functions/regular-functions/udf)                    | User Defined Functions.                                                                                                         |
| [Comparison](/reference/functions/regular-functions/comparison-functions)               | Comparison functions (equals, less, greater etc.)                                                                               |
| [Other](/reference/functions/regular-functions/other-functions)                         | Functions which don't fit into any other category.                                                                              |
| [JSON](/reference/functions/regular-functions/json-functions)                           | Functions for working with JSON.                                                                                                |
| [URL](/reference/functions/regular-functions/url-functions)                             | Functions for working with URLs.                                                                                                |
| [Encoding](/reference/functions/regular-functions/encoding-functions)                   | Functions for encoding data.                                                                                                    |
| [ULID](/reference/functions/regular-functions/ulid-functions)                           | Functions for Working with ULID.                                                                                                |
| [Maps](/reference/functions/regular-functions/tuple-map-functions)                      | Functions for working with Maps.                                                                                                |
| [Dictionaries](/reference/functions/regular-functions/ext-dict-functions)               | Functions for working with dictionaries.                                                                                        |
| [IN](/reference/functions/regular-functions/in-functions)                               | IN operators                                                                                                                    |
| [Files](/reference/functions/regular-functions/files)                                   | The file function.                                                                                                              |
| [Arrays](/reference/functions/regular-functions/array-functions)                        | Functions for working with arrays.                                                                                              |
| [String](/reference/functions/regular-functions/string-functions)                       | Functions for working with Strings. (Functions for searching in strings and for replacing in strings are described separately.) |
| [DateTime](/reference/functions/regular-functions/date-time-functions)                  | Functions for working with dates and times.                                                                                     |
| [Logical](/reference/functions/regular-functions/logical-functions)                     | Functions which perform logical operations on arguments of arbitrary numeric types.                                             |
| [Rounding](/reference/functions/regular-functions/rounding-functions)                   | Functions for rounding.                                                                                                         |
| [uniqTheta](/reference/functions/regular-functions/uniqtheta-functions)                 | uniqTheta functions work on two uniqThetaSketch objects to do set operation calculations such as ∪ / ∩ / ×.                     |
| [Distance](/reference/functions/regular-functions/distance-functions)                   | Functions for calculating vector norms, distances, normalization, and common operations in linear algebra and machine learning. |
| [Bitmap](/reference/functions/regular-functions/bitmap-functions)                       | Functions for bitmaps.                                                                                                          |
| [Math](/reference/functions/regular-functions/math-functions)                           | Mathematical functions.                                                                                                         |
| [Financial](/reference/functions/regular-functions/financial-functions)                 | Financial functions.                                                                                                            |
| [Encryption](/reference/functions/regular-functions/encryption-functions)               | Functions for encryption.                                                                                                       |
| [Arithmetic](/reference/functions/regular-functions/arithmetic-functions)               | Functions for performing arithmetic on `UInt`, `Int` or `Float` types.                                                          |
| [Embedded Dictionaries](/reference/functions/regular-functions/embedded-dict-functions) | Functions for Working with Embedded Dictionaries                                                                                |
| [Type Conversion](/reference/functions/regular-functions/type-conversion-functions)     | Functions for converting from one type to another type.                                                                         |