---
headless: true
---
- [Get Started]({{< relref "./docs/start/_index.md" >}})

- [Overview]({{< relref "./docs/overview/_index.md" >}})
    - [Use Cases]({{< relref "./docs/overview/use-cases.md" >}})
    - [openLooKeng Concepts]({{< relref "./docs/overview/concepts.md" >}})

- [Installation]({{< relref "./docs/installation/_index.md" >}})
    - [Deploying openLooKeng Manually]({{< relref "./docs/installation/deployment.md" >}})
    - [Deploying openLooKeng Automatically]({{< relref "./docs/installation/deployment-auto.md" >}})
    - [Command Line Interface]({{< relref "./docs/installation/cli.md" >}})
    - [JDBC Driver]({{< relref "./docs/installation/jdbc.md" >}})
    - [openLooKeng Verifier]({{< relref "./docs/installation/verifier.md" >}})
    - [Benchmark Driver]({{< relref "./docs/installation/benchmark-driver.md" >}})
    - [Web Connector for Tableau]({{< relref "./docs/installation/tableau.md" >}})
    - [Deploying openLooKeng with High Availability(HA)]({{< relref "./docs/installation/deployment-ha.md" >}})
    - [openLooKeng ODBC User Manual]({{< relref "./docs/installation/odbc.md" >}})

- [Security]("#")
    - [Coordinator Kerberos Authentication]({{< relref "./docs/security/server.md" >}})
    - [CLI Kerberos Authentication]({{< relref "./docs/security/cli.md" >}})
    - [LDAP Authentication]({{< relref "./docs/security/ldap.md" >}})
    - [Java Keystores and Truststores]({{< relref "./docs/security/tls.md" >}})
    - [Built-in System Access Control]({{< relref "./docs/security/built-in-system-access-control.md" >}})
    - [Ranger Access Control]({{< relref "./docs/security/ranger-access-control.md" >}})
    - [Secure Internal Communication]({{< relref "./docs/security/internal-communication.md" >}})
    - [Password Encryption]({{< relref "./docs/security/password-encryption.md" >}})
    - [HAZELCAST Authentication]({{< relref "./docs/security/hazelcast.md" >}})
- [Administration]("#")
    - [Web Interface]({{< relref "./docs/admin/web-interface.md" >}})
    - [Tuning openLooKeng]({{< relref "./docs/admin/tuning.md" >}})
    - [Properties Reference]({{< relref "./docs/admin/properties.md" >}})
    - [Spill to Disk]({{< relref "./docs/admin/spill.md" >}})
    - [Resource Groups]({{< relref "./docs/admin/resource-groups.md" >}})
    - [Session Property Managers]({{< relref "./docs/admin/session-property-managers.md" >}})
    - [Distributed Sort]({{< relref "./docs/admin/dist-sort.md" >}})
    - [Dynamic Catalog]({{< relref "./docs/admin/dynamic-catalog.md" >}})
    - [Horizontal Scaling]({{< relref "./docs/admin/horizontal-scaling.md" >}})
    - [Dynamic Filtering]({{< relref "./docs/admin/dynamic-filters.md" >}})
    - [Audit Log]({{< relref "./docs/admin/audit-log.md" >}})

- [Query Optimizer]("#")
    - [Table Statistics]({{< relref "./docs/optimizer/statistics.md" >}})
    - [Cost in EXPLAIN]({{< relref "./docs/optimizer/cost-in-explain.md" >}})
    - [Cost based optimizations]({{< relref "./docs/optimizer/cost-based-optimizations.md" >}})

- [Heuristic Indexer]("#")
    - [openLooKeng Heuristic Indexer]({{< relref "./docs/indexer/overview.md" >}})
    - [Index Command Line Interface]({{< relref "./docs/indexer/indexer-cli.md" >}})
    - [Bitmap Index]({{< relref "./docs/indexer/bitmap.md" >}})
    - [Minmax Index]({{< relref "./docs/indexer/minmax.md" >}})
    - [Bloom Index]({{< relref "./docs/indexer/bloom.md" >}})

