Return-Path: X-Original-To: apmail-drill-commits-archive@www.apache.org Delivered-To: apmail-drill-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BA805180EA for ; Mon, 4 May 2015 19:26:34 +0000 (UTC) Received: (qmail 96730 invoked by uid 500); 4 May 2015 19:26:34 -0000 Delivered-To: apmail-drill-commits-archive@drill.apache.org Received: (qmail 96646 invoked by uid 500); 4 May 2015 19:26:34 -0000 Mailing-List: contact commits-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: commits@drill.apache.org Delivered-To: mailing list commits@drill.apache.org Received: (qmail 95889 invoked by uid 99); 4 May 2015 19:26:34 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 May 2015 19:26:34 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 0D383E09B2; Mon, 4 May 2015 19:26:34 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: tshiran@apache.org To: commits@drill.apache.org Date: Mon, 04 May 2015 19:26:49 -0000 Message-Id: <41036e48dd6442ea907eb81b8a102151@git.apache.org> In-Reply-To: <4d522f2cbb3a4fb98f9eb392f0c84959@git.apache.org> References: <4d522f2cbb3a4fb98f9eb392f0c84959@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [17/51] [partial] drill-site git commit: Initial commit http://git-wip-us.apache.org/repos/asf/drill-site/blob/c4de0f83/docs/describe-command/index.html ---------------------------------------------------------------------- diff --git a/docs/describe-command/index.html b/docs/describe-command/index.html new file mode 100644 index 0000000..effbc38 --- /dev/null +++ b/docs/describe-command/index.html @@ -0,0 +1,934 @@ + + + + + + + + + +DESCRIBE Command - Apache Drill + + + + + + + + + + + + + + + + + + + + + + +
+
+ + + + + + + + + + + + + + +
+
+ + + + + +
+

DESCRIBE Command

+ +
+ + + +
+ +

The DESCRIBE command returns information about columns in a table or view.

+ +

Syntax

+ +

The DESCRIBE command supports the following syntax:

+
DESCRIBE [workspace.]table_name|view_name
+
+

Usage Notes

+ +

You can issue the DESCRIBE command against views created in a workspace and +tables created in Hive, HBase, and MapR-DB. You can issue the DESCRIBE command +on a table or view from any schema. For example, if you are working in the +dfs.myworkspace schema, you can issue the DESCRIBE command on a view or +table in another schema. Currently, DESCRIBE does not support tables created +in a file system.

+ +

Drill only supports SQL data types. Verify that all data types in an external +data source, such as Hive or HBase, map to supported data types in Drill. See +Drill Data Type Mapping for more information.

+ +

Example

+ +

The following example demonstrates the steps that you can follow when you want +to use the DESCRIBE command to see column information for a view and for Hive +and HBase tables.

+ +

Complete the following steps to use the DESCRIBE command:

+ +
    +

  1. Issue the USE command to switch to a particular schema.

    +
    0: jdbc:drill:zk=drilldemo:5181> use hive;
++------------+------------+
+|   ok  |  summary   |
++------------+------------+
+| true      | Default schema changed to 'hive' |
++------------+------------+
+1 row selected (0.025 seconds)
+
    2. +

  2. Issue the SHOW TABLES command to see the existing tables in the schema.

    +
    0: jdbc:drill:zk=drilldemo:5181> show tables;
++--------------+------------+
+| TABLE_SCHEMA | TABLE_NAME |
++--------------+------------+
+| hive.default | orders     |
+| hive.default | products   |
++--------------+------------+
+2 rows selected (0.438 seconds)
+
    3. +

  3. Issue the DESCRIBE command on a table.

    +
    0: jdbc:drill:zk=drilldemo:5181> describe orders;
++-------------+------------+-------------+
+| COLUMN_NAME | DATA_TYPE  | IS_NULLABLE |
++-------------+------------+-------------+
+| order_id  | BIGINT    | YES       |
+| month     | VARCHAR   | YES       |
+| purchdate   | TIMESTAMP  | YES        |
+| cust_id   | BIGINT    | YES       |
+| state     | VARCHAR   | YES       |
+| prod_id   | BIGINT    | YES       |
+| order_total | INTEGER | YES       |
++-------------+------------+-------------+
+7 rows selected (0.64 seconds)
+
    4. +

  4. Issue the DESCRIBE command on a table in another schema from the current schema.

    +
    0: jdbc:drill:zk=drilldemo:5181> describe hbase.customers;
++-------------+------------+-------------+
+| COLUMN_NAME | DATA_TYPE  | IS_NULLABLE |
++-------------+------------+-------------+
+| row_key   | ANY       | NO        |
+| address   | (VARCHAR(1), ANY) MAP | NO        |
+| loyalty   | (VARCHAR(1), ANY) MAP | NO        |
+| personal  | (VARCHAR(1), ANY) MAP | NO        |
++-------------+------------+-------------+
+4 rows selected (0.671 seconds)
+
    5. +

  5. Issue the DESCRIBE command on a view in another schema from the current schema.

    +
    0: jdbc:drill:zk=drilldemo:5181> describe dfs.views.customers_vw;
++-------------+------------+-------------+
+| COLUMN_NAME | DATA_TYPE  | IS_NULLABLE |
++-------------+------------+-------------+
+| cust_id   | BIGINT    | NO        |
+| name      | VARCHAR   | NO        |
+| address   | VARCHAR   | NO        |
+| gender    | VARCHAR   | NO        |
+| age       | VARCHAR   | NO        |
+| agg_rev   | VARCHAR   | NO        |
+| membership  | VARCHAR | NO        |
++-------------+------------+-------------+
+7 rows selected (0.403 seconds)
+
    6. +
+ + + +
+ + ← CREATE VIEW commandEXPLAIN commands → +
+ + +
+
+
+ +
+

+ + + + + + http://git-wip-us.apache.org/repos/asf/drill-site/blob/c4de0f83/docs/design-docs/index.html ---------------------------------------------------------------------- diff --git a/docs/design-docs/index.html b/docs/design-docs/index.html new file mode 100644 index 0000000..41880fe --- /dev/null +++ b/docs/design-docs/index.html @@ -0,0 +1,858 @@ + + + + + + + + + +Design Docs - Apache Drill + + + + + + + + + + + + + + + + + + + + + + +
+
+ + + + + + + + + + + + + + +
+
+ + + + + +
+

Design Docs

+ +
+ + + +
+ + + + +
+ + ← Apache Drill Contribution IdeasDrill Plan Syntax → +
+ + +
+
+
+ +
+

+ + + + + +