Path Lines of Code README.md 80 _data/articles.json 14 _data/authors.json 68 _data/poweredby.json 77 _data/version.json 7 _docs/en/010-getting-started.md 4 _docs/en/020-architecture.md 4 _docs/en/030-tutorials.md 5 _docs/en/031-drill-on-yarn.md 5 _docs/en/040-install-drill.md 4 _docs/en/045-configure-drill.md 4 _docs/en/050-connect-a-data-source.md 4 _docs/en/060-odbc-jdbc-interfaces.md 4 _docs/en/070-query-data.md 4 _docs/en/072-performance-tuning.md 4 _docs/en/073-log-and-debug.md 4 _docs/en/080-sql-reference.md 4 _docs/en/090-data-sources-and-file-formats.md 4 _docs/en/100-develop-custom-functions.md 4 _docs/en/110-troubleshooting.md 182 _docs/en/120-developer-information.md 4 _docs/en/130-rn.md 4 _docs/en/140-sample-datasets.md 4 _docs/en/171-ecosystem.md 4 _docs/en/architecture/010-architecture-introduction.md 67 _docs/en/architecture/015-drill-query-execution.md 36 _docs/en/architecture/020-core-modules.md 20 _docs/en/architecture/030-performance.md 44 _docs/en/configure-drill/010-configure-drill-introduction.md 19 _docs/en/configure-drill/020-configuring-drill-memory.md 72 _docs/en/configure-drill/031-securing-drill.md 5 _docs/en/configure-drill/040-configuring-a-multitenant-cluster.md 5 _docs/en/configure-drill/045-configuring-a-multitenant-cluster-introduction.md 16 _docs/en/configure-drill/050-configuring-multitenant-resources.md 27 _docs/en/configure-drill/060-configuring-a-shared-drillbit.md 37 _docs/en/configure-drill/080-configuration-options.md 5 _docs/en/configure-drill/100-ports-and-bind-addr-used-by-drill.md 21 _docs/en/configure-drill/120-configuring-the-drill-shell.md 172 _docs/en/configure-drill/121-configuring-cgroups-to-control-cpu-usage.md 59 _docs/en/configure-drill/configuration-options/020-start-up-options.md 68 _docs/en/configure-drill/configuration-options/030-planning-and-exececution-options.md 94 _docs/en/configure-drill/configuration-options/040-persistent-configuration-storage.md 44 _docs/en/configure-drill/configuration-options/041-global-query-list.md 20 _docs/en/configure-drill/securing-drill/010-securing-drill-introduction.md 20 _docs/en/configure-drill/securing-drill/020-secure-communication-paths.md 57 _docs/en/configure-drill/securing-drill/030-roles-privileges.md 26 _docs/en/configure-drill/securing-drill/040-configuring-user-impersonation.md 91 _docs/en/configure-drill/securing-drill/050-configure-inbound-impersonation.md 36 _docs/en/configure-drill/securing-drill/060-configuring-user-impersonation-with-hive-authorization.md 187 _docs/en/configure-drill/securing-drill/070-configuring-user-security.md 27 _docs/en/configure-drill/securing-drill/080-configuring-plain-security.md 41 _docs/en/configure-drill/securing-drill/081-configuring-ssl-tls-for-encryption.md 110 _docs/en/configure-drill/securing-drill/082-using-libpam4j-as-the-pam-authenticator.md 28 _docs/en/configure-drill/securing-drill/083-using-jpam-as-the-pam-authenticator.md 35 _docs/en/configure-drill/securing-drill/084-configuring-htpasswd-authentication.md 26 _docs/en/configure-drill/securing-drill/085-configuring-vault-authentication.md 34 _docs/en/configure-drill/securing-drill/090-configuring-kerberos-security.md 162 _docs/en/configure-drill/securing-drill/091-configuring-drill-to-use-spnego-for-http-authentication.md 101 _docs/en/configure-drill/securing-drill/092-configuring-web-ui-and-rest-api-security.md 85 _docs/en/configure-drill/securing-drill/093-configuring-custom-acls-to-secure-znodes.md 30 _docs/en/connect-a-data-source/010-connect-a-data-source-introduction.md 14 _docs/en/connect-a-data-source/020-storage-plugin-registration.md 37 _docs/en/connect-a-data-source/030-storage-plugin-configuration.md 5 _docs/en/connect-a-data-source/035-plugin-configuration-basics.md 169 _docs/en/connect-a-data-source/036-configuring-storage-plugins.md 73 _docs/en/connect-a-data-source/040-storage-plugin-auth-modes.md 96 _docs/en/connect-a-data-source/050-workspaces.md 70 _docs/en/connect-a-data-source/080-drill-default-input-format.md 43 _docs/en/connect-a-data-source/plugins/040-file-system-storage-plugin.md 88 _docs/en/connect-a-data-source/plugins/060-hbase-storage-plugin.md 16 _docs/en/connect-a-data-source/plugins/070-hive-storage-plugin.md 104 _docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md 152 _docs/en/connect-a-data-source/plugins/090-mongodb-storage-plugin.md 149 _docs/en/connect-a-data-source/plugins/095-mapr-db-format.md 13 _docs/en/connect-a-data-source/plugins/110-s3-storage-plugin.md 122 _docs/en/connect-a-data-source/plugins/111-OCI-OS-storage-plugin.md 58 _docs/en/connect-a-data-source/plugins/112-opentsdb-storage-plugin.md 56 _docs/en/connect-a-data-source/plugins/113-kafka-storage-plugin.md 186 _docs/en/connect-a-data-source/plugins/115-azure-blob-storage-plugin.md 67 _docs/en/connect-a-data-source/plugins/120-druid-storage-plugin.md 34 _docs/en/connect-a-data-source/plugins/125-http-storage-plugin.md 501 _docs/en/connect-a-data-source/plugins/130-elasticsearch-plugin.md 47 _docs/en/connect-a-data-source/plugins/140-splunk-storage-plugin.md 161 _docs/en/connect-a-data-source/plugins/150-cassandra-storage-plugin.md 40 _docs/en/connect-a-data-source/plugins/160-dropbox-storage-plugin.md 40 _docs/en/connect-a-data-source/plugins/170-google-sheets-plugin.md 154 _docs/en/data-sources-and-file-formats/010-data-sources-and-file-formats-introduction.md 47 _docs/en/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md 96 _docs/en/data-sources-and-file-formats/030-deploying-and-using-a-hive-udf.md 45 _docs/en/data-sources-and-file-formats/040-parquet-format.md 170 _docs/en/data-sources-and-file-formats/041-logfile-plugin.md 71 _docs/en/data-sources-and-file-formats/050-json-data-model.md 407 _docs/en/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md 249 _docs/en/data-sources-and-file-formats/070-sequencefile-format.md 35 _docs/en/data-sources-and-file-formats/110-httpd-format-plugin.md 70 _docs/en/data-sources-and-file-formats/112-sys-log-format-plugin.md 45 _docs/en/data-sources-and-file-formats/113-ltsv-format-plugin.md 32 _docs/en/data-sources-and-file-formats/114-spss-format-plugin.md 41 _docs/en/data-sources-and-file-formats/115-esri-shapefile-format-plugin.md 30 _docs/en/data-sources-and-file-formats/116-excel-format-plugin.md 62 _docs/en/data-sources-and-file-formats/117-hdf5-format-plugin.md 111 _docs/en/data-sources-and-file-formats/119-access-format-plugin.md 35 _docs/en/data-sources-and-file-formats/120-xml-format-plugin.md 126 _docs/en/data-sources-and-file-formats/125-iceburg-format-plugin.md 87 _docs/en/data-sources-and-file-formats/126-delta-lake-format-plugin.md 41 _docs/en/data-sources-and-file-formats/130-sas-format.plugin.md 33 _docs/en/develop-custom-functions/010-develop-custom-functions-introduction.md 22 _docs/en/develop-custom-functions/020-developing-a-simple-function.md 39 _docs/en/develop-custom-functions/025-tutorial-develop-a-simple-function.md 171 _docs/en/develop-custom-functions/030-developing-an-aggregate-function.md 48 _docs/en/develop-custom-functions/040-adding-custom-functions-to-drill.md 5 _docs/en/develop-custom-functions/050-use-custom-functions-in-queries.md 43 _docs/en/develop-custom-functions/060-custom-function-interfaces.md 119 _docs/en/develop-custom-functions/adding-custom-functions-to-drill/009-adding-custom-functions-to-drill-introduction.md 8 _docs/en/develop-custom-functions/adding-custom-functions-to-drill/010-manually-adding-custom-functions-to-drill.md 16 _docs/en/develop-custom-functions/adding-custom-functions-to-drill/015-creating-custom-authenticators.md 77 _docs/en/develop-custom-functions/adding-custom-functions-to-drill/020-dynamic-udfs.md 94 _docs/en/developer-information/009-rest-api.md 5 _docs/en/developer-information/010-develop-drill.md 5 _docs/en/developer-information/020-contribute-to-drill.md 5 _docs/en/developer-information/030-design-docs.md 5 _docs/en/developer-information/contribute-to-drill/010-apache-drill-contribution-guidelines.md 108 _docs/en/developer-information/contribute-to-drill/020-apache-drill-contribution-ideas.md 102 _docs/en/developer-information/design-docs/010-drill-plan-syntax.md 19 _docs/en/developer-information/design-docs/020-rpc-overview.md 25 _docs/en/developer-information/design-docs/030-query-stages.md 33 _docs/en/developer-information/design-docs/040-useful-research.md 37 _docs/en/developer-information/design-docs/050-value-vectors.md 113 _docs/en/developer-information/develop-drill/010-compiling-drill-from-source.md 40 _docs/en/developer-information/develop-drill/011-useful-information-for-drill-developers.md 7 _docs/en/developer-information/rest-api/010-rest-api-introduction.md 449 _docs/en/developer-information/rest-api/011-submitting-queries-from-the-rest-api-when-impersonation-is-enabled-and-authentication-is-disabled.md 36 _docs/en/developer-information/rest-api/012-use-postman-to-run-sql-queries-on-drill-data-sources.md 23 _docs/en/drill-on-yarn/010-drill-on-yarn-introduction.md 35 _docs/en/drill-on-yarn/020-creating-a-basic-drill-cluster.md 171 _docs/en/drill-on-yarn/030-launch-drill-under-yarn.md 19 _docs/en/drill-on-yarn/040-configuration-reference.md 60 _docs/en/drill-on-yarn/050-drill-on-yarn-command-line-tool.md 70 _docs/en/drill-on-yarn/060-using-the-drill-on-yarn-web-ui.md 62 _docs/en/drill-on-yarn/070-multiple-drill-clusters.md 54 _docs/en/drill-on-yarn/080-enabling-web-ui-security.md 25 _docs/en/drill-on-yarn/090-appendix-a-release-note-issues.md 115 _docs/en/drill-on-yarn/091-appendix-b-drill-env.sh-settings.md 12 _docs/en/drill-on-yarn/092-appendix-c-troubleshooting.md 70 _docs/en/drill-on-yarn/093-appendix-d-recreate-the-drill-archive.md 20 _docs/en/ecosystem/010-using-saiku-analytics-with-apache-drill.md 132 _docs/en/getting-started/010-drill-introduction.md 271 _docs/en/getting-started/020-why-drill.md 64 _docs/en/install/010-install-drill-introduction.md 9 _docs/en/install/020-migrating-parquet-data.md 37 _docs/en/install/030-installing-drill-in-embedded-mode.md 5 _docs/en/install/040-installing-drill-in-distributed-mode.md 5 _docs/en/install/045-distributed-mode-prerequisites.md 13 _docs/en/install/047-installing-drill-on-the-cluster.md 47 _docs/en/install/050-starting-drill-in-distributed-mode.md 51 _docs/en/install/060-starting-the-web-ui.md 38 _docs/en/install/061-stopping-drill.md 30 _docs/en/install/070-identifying-multiple-drill-versions-in-a-cluster.md 17 _docs/en/install/080-extended.md 5 _docs/en/install/extended/010-installing-drill-on-gcp-dataproc.md 45 _docs/en/install/installing-drill-in-embedded-mode/010-embedded-mode-prerequisites.md 13 _docs/en/install/installing-drill-in-embedded-mode/011-running-drill-on-docker.md 116 _docs/en/install/installing-drill-in-embedded-mode/020-installing-drill-on-linux-and-mac-os-x.md 13 _docs/en/install/installing-drill-in-embedded-mode/030-starting-drill-on-linux-and-mac-os-x.md 23 _docs/en/install/installing-drill-in-embedded-mode/040-installing-drill-on-windows.md 40 _docs/en/install/installing-drill-in-embedded-mode/050-starting-drill-on-windows.md 44 _docs/en/log-and-debug/001-log-and-debug-introduction.md 15 _docs/en/log-and-debug/002-error-messages.md 19 _docs/en/log-and-debug/003-modify-logback.xml.md 40 _docs/en/log-and-debug/004-review-the-java-stack-trace.md 32 _docs/en/log-and-debug/005-query-audit-logging.md 50 _docs/en/odbc-jdbc-interfaces/010-interfaces-introduction.md 35 _docs/en/odbc-jdbc-interfaces/015-using-jdbc-driver.md 103 _docs/en/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md 96 _docs/en/odbc-jdbc-interfaces/030-installing-the-odbc-driver.md 5 _docs/en/odbc-jdbc-interfaces/040-configuring-odbc.md 5 _docs/en/odbc-jdbc-interfaces/050-using-drill-explorer.md 5 _docs/en/odbc-jdbc-interfaces/060-using-drill-with-bi-tools.md 5 _docs/en/odbc-jdbc-interfaces/configuring-odbc/010-odbc-configuration-reference.md 93 _docs/en/odbc-jdbc-interfaces/configuring-odbc/011-logging-and-tracing.md 101 _docs/en/odbc-jdbc-interfaces/configuring-odbc/020-configuring-odbc-on-linux.md 170 _docs/en/odbc-jdbc-interfaces/configuring-odbc/025-configuring-odbc-on-mac-os-x.md 128 _docs/en/odbc-jdbc-interfaces/configuring-odbc/030-configuring-odbc-on-windows.md 47 _docs/en/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md 133 _docs/en/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md 59 _docs/en/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md 47 _docs/en/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md 55 _docs/en/odbc-jdbc-interfaces/using-drill-explorer/010-drill-explorer-introduction.md 10 _docs/en/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md 37 _docs/en/odbc-jdbc-interfaces/using-drill-explorer/030-browsing-data-and-creating-views.md 68 _docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/010-using-odbc-with-bi-tools-introduction.md 25 _docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/020-tableau-examples.md 199 _docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/030-using-microstrategy-analytics-with-apache-drill.md 103 _docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-desktop-with-drill.md 33 _docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/050-configuring-spotfire-server.md 91 _docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/055-using-qliksense-with-drill.md 63 _docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/059-using-apache-drill-with-tableau-10.2.md 52 _docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md 59 _docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/070-using-apache-drill-with-tableau-9-server.md 47 _docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/075-using-apache-drill-with-webfocus.md 53 _docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/090-configuring-jreport-with-drill.md 41 _docs/en/performance-tuning/005-drill-metastore.md 5 _docs/en/performance-tuning/010-performance-tuning-introduction.md 16 _docs/en/performance-tuning/020-partition-pruning.md 5 _docs/en/performance-tuning/024-aynchronous-parquet-reader.md 54 _docs/en/performance-tuning/025-optimizing-parquet-reading.md 33 _docs/en/performance-tuning/026-parquet-filter-pushdown.md 102 _docs/en/performance-tuning/027-hive-metadata-caching.md 37 _docs/en/performance-tuning/030-choosing-a-storage-format.md 11 _docs/en/performance-tuning/040-query-plans-and-tuning.md 5 _docs/en/performance-tuning/050-identifying-performance-issues.md 5 _docs/en/performance-tuning/060-performance-tuning-reference.md 5 _docs/en/performance-tuning/070-monitoring-metrics.md 102 _docs/en/performance-tuning/drill-metastore/010-using-drill-metastore.md 483 _docs/en/performance-tuning/drill-metastore/020-drill-iceberg-metastore.md 45 _docs/en/performance-tuning/drill-metastore/030-rdbms-metastore.md 117 _docs/en/performance-tuning/drill-metastore/040-mongo-metastore.md 48 _docs/en/performance-tuning/identifying-performance-issues/010-query-plans.md 48 _docs/en/performance-tuning/partition-pruning/010-partition-pruning-introduction.md 17 _docs/en/performance-tuning/partition-pruning/030-using-partition-pruning.md 84 _docs/en/performance-tuning/performance-tuning-reference/010-query-profile-tables.md 64 _docs/en/performance-tuning/performance-tuning-reference/020-physical-operators.md 74 _docs/en/performance-tuning/query-plans-and-tuning/010-query-plans-and-tuning-introduction.md 6 _docs/en/performance-tuning/query-plans-and-tuning/020-join-planning-guidelines.md 27 _docs/en/performance-tuning/query-plans-and-tuning/030-guidelines-for-optimizing-aggregation.md 12 _docs/en/performance-tuning/query-plans-and-tuning/040-modifying-query-planning-options.md 19 _docs/en/performance-tuning/query-plans-and-tuning/050-sort-based-and-hash-based-memory-constrained-operators.md 89 _docs/en/performance-tuning/query-plans-and-tuning/060-enabling-query-queuing.md 32 _docs/en/performance-tuning/query-plans-and-tuning/065-throttling.md 51 _docs/en/performance-tuning/query-plans-and-tuning/070-controlling-parallelization-to-balance-performance-with-multi-tenancy.md 8 _docs/en/query-data/010-query-data-introduction.md 64 _docs/en/query-data/020-querying-a-file-system.md 5 _docs/en/query-data/030-querying-hbase.md 208 _docs/en/query-data/040-querying-complex-data.md 5 _docs/en/query-data/050-querying-hive.md 45 _docs/en/query-data/060-querying-the-information-schema.md 218 _docs/en/query-data/061-querying-indexes.md 5 _docs/en/query-data/080-monitoring-and-canceling-queries-in-the-Drill-Web-UI.md 24 _docs/en/query-data/query-a-file-system/005-querying-a-file-system-introduction.md 67 _docs/en/query-data/query-a-file-system/009-querying-avro-files.md 23 _docs/en/query-data/query-a-file-system/010-querying-json-files.md 27 _docs/en/query-data/query-a-file-system/020-querying-parquet-files.md 62 _docs/en/query-data/query-a-file-system/030-querying-plain-text-files.md 172 _docs/en/query-data/query-a-file-system/040-querying-directories.md 136 _docs/en/query-data/query-a-file-system/050-querying-sequence-files.md 22 _docs/en/query-data/querying-complex-data/005-querying-complex-data-introduction.md 47 _docs/en/query-data/querying-complex-data/010-sample--data-donuts.md 40 _docs/en/query-data/querying-complex-data/020-selecting-flat-data.md 22 _docs/en/query-data/querying-complex-data/030-using-sql-functions-clauses-and-joins.md 44 _docs/en/query-data/querying-complex-data/040-selecting-nested-data.md 36 _docs/en/query-data/querying-complex-data/050-selecting-multiple-columns-within-nested-data.md 23 _docs/en/query-data/querying-indexes/010-querying-indexes-introduction.md 10 _docs/en/query-data/querying-indexes/020-queries-that-qualify-for-index-based-query-plans.md 28 _docs/en/query-data/querying-indexes/021-types-of-indexes.md 76 _docs/en/query-data/querying-indexes/030-index-selection.md 14 _docs/en/query-data/querying-indexes/040-designing-indexes-for-your-queries.md 76 _docs/en/query-data/querying-indexes/060-verifying-index-use.md 67 _docs/en/rn/040-1.21.2-rn.md 56 _docs/en/rn/041-1.21.1-rn.md 22 _docs/en/rn/042-1.21.0-rn.md 120 _docs/en/rn/043-1.20.3-rn.md 40 _docs/en/rn/044-1.20.2-rn.md 39 _docs/en/rn/045-1.20.1-rn.md 29 _docs/en/rn/046-1.20.0-rn.md 123 _docs/en/rn/047-1.19.0-rn.md 128 _docs/en/rn/048-1.18.0-rn.md 178 _docs/en/rn/049-1.17.0-rn.md 418 _docs/en/rn/050-1.16.0-rn.md 488 _docs/en/rn/051-1.15.0-rn.md 470 _docs/en/rn/052-1.14.0-rn.md 552 _docs/en/rn/053-1.13.0-rn.md 282 _docs/en/rn/054-1.12.0-rn.md 418 _docs/en/rn/055-1.11.0-rn.md 287 _docs/en/rn/056-1.10.0-rn.md 279 _docs/en/rn/057-1.9.0-rn.md 170 _docs/en/rn/058-1.8.0-rn.md 150 _docs/en/rn/059-1.7.0-rn.md 150 _docs/en/rn/060-1.6.0-rn.md 118 _docs/en/rn/061-1.5.0-rn.md 152 _docs/en/rn/062-1.4.0-rn.md 98 _docs/en/rn/063-1.3.0-rn.md 144 _docs/en/rn/064-1.2.0-rn.md 489 _docs/en/rn/065-1.1.0-rn.md 347 _docs/en/rn/066-1.0.0-rn.md 496 _docs/en/rn/067-0.9.0-rn.md 23 _docs/en/rn/068-0.8.0-rn.md 23 _docs/en/rn/069-0.7.0-rn.md 36 _docs/en/rn/070-0.6.0-rn.md 26 _docs/en/rn/071-0.5.0rn.md 24 _docs/en/rn/072-0.4.0rn.md 36 _docs/en/rn/073-alpha-rn.md 32 _docs/en/rn/074-m1-alpha-rn.md 32 _docs/en/sample-datasets/001-enron.md 15 _docs/en/sample-datasets/002-wikipedia.md 80 _docs/en/sql-reference/010-sql-reference-introduction.md 15 _docs/en/sql-reference/020-data-types.md 5 _docs/en/sql-reference/030-lexical-structure.md 180 _docs/en/sql-reference/040-operators.md 76 _docs/en/sql-reference/050-sql-functions.md 5 _docs/en/sql-reference/055-sql-window-functions.md 5 _docs/en/sql-reference/060-nested-data-functions.md 5 _docs/en/sql-reference/065-query-directory-functions.md 39 _docs/en/sql-reference/070-sql-commands-summary.md 5 _docs/en/sql-reference/075-sql-conditional-expressions.md 5 _docs/en/sql-reference/080-reserved-keywords.md 142 _docs/en/sql-reference/090-sql-extensions.md 39 _docs/en/sql-reference/data-types/010-supported-data-types.md 189 _docs/en/sql-reference/data-types/020-date-time-and-timestamp.md 152 _docs/en/sql-reference/data-types/030-handling-different-data-types.md 52 _docs/en/sql-reference/nested-data-functions/005-nested-data-limitations.md 6 _docs/en/sql-reference/nested-data-functions/010-flatten.md 80 _docs/en/sql-reference/nested-data-functions/020-kvgen.md 184 _docs/en/sql-reference/nested-data-functions/030-repeated-count.md 35 _docs/en/sql-reference/nested-data-functions/040-repeated-contains.md 70 _docs/en/sql-reference/nested-data-functions/050-collect-to-list.md 34 _docs/en/sql-reference/sql-commands/005-supported-sql-commands.md 31 _docs/en/sql-reference/sql-commands/007-analyze-table-refresh-metadata.md 81 _docs/en/sql-reference/sql-commands/010-set.md 63 _docs/en/sql-reference/sql-commands/011-refresh-table-metadata.md 236 _docs/en/sql-reference/sql-commands/012-reset.md 49 _docs/en/sql-reference/sql-commands/020-alter-system.md 71 _docs/en/sql-reference/sql-commands/021-create-schema.md 545 _docs/en/sql-reference/sql-commands/030-create-table-as.md 185 _docs/en/sql-reference/sql-commands/031-create-temporary-table-as.md 99 _docs/en/sql-reference/sql-commands/034-create-function-using-jar.md 27 _docs/en/sql-reference/sql-commands/035-partition-by-clause.md 136 _docs/en/sql-reference/sql-commands/050-create-view.md 139 _docs/en/sql-reference/sql-commands/053-describe.md 139 _docs/en/sql-reference/sql-commands/054-drop-function-using-jar.md 27 _docs/en/sql-reference/sql-commands/055-drop-table.md 242 _docs/en/sql-reference/sql-commands/056-drop-view.md 61 _docs/en/sql-reference/sql-commands/070-explain.md 127 _docs/en/sql-reference/sql-commands/071-lateral-join.md 326 _docs/en/sql-reference/sql-commands/079-select.md 56 _docs/en/sql-reference/sql-commands/080-select-list.md 56 _docs/en/sql-reference/sql-commands/081-from-clause.md 141 _docs/en/sql-reference/sql-commands/082-group-by-clause.md 52 _docs/en/sql-reference/sql-commands/083-having-clause.md 41 _docs/en/sql-reference/sql-commands/084-limit-clause.md 95 _docs/en/sql-reference/sql-commands/085-offset-clause.md 24 _docs/en/sql-reference/sql-commands/086-order-by-clause.md 50 _docs/en/sql-reference/sql-commands/087-set-operators.md 78 _docs/en/sql-reference/sql-commands/088-where-clause.md 66 _docs/en/sql-reference/sql-commands/089-with-clause.md 73 _docs/en/sql-reference/sql-commands/090-show-databases-and-show-schemas.md 48 _docs/en/sql-reference/sql-commands/100-show-files.md 52 _docs/en/sql-reference/sql-commands/110-show-tables.md 104 _docs/en/sql-reference/sql-commands/120-use.md 142 _docs/en/sql-reference/sql-commands/130-pivot-operators.md 118 _docs/en/sql-reference/sql-conditional-expressions/010-case-expression.md 42 _docs/en/sql-reference/sql-functions/005-about-sql-function-examples.md 12 _docs/en/sql-reference/sql-functions/010-math-and-trig.md 280 _docs/en/sql-reference/sql-functions/015-statistical.md 25 _docs/en/sql-reference/sql-functions/020-data-type-conversion.md 738 _docs/en/sql-reference/sql-functions/021-data-type-functions.md 48 _docs/en/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md 808 _docs/en/sql-reference/sql-functions/040-string-manipulation.md 554 _docs/en/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md 543 _docs/en/sql-reference/sql-functions/060-functions-for-handling-nulls.md 41 _docs/en/sql-reference/sql-functions/061-phonetic-functions.md 48 _docs/en/sql-reference/sql-functions/062-string-distance-functions.md 25 _docs/en/sql-reference/sql-functions/063-cryptography-functions.md 51 _docs/en/sql-reference/sql-functions/070-sql-dialect-compat-functions.md 121 _docs/en/sql-reference/sql-functions/080-gis-functions.md 46 _docs/en/sql-reference/sql-functions/090-time-series-analysis-functions.md 99 _docs/en/sql-reference/sql-functions/100-ip-net-functions.md 23 _docs/en/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md 163 _docs/en/sql-reference/sql-window-functions/020-aggregate-window-functions.md 142 _docs/en/sql-reference/sql-window-functions/030-ranking-window-functions.md 152 _docs/en/sql-reference/sql-window-functions/035-value-window-functions.md 106 _docs/en/sql-reference/sql-window-functions/040-sql-window-functions-examples.md 71 _docs/en/tutorials/010-tutorials-introduction.md 34 _docs/en/tutorials/020-drill-in-10-minutes.md 131 _docs/en/tutorials/030-analyzing-the-yelp-academic-dataset.md 333 _docs/en/tutorials/040-learn-drill-with-the-mapr-sandbox.md 30 _docs/en/tutorials/050-analyzing-highly-dynamic-datasets.md 145 _docs/en/tutorials/060-analyzing-social-media.md 150 _docs/en/tutorials/070-analyzing-data-using-window-functions.md 201 _docs/en/tutorials/080-orchestrating-queries-with-airflow.md 251 _docs/en/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md 15 _docs/en/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md 87 _docs/en/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md 91 _docs/en/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md 312 _docs/en/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md 309 _docs/en/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md 306 _docs/en/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md 12 _docs/zh/010-getting-started.md 5 _docs/zh/030-tutorials.md 6 _docs/zh/getting-started/010-drill-introduction.md 266 _docs/zh/getting-started/020-why-drill.md 65 _docs/zh/tutorials/010-tutorials-introduction.md 35 _docs/zh/tutorials/020-drill-in-10-minutes.md 126 _docs/zh/tutorials/030-analyzing-the-yelp-academic-dataset.md 311 _docs/zh/tutorials/040-learn-drill-with-the-mapr-sandbox.md 22 _docs/zh/tutorials/050-analyzing-highly-dynamic-datasets.md 146 _docs/zh/tutorials/060-analyzing-social-media.md 146 _docs/zh/tutorials/070-analyzing-data-using-window-functions.md 202 _docs/zh/tutorials/080-orchestrating-queries-with-airflow.md 241 _docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md 13 _docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md 82 _docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md 90 _docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md 239 _docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md 271 _docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md 272 _docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md 8 apidocs/legal/jquery.md 54 apidocs/legal/jqueryUI.md 36 blog/_posts/en/2014-11-13-sql-on-mongodb.md 117 blog/_posts/en/2014-12-03-drill-top-level-project.md 30 blog/_posts/en/2014-12-09-running-sql-queries-on-amazon-s3.md 61 blog/_posts/en/2014-12-11-apache-drill-qa-panelist-spotlight.md 37 blog/_posts/en/2014-12-16-whats-coming-in-2015.md 95 blog/_posts/en/2014-12-23-drill-0.7-released.md 18 blog/_posts/en/2015-01-27-schema-free-json-data-infrastructure.md 29 blog/_posts/en/2015-03-23-microstrategy-announces-drill-support.md 12 blog/_posts/en/2015-03-31-drill-0.8-released.md 20 blog/_posts/en/2015-04-30-apache-parquet-graudates-to-a-top-level-project.md 13 blog/_posts/en/2015-05-04-drill-0.9-released.md 27 blog/_posts/en/2015-05-19-drill-1.0-released.md 27 blog/_posts/en/2015-07-05-drill-1.1-released.md 43 blog/_posts/en/2015-07-23-drill-tutorial-at-nosql-now-2015.md 24 blog/_posts/en/2015-10-16-drill-1.2-released.md 29 blog/_posts/en/2015-11-23-drill-1.3-released.md 46 blog/_posts/en/2015-12-14-drill-1.4-released.md 38 blog/_posts/en/2016-02-16-drill-1.5-released.md 18 blog/_posts/en/2016-03-16-drill-1.6-released.md 14 blog/_posts/en/2016-06-28-drill-1.7-released.md 16 blog/_posts/en/2016-08-30-drill-1.8-released.md 20 blog/_posts/en/2016-11-29-drill-1.9-released.md 18 blog/_posts/en/2017-03-15-drill-1.10-released.md 20 blog/_posts/en/2017-07-31-drill-1.11-released.md 41 blog/_posts/en/2017-12-15-drill-1.12-released.md 47 blog/_posts/en/2018-03-18-drill-1.13-released.md 22 blog/_posts/en/2018-08-05-drill-1.14-released.md 21 blog/_posts/en/2018-10-16-drill-developer-day.md 8 blog/_posts/en/2018-10-16-drill-user-meetup.md 8 blog/_posts/en/2018-12-01-learning-apache-drill-book.md 21 blog/_posts/en/2018-12-31-drill-1.15-released.md 20 blog/_posts/en/2019-05-02-drill-1.16-released.md 24 blog/_posts/en/2019-05-02-drill-user-meetup.md 8 blog/_posts/en/2019-12-26-drill-1.17-released.md 25 blog/_posts/en/2020-09-05-drill-1.18-released.md 14 blog/_posts/en/2021-06-10-drill-1.19-released.md 25 blog/_posts/en/2021-07-09-streaming-data-from-the-rest-api.md 31 blog/_posts/en/2021-08-05-drill-provider-for-airflow.md 17 blog/_posts/en/2021-10-30-reports-of-my-death.md 14 blog/_posts/en/2022-02-04-2021-in-review.md 9 blog/_posts/en/2022-02-25-drill-1.20-released.md 26 blog/_posts/en/2022-05-16-drill-1.20.1-released.md 8 blog/_posts/en/2022-08-03-drill-1.20.2-released.md 8 blog/_posts/en/2023-01-07-drill-1.20.3-released.md 8 blog/_posts/en/2023-03-02-drill-1.21.0-released.md 49 blog/_posts/en/2023-04-29-drill-1.21.1-released.md 8 blog/_posts/en/2024-06-23-drill-1.21.2-released.md 8 blog/_posts/zh/2021-06-10-drill-1.19-released.md 26 community-resources.md 22 faq.md 85 fonts/icomoon/icomoon.svg 12 images/slack-logo.svg 99 mailinglists.md 22 static/sql-on-mongodb/empinfo.json 18 team.md 64