- [Connectors]({{< relref "./docs/connector/_index.md" >}})
    - [Carbondata]({{< relref "./docs/connector/carbondata.md" >}})
    - [DataCenter]({{< relref "./docs/connector/datacenter.md" >}})
    - [Elasticsearch]({{< relref "./docs/connector/elasticsearch.md" >}})
    - [Hana]({{< relref "./docs/connector/hana.md" >}})
    - [HBase]({{< relref "./docs/connector/HBase.md" >}})
    - [Hive]({{< relref "./docs/connector/hive.md" >}})
    - [Hive Connector GCS Tutorial]({{< relref "./docs/connector/hive-gcs-tutorial.md" >}})
    - [Hive Security Configuration]({{< relref "./docs/connector/hive-security.md" >}})
    - [JMX]({{< relref "./docs/connector/jmx.md" >}})
    - [Kafka]({{< relref "./docs/connector/kafka.md" >}})
    - [Kafka Connector Tutorial]({{< relref "./docs/connector/kafka-tutorial.md" >}})
    - [Local File]({{< relref "./docs/connector/localfile.md" >}})
    - [Memory]({{< relref "./docs/connector/memory.md" >}})
    - [MySQL]({{< relref "./docs/connector/mysql.md" >}})
    - [PostgreSQL]({{< relref "./docs/connector/postgresql.md" >}})
    - [SQL Server]({{< relref "./docs/connector/sqlserver.md" >}})
    - [System]({{< relref "./docs/connector/system.md" >}})
    - [Thrift]({{< relref "./docs/connector/thrift.md" >}})
    - [TPCDS]({{< relref "./docs/connector/tpcds.md" >}})
    - [TPCH]({{< relref "./docs/connector/tpch.md" >}})
    - [VDM]({{< relref "./docs/connector/vdm.md" >}})
    - [Oracle]({{< relref "./docs/connector/oracle.md" >}})
    - [MongoDB]({{< relref "./docs/connector/mongodb.md" >}})
    - [openGauss]({{< relref "./docs/connector/opengauss.md" >}})

- [Functions and Operators]("#")
    - [Logical Operators]({{< relref "./docs/functions/logical.md" >}})
    - [Comparison Functions and Operators]({{< relref "./docs/functions/comparison.md" >}})
    - [Conditional Expressions]({{< relref "./docs/functions/conditional.md" >}})
    - [Lambda Expressions]({{< relref "./docs/functions/lambda.md" >}})
    - [Conversion Functions]({{< relref "./docs/functions/conversion.md" >}})
    - [Mathematical Functions and Operators]({{< relref "./docs/functions/math.md" >}})
    - [Bitwise Functions]({{< relref "./docs/functions/bitwise.md" >}})
    - [Decimal Functions and Operators]({{< relref "./docs/functions/decimal.md" >}})
    - [String Functions and Operators]({{< relref "./docs/functions/string.md" >}})
    - [Regular Expression Functions]({{< relref "./docs/functions/regexp.md" >}})
    - [Binary Functions and Operators]({{< relref "./docs/functions/binary.md" >}})
    - [JSON Functions and Operators]({{< relref "./docs/functions/json.md" >}})
    - [Date and Time Functions and Operators]({{< relref "./docs/functions/datetime.md" >}})
    - [Aggregate Functions]({{< relref "./docs/functions/aggregate.md" >}})
    - [Window Functions]({{< relref "./docs/functions/window.md" >}})
    - [Array Functions and Operators]({{< relref "./docs/functions/array.md" >}})
    - [Map Functions and Operators]({{< relref "./docs/functions/map.md" >}})
    - [URL Functions]({{< relref "./docs/functions/url.md" >}})
    - [Geospatial Functions]({{< relref "./docs/functions/geospatial.md" >}})
    - [HyperLogLog Functions]({{< relref "./docs/functions/hyperloglog.md" >}})
    - [Quantile Digest Functions]({{< relref "./docs/functions/qdigest.md" >}})
    - [UUID Functions]({{< relref "./docs/functions/uuid.md" >}})
    - [Color Functions]({{< relref "./docs/functions/color.md" >}})
    - [Session Information]({{< relref "./docs/functions/session.md" >}})
    - [Teradata Functions]({{< relref "./docs/functions/teradata.md" >}})

