drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [2/2] drill git commit: Doc fix for DRILL-4772 and fix broken links in various pages
Date Wed, 05 Apr 2017 00:12:20 GMT
Doc fix for DRILL-4772 and fix broken links in various pages


Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/1e994acc
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/1e994acc
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/1e994acc

Branch: refs/heads/gh-pages
Commit: 1e994accf4f4a2447a434d6aa5fe3973fccc6204
Parents: 4a5dbd1
Author: Bridget Bevens <bbevens@maprtech.com>
Authored: Tue Apr 4 17:09:54 2017 -0700
Committer: Bridget Bevens <bbevens@maprtech.com>
Committed: Tue Apr 4 17:09:54 2017 -0700

----------------------------------------------------------------------
 .../020-hive-to-drill-data-type-mapping.md      |   7 +-
 ...using-apache-drill-with-tableau-9-desktop.md | 202 ++++++++++---------
 .../060-querying-the-information-schema.md      |   4 +-
 _docs/rn/009-1.2.0-rn.md                        |   2 +-
 _docs/rn/030-0.9.0-rn.md                        |   2 +-
 .../data-types/010-supported-data-types.md      |   6 +-
 .../data-types/020-date-time-and-timestamp.md   |   4 +-
 .../sql-commands/050-create-view.md             |   4 +-
 .../sql-commands/089-with-clause.md             |   4 +-
 _docs/sql-reference/sql-commands/120-use.md     |   6 +-
 10 files changed, 124 insertions(+), 117 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/1e994acc/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md
----------------------------------------------------------------------
diff --git a/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md b/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md
index 7d0e433..53993be 100644
--- a/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md
+++ b/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md
@@ -1,6 +1,6 @@
 ---
 title: "Hive-to-Drill Data Type Mapping"
-date: 2016-08-04 00:23:08 UTC
+date: 2017-04-05 00:09:55 UTC
 parent: "Data Sources and File Formats"
 ---
 Using Drill you can read tables created in Hive that use data types compatible with Drill.
Drill currently does not support writing Hive tables. The map of SQL types and Hive types
shows that several Hive types need to be cast to the supported SQL type in a Drill query:
@@ -8,7 +8,10 @@ Using Drill you can read tables created in Hive that use data types compatible
w
 * TINYINT and SMALLINT  
    Cast these types to INTEGER.  
 * BINARY  
-  Cast the Hive BINARY type to VARCHAR.
+  Cast the Hive BINARY type to VARCHAR.  
+
+{% include startnote.html %}In the 1.7 release, Drill automatically converts the Hive CHAR
data type to VARCHAR. You no longer need to cast the Hive CHAR data type to VARCHAR when querying
Hive tables.{% include endnote.html %}
+
 
 ## Map of SQL and Hive Types
 <!-- See DRILL-1570 -->

http://git-wip-us.apache.org/repos/asf/drill/blob/1e994acc/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md
b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md
index 5751768..5a48917 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md
@@ -1,99 +1,103 @@
----
-title: "Using Apache Drill with Tableau 9 Desktop"
-date:  
-parent: "Using Drill with BI Tools"
----
-This document describes how to connect Tableau 9 Desktop to Apache Drill and explore multiple
data formats instantly on Hadoop. Use the combined power of these tools to get direct access
to semi-structured data, without having to rely on IT teams for schema creation.
-
-To use Apache Drill with Tableau 9 Desktop, complete the following steps: 
-
-1. Install the Drill ODBC driver from MapR.
-2. Install the Tableau Data-connection Customization (TDC) file.
-3. Connect Tableau to Drill Using ODBC.
-4. Query and analyze various data formats with Tableau and Drill.
-
-----------
-
-### Step 1: Install and Configure the MapR Drill ODBC Driver 
-
-Drill uses standard ODBC connectivity to provide easy data-exploration capabilities on complex,
schema-less data sets. For the best experience use the latest release of Apache Drill. For
Tableau 9.0 Desktop, Drill Version 0.9 or higher is recommended.
-
-Complete the following steps to install and configure the driver:
-
-1. Download the 64-bit MapR Drill ODBC Driver for Windows from the following location:<br>
[http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/)
    
