hetu-core/hetu-docs/en/index.md

15 KiB

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" >}})
    • [Authentication User Mapping]({{< relref "./docs/security/user-mapping.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" >}})
    • [Function Namespace Managers]({{< relref "./docs/admin/function-namespace-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" >}})
    • [State store]({{< relref "./docs/admin/state-store.md" >}})
    • [Meta Store]({{< relref "./docs/admin/meta-store.md" >}})
    • [Audit Log]({{< relref "./docs/admin/audit-log.md" >}})
    • [Reliable Execution]({{< relref "./docs/admin/reliable-execution.md" >}})
    • [JDBC Data Source Multi-Split Management]({{< relref "./docs/admin/multi-split-for-jdbc-data-source.md" >}})
    • [Extension Physical Execution Planner]({{< relref "./docs/admin/extension-execution-planner.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" >}})
    • [Rule based optimizations]({{< relref "./docs/optimizer/rule-based-optimizations.md" >}})
    • [Table pushdown]({{< relref "./docs/optimizer/table-pushdown.md" >}})
  • Heuristic Indexer

    • [openLooKeng Heuristic Indexer]({{< relref "./docs/indexer/overview.md" >}})
    • [Bitmap Index]({{< relref "./docs/indexer/bitmap.md" >}})
    • [Minmax Index]({{< relref "./docs/indexer/minmax.md" >}})
    • [Bloom Index]({{< relref "./docs/indexer/bloom.md" >}})
    • [BTree Index]({{< relref "./docs/indexer/btree.md" >}})
    • [HIndex Statements]({{< relref "./docs/indexer/hindex-statements.md" >}})
    • [New Index]({{< relref "./docs/indexer/new-index.md" >}})
  • Star Tree Cubes

    • [Overview]({{< relref "./docs/preagg/overview.md" >}})
    • [Join Support]({{< relref "./docs/preagg/join-queries.md" >}})
    • [Statements]({{< relref "./docs/preagg/statements.md" >}})
  • [Connectors]({{< relref "./docs/connector/_index.md" >}})

    • [Carbondata]({{< relref "./docs/connector/carbondata.md" >}})
    • [ClickHouse]({{< relref "./docs/connector/clickhouse.md" >}})
    • [DataCenter]({{< relref "./docs/connector/datacenter.md" >}})
    • [Elasticsearch]({{< relref "./docs/connector/elasticsearch.md" >}})
    • [Greenplum]({{< relref "./docs/connector/greenplum.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" >}})
    • [Hudi]({{< relref "./docs/connector/Hudi.md" >}})
    • [JMX]({{< relref "./docs/connector/jmx.md" >}})
    • [Kafka]({{< relref "./docs/connector/kafka.md" >}})
    • [Kafka Connector Tutorial]({{< relref "./docs/connector/kafka-tutorial.md" >}})
    • [Redis]({{< relref "./docs/connector/redis.md" >}})
    • [Local File]({{< relref "./docs/connector/localfile.md" >}})
    • [Memory]({{< relref "./docs/connector/memory.md" >}})
    • [MongoDB]({{< relref "./docs/connector/mongodb.md" >}})
    • [MySQL]({{< relref "./docs/connector/mysql.md" >}})
    • [openGauss]({{< relref "./docs/connector/opengauss.md" >}})
    • [Oracle]({{< relref "./docs/connector/oracle.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" >}})
    • [Kylin]({{< relref "./docs/connector/kylin.md" >}})
    • [OmniData]({{< relref "./docs/connector/omnidata.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" >}})
  • [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 CUBE]({{< relref "./docs/sql/show-create-cube.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 EXTERNAL FUNCTION]({{< relref "./docs/sql/show-external-function.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" >}})
    • [Hive ORC Cache]({{< relref "./docs/develop/hive-orc-cache.md" >}})
    • [External Function Registration and Push Down]({{< relref "./docs/develop/externalfunction-registration-pushdown.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.7.0 (30 Jun 2022)]({{< relref "./docs/releasenotes/releasenotes-1.7.0.md" >}})
    • [1.6.1 (27 Apr 2022)]({{< relref "./docs/releasenotes/releasenotes-1.6.1.md" >}})
    • [1.6.0 (30 Mar 2022)]({{< relref "./docs/releasenotes/releasenotes-1.6.0.md" >}})
    • [1.5.0 (30 Dec 2021)]({{< relref "./docs/releasenotes/releasenotes-1.5.0.md" >}})
    • [1.4.1 (12 Nov 2021)]({{< relref "./docs/releasenotes/releasenotes-1.4.1.md" >}})
    • [1.4.0 (15 Oct 2021)]({{< relref "./docs/releasenotes/releasenotes-1.4.0.md" >}})
    • [1.3.0 (30 Jun 2021)]({{< relref "./docs/releasenotes/releasenotes-1.3.0.md" >}})
    • [1.2.0 (31 Mar 2021)]({{< relref "./docs/releasenotes/releasenotes-1.2.0.md" >}})
    • [1.1.0 (30 Dec 2020)]({{< relref "./docs/releasenotes/releasenotes-1.1.0.md" >}})
    • [1.0.1 (30 Sep 2020)]({{< relref "./docs/releasenotes/releasenotes-1.0.1.md" >}})
    • [1.0.0 (23 Sep 2020)]({{< relref "./docs/releasenotes/releasenotes-1.0.0.md" >}})
    • [0.1.0 (30 Jun 2020)]({{< relref "./docs/releasenotes/releasenotes-0.1.0.md" >}})
  • [FAQ]({{< relref "./docs/faq/faq.md" >}})