- [SQL Language]("#")
    - [Data Types]({{< relref "./docs/language/types.md" >}})
    - [Reserved Keywords]({{< relref "./docs/language/reserved.md" >}})
    - [Legacy and New Timestamp]({{< relref "./docs/language/timestamp.md" >}})

- [SQL Statement Syntax]({{< relref "./docs/sql/_index.md" >}})
    - [ALTER SCHEMA]({{< relref "./docs/sql/alter-schema.md" >}})
    - [ALTER TABLE]({{< relref "./docs/sql/alter-table.md" >}})
    - [ANALYZE]({{< relref "./docs/sql/analyze.md" >}})
    - [CACHE TABLE]({{< relref "./docs/sql/cache-table.md" >}})
    - [CALL]({{< relref "./docs/sql/call.md" >}})
    - [COMMENT]({{< relref "./docs/sql/comment.md" >}})
    - [COMMIT]({{< relref "./docs/sql/commit.md" >}})
    - [CREATE ROLE]({{< relref "./docs/sql/create-role.md" >}})
    - [CREATE SCHEMA]({{< relref "./docs/sql/create-schema.md" >}})
    - [CREATE TABLE]({{< relref "./docs/sql/create-table.md" >}})
    - [CREATE TABLE AS]({{< relref "./docs/sql/create-table-as.md" >}})
    - [CREATE VIEW]({{< relref "./docs/sql/create-view.md" >}})
    - [DEALLOCATE PREPARE]({{< relref "./docs/sql/deallocate-prepare.md" >}})
    - [DELETE]({{< relref "./docs/sql/delete.md" >}})
    - [DESCRIBE]({{< relref "./docs/sql/describe.md" >}})
    - [DESCRIBE INPUT]({{< relref "./docs/sql/describe-input.md" >}})
    - [DESCRIBE OUTPUT]({{< relref "./docs/sql/describe-output.md" >}})
    - [DROP CACHE]({{< relref "./docs/sql/drop-cache.md" >}})
    - [DROP ROLE]({{< relref "./docs/sql/drop-role.md" >}})
    - [DROP SCHEMA]({{< relref "./docs/sql/drop-schema.md" >}})
    - [DROP TABLE]({{< relref "./docs/sql/drop-table.md" >}})
    - [DROP VIEW]({{< relref "./docs/sql/drop-view.md" >}})
    - [EXECUTE]({{< relref "./docs/sql/execute.md" >}})
    - [EXPLAIN]({{< relref "./docs/sql/explain.md" >}})
    - [EXPLAIN ANALYZE]({{< relref "./docs/sql/explain-analyze.md" >}})
    - [GRANT]({{< relref "./docs/sql/grant.md" >}})
    - [GRANT ROLES]({{< relref "./docs/sql/grant-roles.md" >}})
    - [INSERT]({{< relref "./docs/sql/insert.md" >}})
    - [INSERT OVERWRITE]({{< relref "./docs/sql/insert-overwrite.md" >}})
    - [JMX]({{< relref "./docs/sql/jmx.md" >}})
    - [PREPARE]({{< relref "./docs/sql/prepare.md" >}})
    - [RESET SESSION]({{< relref "./docs/sql/reset-session.md" >}})
    - [REVOKE]({{< relref "./docs/sql/revoke.md" >}})
    - [REVOKE ROLES]({{< relref "./docs/sql/revoke-roles.md" >}})
    - [ROLLBACK]({{< relref "./docs/sql/rollback.md" >}})
    - [SELECT]({{< relref "./docs/sql/select.md" >}})
    - [SET ROLE]({{< relref "./docs/sql/set-role.md" >}})
    - [SET SESSION]({{< relref "./docs/sql/set-session.md" >}})
    - [SHOW CACHE]({{< relref "./docs/sql/show-cache.md" >}})
    - [SHOW CATALOGS]({{< relref "./docs/sql/show-catalogs.md" >}})
    - [SHOW COLUMNS]({{< relref "./docs/sql/show-columns.md" >}})
    - [SHOW CREATE TABLE]({{< relref "./docs/sql/show-create-table.md" >}})
    - [SHOW CREATE VIEW]({{< relref "./docs/sql/show-create-view.md" >}})
    - [SHOW FUNCTIONS]({{< relref "./docs/sql/show-functions.md" >}})
    - [SHOW GRANTS]({{< relref "./docs/sql/show-grants.md" >}})
    - [SHOW ROLE GRANTS]({{< relref "./docs/sql/show-role-grants.md" >}})
    - [SHOW ROLES]({{< relref "./docs/sql/show-roles.md" >}})
    - [SHOW SCHEMAS]({{< relref "./docs/sql/show-schemas.md" >}})
    - [SHOW SESSION]({{< relref "./docs/sql/show-session.md" >}})
    - [SHOW STATS]({{< relref "./docs/sql/show-stats.md" >}})
    - [SHOW TABLES]({{< relref "./docs/sql/show-tables.md" >}})
    - [START TRANSACTION]({{< relref "./docs/sql/start-transaction.md" >}})
    - [UPDATE]({{< relref "./docs/sql/update.md" >}})
    - [USE]({{< relref "./docs/sql/use.md" >}})
    - [VACUUM]({{< relref "./docs/sql/vacuum.md" >}})
    - [VALUES]({{< relref "./docs/sql/values.md" >}})