-**Note:** Tableau 9.0 Desktop 64 bit can use either the 32-bit driver or the 64-bit driver.
-2. [Install the ODBC driver on Windows]({{site.baseurl}}/docs/installing-the-driver-on-windows/).
-3. [Configure the driver]({{site.baseurl}}/docs/configuring-odbc-on-windows/).
-4. If Drill authentication is enabled, select **Basic Authentication** as the authentication
type. Enter a valid user and password. ![drill query flow]({{ site.baseurl }}/docs/img/tableau-odbc-setup.png)
-
-Note: If you select **ZooKeeper Quorum** as the ODBC connection type, the client system must
be able to resolve the hostnames of the ZooKeeper nodes. The simplest way is to add the hostnames
and IP addresses for the ZooKeeper nodes to the `%WINDIR%\system32\drivers\etc\hosts` file.
![drill query flow]({{ site.baseurl }}/docs/img/tableau-odbc-setup-2.png)
-
-Also make sure to test the ODBC connection to Drill before using it with Tableau.
-
-
-----------
-
-### Step 2: Install the Tableau Data-connection Customization (TDC) File
-
-The MapR Drill ODBC Driver includes a file named `MapRDrillODBC.TDC`. The TDC file includes
customizations that improve ODBC configuration and performance when using Tableau. The MapR
Drill ODBC driver installer automatically installs the TDC file if the installer can find
the Tableau installation. If you installed the MapR Drill ODBC driver first and then installed
Tableau, the TDC file is not installed automatically. You must install the TDC file manually.

-
-**To install the MapRDrillODBC.TDC file manually:**
-
-1. Click **Start**, and locate the Install Tableau TDC File app that the MapR Drill ODBC
Driver installer installed.   
-   For example, on Windows 8.1 in Apps, the Install Tableau TDC File appears under MaprDrill
ODBC Driver:
-   ![]({{ site.baseurl }}/docs/img/odbc-mapr-drill-apps.png)
-
-2. Click **Install Tableau TDC File**. 
-3. When the installation completes, press any key to continue.   
-For example, you can press the SPACEBAR key.
-
-If the installation of the TDC file fails, this is likely due to your Tableau repository
being in location other than the default one.  In this case, manually copy the My Tableau
Repository to C:\Users\<user>\Documents\My Tableau Repository. Repeat the procedure
to install the MapRDrillODBC.TDC file manually.
-
-----------
-
-
-### Step 3: Connect Tableau to Drill via ODBC
-Complete the following steps to configure an ODBC data connection: 
-
-To connect Tableau to Drill use the following steps:
-
-1.	In a Tableau Workbook click **Data > New Data Source**.![drill query flow]({{ site.baseurl
}}/docs/img/new-data-source.png)
-2.	In the **Connect** list, select **Other Databases (ODBC)**. ![drill query flow]({{ site.baseurl
}}/docs/img/connect-list.png)
-3.	On the Server Connection window, select the DSN configured in Step 1 from the drop-down
list of ODBC data sources. Then click **Connect**. Note: You will be prompted to enter a username
and password; these entries will be passed to the Server Connection window. 
-![drill query flow]({{ site.baseurl }}/docs/img/other-dbs.png) ![drill query flow]({{ site.baseurl
}}/docs/img/other-dbs-2.png)
-Tableau is now connected to Drill, and you can select various tables and views. ![drill query
flow]({{ site.baseurl }}/docs/img/tableau-schemas.png)
-4.	Click the **Schema** drop-down list and choose a schema by clicking the search icon: all
available Drill schemas will be displayed. When you have selected the schema, click the search
icon in the Table dialog box: all available tables or views will be displayed. 
-
-You can select tables and views to build a Tableau Visualization. You can also use custom
SQL by clicking the **New Custom SQL** option. 
-
-Tableau can natively work with Hive tables and Drill views. For Drill data sources, including
directly accessible  file systems or HBase/MapR-DB tables, you can either use the Custom SQL
option, or you can create a view in Drill to easily represent the complex data to Tableau.
For more information, see the following links:
-http://drill.apache.org/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool/
-http://drill.apache.org/docs/tableau-examples/
-
-Note: If Drill authentication and impersonation is enabled, only the views that the user
has access to will be displayed in the Table dialog box. Also, if custom SQL is being used
to try and access data sources that the user does not have access to, an error message will
be displayed. ![drill query flow]({{ site.baseurl }}/docs/img/tableau-error.png)
-
-----------
-
-### Step 4: Query and Analyze the Data 
-
-Tableau Desktop can now use Drill to query various data sources and visualize the information.
-
-Assume that a retailer has weblog data stored as JSON files in a nested directory structure
and product information stored in a Hive table. Using Drill and Tableau, users would like
to understand the volume of product sold by state and product category.
-
-1.	Using the New Custom SQL function in Tableau, write a Drill query to read the JSON files
without the need for ETL. Casting data types is recommended when you are working directly
with files. 
-For example: ![drill query flow]({{ site.baseurl }}/docs/img/edit-custom-sql.png)
-
-2.	Next select the Hive products table: ![drill query flow]({{ site.baseurl }}/docs/img/custom-sql-query.png)
-
-3.	Verify that Tableau is joining the two data sources (JSON files and Hive table) on the
prod_id key:![drill query flow]({{ site.baseurl }}/docs/img/tableau-join-key.png)
-The data sources are now configured and ready to be used in the visualization.
-4.	Drag State from the Custom SQL (JSON files) to **Columns**, and drag Category from the
Hive products table to **Rows**. 
-5.	Create a calculated field called `Total Number of Products` and enter `count(prod_id)`
for the `prod_id` field from the weblog files (Custom SQL), then drag it to **Rows** next
to Category. The visualization will now show the total products by category and state. 
-6.	To filter out weblog data where products were not bought, drag the `purch_flag` field
from the weblog files to **Filters**. Select only data where the `purch_flag` was true.
-7.	Finally, order the data from the state with the most products sold to the one with the
least.
-8.	Add a grand total row by clicking **Analysis > Totals > Show Column Grand Totals**.
![drill query flow]({{ site.baseurl }}/docs/img/tableau-desktop-query.png)
-
-----------
-
-In this quick tutorial, you saw how you can configure Tableau Desktop 9.0 to work with Apache
Drill. 
-
+---
+title: "Using Apache Drill with Tableau 9 Desktop"
+date: 2017-04-05 00:09:55 UTC
+parent: "Using Drill with BI Tools"
+---
+This document describes how to connect Tableau 9 Desktop to Apache Drill and explore multiple
data formats instantly on Hadoop. Use the combined power of these tools to get direct access
to semi-structured data, without having to rely on IT teams for schema creation.
+
+To use Apache Drill with Tableau 9 Desktop, complete the following steps: 
+
+1. Install the Drill ODBC driver from MapR.
+2. Install the Tableau Data-connection Customization (TDC) file.
+3. Connect Tableau to Drill Using ODBC.
+4. Query and analyze various data formats with Tableau and Drill.
+
+----------
+
+### Step 1: Install and Configure the MapR Drill ODBC Driver 
+
+Drill uses standard ODBC connectivity to provide easy data-exploration capabilities on complex,
schema-less data sets. For the best experience use the latest release of Apache Drill. For
Tableau 9.0 Desktop, Drill Version 0.9 or higher is recommended.
+
+Complete the following steps to install and configure the driver:
+
+1. Download the 64-bit MapR Drill ODBC Driver for Windows from the following location:<br>
[http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/)
    