- [Migration]("#")
    - [Migrating From Hive]({{< relref "./docs/migration/from-hive.md" >}})
    - [SQL Migration Tool]({{< relref "./docs/migration/sql-migration-tool.md" >}})
    - [Support Hive Functions]({{< relref "./docs/migration/hetu-hive-functions.md" >}})
  
- [Developer Guide]({{< relref "./docs/develop/_index.md" >}})
    - [Getting Started]({{< relref "./docs/develop/getting-started.md" >}})
    - [SPI Overview]({{< relref "./docs/develop/spi-overview.md" >}})
    - [Connectors]({{< relref "./docs/develop/connectors.md" >}})
    - [Example HTTP Connector]({{< relref "./docs/develop/example-http.md" >}})
    - [Types]({{< relref "./docs/develop/types.md" >}})
    - [Functions]({{< relref "./docs/develop/functions.md" >}})
    - [System Access Control]({{< relref "./docs/develop/system-access-control.md" >}})
    - [Password Authenticator]({{< relref "./docs/develop/password-authenticator.md" >}})
    - [Event Listener]({{< relref "./docs/develop/event-listener.md" >}})
    - [Filesystem Access Utilities]({{< relref "./docs/develop/filesystem.md" >}})
    - [Heuristic indexer]({{< relref "./docs/develop/indexer.md" >}})
    - [Hive ORC Cache]({{< relref "./docs/develop/hive-orc-cache.md" >}})

- [openLooKeng REST API]({{< relref "./docs/rest/_index.md" >}})
    - [Node Resource]({{< relref "./docs/rest/node.md" >}})
    - [Query Resource]({{< relref "./docs/rest/query.md" >}})
    - [Stage Resource]({{< relref "./docs/rest/stage.md" >}})
    - [Statement Resource]({{< relref "./docs/rest/statement.md" >}})
    - [Task Resource]({{< relref "./docs/rest/task.md" >}})

- [Release Notes]("#")
    - [1.1.0]({{< relref "./docs/releasenotes/releasenotes-1.1.0.md" >}})
    - [1.0.1]({{< relref "./docs/releasenotes/releasenotes-1.0.1.md" >}})
    - [1.0.0]({{< relref "./docs/releasenotes/releasenotes-1.0.0.md" >}})
    - [0.1.0]({{< relref "./docs/releasenotes/releasenotes-0.1.0.md" >}})