+**Note:** Tableau 9.0 Desktop 64 bit can use either the 32-bit driver or the 64-bit driver.
+2. [Install the ODBC driver on Windows]({{site.baseurl}}/docs/installing-the-driver-on-windows/).
+3. [Configure the driver]({{site.baseurl}}/docs/configuring-odbc-on-windows/).
+4. If Drill authentication is enabled, select **Basic Authentication** as the authentication
type. Enter a valid user and password. ![drill query flow]({{ site.baseurl }}/docs/img/tableau-odbc-setup.png)
+
+Note: If you select **ZooKeeper Quorum** as the ODBC connection type, the client system must
be able to resolve the hostnames of the ZooKeeper nodes. The simplest way is to add the hostnames
and IP addresses for the ZooKeeper nodes to the `%WINDIR%\system32\drivers\etc\hosts` file.
![drill query flow]({{ site.baseurl }}/docs/img/tableau-odbc-setup-2.png)
+
+Also make sure to test the ODBC connection to Drill before using it with Tableau.
+
+
+----------
+
+### Step 2: Install the Tableau Data-connection Customization (TDC) File
+
+The MapR Drill ODBC Driver includes a file named `MapRDrillODBC.TDC`. The TDC file includes
customizations that improve ODBC configuration and performance when using Tableau. The MapR
Drill ODBC driver installer automatically installs the TDC file if the installer can find
the Tableau installation. If you installed the MapR Drill ODBC driver first and then installed
Tableau, the TDC file is not installed automatically. You must install the TDC file manually.

+
+**To install the MapRDrillODBC.TDC file manually:**
+
+1. Click **Start**, and locate the Install Tableau TDC File app that the MapR Drill ODBC
Driver installer installed.   
+   For example, on Windows 8.1 in Apps, the Install Tableau TDC File appears under MaprDrill
ODBC Driver:
+   ![]({{ site.baseurl }}/docs/img/odbc-mapr-drill-apps.png)
+
+2. Click **Install Tableau TDC File**. 
+3. When the installation completes, press any key to continue.   
+For example, you can press the SPACEBAR key.
+
+If the installation of the TDC file fails, this is likely due to your Tableau repository
being in location other than the default one.  In this case, manually copy the My Tableau
Repository to C:\Users\<user>\Documents\My Tableau Repository. Repeat the procedure
to install the MapRDrillODBC.TDC file manually.
+
+----------
+
+
+### Step 3: Connect Tableau to Drill via ODBC
+Complete the following steps to configure an ODBC data connection: 
+
+To connect Tableau to Drill use the following steps:
+
+1.	In a Tableau Workbook click **Data > New Data Source**.![drill query flow]({{ site.baseurl
}}/docs/img/new-data-source.png)
+2.	In the **Connect** list, select **Other Databases (ODBC)**. ![drill query flow]({{ site.baseurl
}}/docs/img/connect-list.png)
+3.	On the Server Connection window, select the DSN configured in Step 1 from the drop-down
list of ODBC data sources. Then click **Connect**. Note: You will be prompted to enter a username
and password; these entries will be passed to the Server Connection window. 
+![drill query flow]({{ site.baseurl }}/docs/img/other-dbs.png) ![drill query flow]({{ site.baseurl
}}/docs/img/other-dbs-2.png)
+Tableau is now connected to Drill, and you can select various tables and views. ![drill query
flow]({{ site.baseurl }}/docs/img/tableau-schemas.png)
+4.	Click the **Schema** drop-down list and choose a schema by clicking the search icon: all
available Drill schemas will be displayed. When you have selected the schema, click the search
icon in the Table dialog box: all available tables or views will be displayed. 
+
+You can select tables and views to build a Tableau Visualization. You can also use custom
SQL by clicking the **New Custom SQL** option. 
+
+Tableau can natively work with Hive tables and Drill views. For Drill data sources, including
directly accessible  file systems or HBase/MapR-DB tables, you can either use the Custom SQL
option, or you can create a view in Drill to easily represent the complex data to Tableau.
For more information, refer to the following pages:  
+
+
+- [https://drill.apache.org/docs/using-drill-with-bi-tools/](https://drill.apache.org/docs/using-drill-with-bi-tools/)
 
+- [http://drill.apache.org/docs/tableau-examples/](http://drill.apache.org/docs/tableau-examples/)
+
+
+
+Note: If Drill authentication and impersonation is enabled, only the views that the user
has access to will be displayed in the Table dialog box. Also, if custom SQL is being used
to try and access data sources that the user does not have access to, an error message will
be displayed. ![drill query flow]({{ site.baseurl }}/docs/img/tableau-error.png)
+
+----------
+
+### Step 4: Query and Analyze the Data 
+
+Tableau Desktop can now use Drill to query various data sources and visualize the information.
+
+Assume that a retailer has weblog data stored as JSON files in a nested directory structure
and product information stored in a Hive table. Using Drill and Tableau, users would like
to understand the volume of product sold by state and product category.
+
+1.	Using the New Custom SQL function in Tableau, write a Drill query to read the JSON files
without the need for ETL. Casting data types is recommended when you are working directly
with files. 
+For example: ![drill query flow]({{ site.baseurl }}/docs/img/edit-custom-sql.png)
+
+2.	Next select the Hive products table: ![drill query flow]({{ site.baseurl }}/docs/img/custom-sql-query.png)
+
+3.	Verify that Tableau is joining the two data sources (JSON files and Hive table) on the
prod_id key:![drill query flow]({{ site.baseurl }}/docs/img/tableau-join-key.png)
+The data sources are now configured and ready to be used in the visualization.
+4.	Drag State from the Custom SQL (JSON files) to **Columns**, and drag Category from the
Hive products table to **Rows**. 
+5.	Create a calculated field called `Total Number of Products` and enter `count(prod_id)`
for the `prod_id` field from the weblog files (Custom SQL), then drag it to **Rows** next
to Category. The visualization will now show the total products by category and state. 
+6.	To filter out weblog data where products were not bought, drag the `purch_flag` field
from the weblog files to **Filters**. Select only data where the `purch_flag` was true.
+7.	Finally, order the data from the state with the most products sold to the one with the
least.
+8.	Add a grand total row by clicking **Analysis > Totals > Show Column Grand Totals**.
![drill query flow]({{ site.baseurl }}/docs/img/tableau-desktop-query.png)
+
+----------
+
+In this quick tutorial, you saw how you can configure Tableau Desktop 9.0 to work with Apache
Drill. 
+

http://git-wip-us.apache.org/repos/asf/drill/blob/1e994acc/_docs/query-data/060-querying-the-information-schema.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/060-querying-the-information-schema.md b/_docs/query-data/060-querying-the-information-schema.md
index 28214fe..d151bf8 100644
--- a/_docs/query-data/060-querying-the-information-schema.md
+++ b/_docs/query-data/060-querying-the-information-schema.md
@@ -1,6 +1,6 @@
 ---
 title: "Querying the INFORMATION SCHEMA"
-date:  
+date: 2017-04-05 00:09:56 UTC
 parent: "Query Data"
 ---
 When you are using Drill to connect to multiple data sources, you need a
@@ -108,4 +108,4 @@ of those columns:
     | OrderTotal  | Decimal    |
     +-------------+------------+
 
-In this release, Drill disables the DECIMAL data type, including casting to DECIMAL and reading
DECIMAL types from Parquet and Hive. You can [enable the DECIMAL type](docs/supported-data-types/#enabling-the-decimal-type),
but this is not recommended.
+In this release, Drill disables the DECIMAL data type, including casting to DECIMAL and reading
DECIMAL types from Parquet and Hive. You can [enable the DECIMAL type]({{ site.baseurl }}/docs/supported-data-types/#enabling-the-decimal-type),
but this is not recommended.

http://git-wip-us.apache.org/repos/asf/drill/blob/1e994acc/_docs/rn/009-1.2.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/009-1.2.0-rn.md b/_docs/rn/009-1.2.0-rn.md
index d3cec4d..572db45 100644
--- a/_docs/rn/009-1.2.0-rn.md
+++ b/_docs/rn/009-1.2.0-rn.md
@@ -14,7 +14,7 @@ Today we're happy to announce the availability of Drill 1.2.0, providing
more th
 
 This release of Drill introduces a number of enhancements, including the following ones:
 
-* Support for JDBC data sources, such as MySQL, through a [new JDBC Storage plugin]({{site.baseurl}}/docs/jdbc-storage-plugin/)
 
+* Support for JDBC data sources, such as MySQL, through a [new JDBC Storage plugin]({{site.baseurl}}/docs/rdbms-storage-plugin/#example:-working-with-mysql)
 
 * Improvements in the Drill JDBC driver including inclusion of
 [Javadocs]({{site.baseurl}}/api/1.2/jdbc/) and better application dependency compatibility
 
 * Enhancements to Avro file formats  

http://git-wip-us.apache.org/repos/asf/drill/blob/1e994acc/_docs/rn/030-0.9.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/030-0.9.0-rn.md b/_docs/rn/030-0.9.0-rn.md
index edae5c8..fcc5b8e 100755
--- a/_docs/rn/030-0.9.0-rn.md
+++ b/_docs/rn/030-0.9.0-rn.md
@@ -2,7 +2,7 @@
 title: "Apache Drill 0.9.0 Release Notes"
 parent: "Release Notes"
 ---
-It has been about a month since the release of Drill 0.8, which included [more than 240 improvements]({{
site.baseurl }}/blog/drill-0.8-released/). Today we're happy to announce the availability
of Drill 0.9, providing additional enhancements and bug fixes. In fact, this release includes
[200 resolved JIRAs](https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12328813).
Some of the noteworthy features in Drill 0.9 are:
+It has been about a month since the release of Drill 0.8, which included [more than 240 improvements]({{
site.baseurl }}/blog/2016/08/30/drill-1.8-released/). Today we're happy to announce the availability
of Drill 0.9, providing additional enhancements and bug fixes. In fact, this release includes
[200 resolved JIRAs](https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12328813).
Some of the noteworthy features in Drill 0.9 are:
 
 * **Authentication** ([DRILL-2674](https://issues.apache.org/jira/browse/DRILL-2674)). Drill
now supports username/password authentication through the Java and C++ clients, as well as
JDBC and ODBC. On the server-side, Drill leverages Linux PAM to securely validate the credentials.
Users can choose to use an external user directory such as Active Directory or LDAP. To enable
authentication, set the `security.user.auth` option in `drill-override.conf`.
 * **Impersonation** ([DRILL-2363](https://issues.apache.org/jira/browse/DRILL-2363)). Queries
now execute and access resources using the identity of the user who submitted the query. Previously,
all queries would run as the same user (eg, `drill`). With the new impersonation capability,
the query will fail if the submitting user does not have permission to read the requested
file(s) in the distributed file system. To enable impersonation, set the `drill.exec.impersonation`
option in `drill-override.conf`.

http://git-wip-us.apache.org/repos/asf/drill/blob/1e994acc/_docs/sql-reference/data-types/010-supported-data-types.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/data-types/010-supported-data-types.md b/_docs/sql-reference/data-types/010-supported-data-types.md
index 5f8a31f..28560c3 100644
--- a/_docs/sql-reference/data-types/010-supported-data-types.md
+++ b/_docs/sql-reference/data-types/010-supported-data-types.md
@@ -1,6 +1,6 @@
 ---
 title: "Supported Data Types"
-date:  
+date: 2017-04-05 00:09:57 UTC
 parent: "Data Types"
 ---
 Drill reads from and writes to data sources having a wide variety of types. 
@@ -22,10 +22,10 @@ Drill reads from and writes to data sources having a wide variety of types.
 | CHARACTER VARYING, CHARACTER, CHAR,**** or VARCHAR   | UTF8-encoded variable-length string.
The default limit is 1 character. The maximum character limit is 2,147,483,647.   | CHAR(30)
casts data to a 30-character string maximum.                          |
 
 
-\* In this release, Drill disables the DECIMAL data type (an alpha feature), including casting
to DECIMAL and reading DECIMAL types from Parquet and Hive. The NUMERIC data type is an alias
for the DECIMAL data type.  
+\* In the 1.0 release, Drill disables the DECIMAL data type (an alpha feature), including
casting to DECIMAL and reading DECIMAL types from Parquet and Hive. The NUMERIC data type
is an alias for the DECIMAL data type.  
 \*\* Internally, INTERVAL is represented as INTERVALDAY or INTERVALYEAR.  
 \*\*\* SMALLINT is not currently supported.  
-\*\*\*\* Currently, Drill supports only variable-length strings.  
+\*\*\*\* The CHAR data type is internally represented as VARCHAR by Drill.  
 
 ## Enabling the DECIMAL Type
 

http://git-wip-us.apache.org/repos/asf/drill/blob/1e994acc/_docs/sql-reference/data-types/020-date-time-and-timestamp.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/data-types/020-date-time-and-timestamp.md b/_docs/sql-reference/data-types/020-date-time-and-timestamp.md
index ecc026c..9d9e715 100644
--- a/_docs/sql-reference/data-types/020-date-time-and-timestamp.md
+++ b/_docs/sql-reference/data-types/020-date-time-and-timestamp.md
@@ -1,6 +1,6 @@
 ---
 title: "Date, Time, and Timestamp"
-date: 2017-04-04 00:05:30 UTC
+date: 2017-04-05 00:09:57 UTC
 parent: "Data Types"
 ---
 Using familiar date and time formats, listed in the [SQL data types table]({{ site.baseurl
}}/docs/supported-data-types), you can construct query date and time data. You need to cast
textual data to date and time data types. The format of date, time, and timestamp text in
a textual data source needs to match the SQL query format for successful casting. Drill supports
date, time, timestamp, and interval literals shown in the following example:
@@ -115,7 +115,7 @@ The following examples show the input and output format of INTERVAL YEAR
(Year,
 
 DATE, TIME, and TIMESTAMP literals. Drill stores values in Coordinated Universal Time (UTC).
Drill supports time functions in the range 1971 to 2037.
 
-Drill does not support TIMESTAMP with time zone; however, if your data includes the time
zone, use the [TO_TIMESTAMP function]({{ site.baseurl }}/docs/casting/converting-data-types/#to_timestamp)
and [Joda format specifiers]({{site.baseurl}}/docs/data-type-conversion/#format-specifiers-for-date/time-conversions)
as shown the examples in section, ["Time Zone Limitation"]({{site.baseurl}}/docs/data-type-conversion/#time-zone-limitation).
+Drill does not support TIMESTAMP with time zone; however, if your data includes the time
zone, use the [TO_TIMESTAMP function]({{ site.baseurl }}/docs/data-type-conversion/#other-data-type-conversions)
and [Joda format specifiers]({{site.baseurl}}/docs/data-type-conversion/#format-specifiers-for-date/time-conversions)
as shown the examples in section, ["Time Zone Limitation"]({{site.baseurl}}/docs/data-type-conversion/#time-zone-limitation).
 
 Next, use the following literals in a SELECT statement. 
 

http://git-wip-us.apache.org/repos/asf/drill/blob/1e994acc/_docs/sql-reference/sql-commands/050-create-view.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/050-create-view.md b/_docs/sql-reference/sql-commands/050-create-view.md
index e76a1d3..88d8cc4 100644
--- a/_docs/sql-reference/sql-commands/050-create-view.md
+++ b/_docs/sql-reference/sql-commands/050-create-view.md
@@ -1,6 +1,6 @@
 ---
 title: "CREATE VIEW"
-date: 2016-05-05 21:44:33 UTC
+date: 2017-04-05 00:09:58 UTC
 parent: "SQL Commands"
 ---
 The CREATE VIEW command creates a virtual structure for the result set of a
@@ -28,7 +28,7 @@ generate the same set of columns with the same column names and data types.
 _workspace_  
 The location where you want the view to exist. By default, the view is created
 in the current workspace. See
-[Workspaces]({{ site.baseurl }}/docs/Workspaces).
+[Workspaces]({{ site.baseurl }}/docs/workspaces/).
 
 _view_name_  
 The name that you give the view. The view must have a unique name. It cannot

http://git-wip-us.apache.org/repos/asf/drill/blob/1e994acc/_docs/sql-reference/sql-commands/089-with-clause.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/089-with-clause.md b/_docs/sql-reference/sql-commands/089-with-clause.md
index 5e77cbf..0773433 100644
--- a/_docs/sql-reference/sql-commands/089-with-clause.md
+++ b/_docs/sql-reference/sql-commands/089-with-clause.md
@@ -1,6 +1,6 @@
 ---
 title: "WITH Clause"
-date:  
+date: 2017-04-05 00:09:58 UTC
 parent: "SQL Commands"
 ---
 The WITH clause is an optional clause used to contain one or more common table
@@ -32,7 +32,7 @@ less than the number of columns defined by the subquery.
 
 *query*  
 Any SELECT query that Drill supports. See
-[SELECT]({{ site.baseurl }}/docs/SELECT+Statements).
+[SELECT]({{ site.baseurl }}/docs/select/).
 
 ## Usage Notes
 

http://git-wip-us.apache.org/repos/asf/drill/blob/1e994acc/_docs/sql-reference/sql-commands/120-use.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/120-use.md b/_docs/sql-reference/sql-commands/120-use.md
index 395f716..db2c60d 100644
--- a/_docs/sql-reference/sql-commands/120-use.md
+++ b/_docs/sql-reference/sql-commands/120-use.md
@@ -1,12 +1,12 @@
 ---
 title: "USE"
-date: 2017-03-14 22:11:03 UTC
+date: 2017-04-05 00:09:59 UTC
 parent: "SQL Commands"
 ---
 The USE command changes the schema context to the specified schema. When you
 issue the USE command to switch to a particular schema, Drill queries that
 schema only.
-**Note:** You must include the full path to a file or table whenever there is a temporary
table in the session with the same name. See [CTTAS]({{site.baseurl}}/docs/create-temp-table-as).

+**Note:** You must include the full path to a file or table whenever there is a temporary
table in the session with the same name. See [CTTAS]({{site.baseurl}}/docs/create-temporary-table-as-cttas/).

 
 ## Syntax
 
@@ -22,7 +22,7 @@ plugin, such as hive, or a storage plugin and workspace. For example, in
dfs.don
 The workspace points to a directory
 within the file system. You can configure and use multiple storage plugins and
 workspaces in Drill. See [Storage Plugin Registration]({{ site.baseurl }}/docs/storage-plugin-registration)
and
-[Workspaces]({{ site.baseurl }}/docs/Workspaces).
+[Workspaces]({{ site.baseurl }}/docs/workspaces/).
 
 ## Usage Notes
 


Mime
View raw message