drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [01/17] drill git commit: Updates to docs for 1.8 - DESCRIBE SCHEMA, DROP TABLE|VIEW IF EXISTS,
Date Tue, 30 Aug 2016 22:29:16 GMT
Repository: drill
Updated Branches:
  refs/heads/gh-pages 0602842d4 -> a0d5528eb


Updates to docs for 1.8 - DESCRIBE SCHEMA, DROP TABLE|VIEW IF EXISTS,


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

Branch: refs/heads/gh-pages
Commit: 400293902c8439ee9377258ad7e1e71b7a040092
Parents: 0602842
Author: Bridget Bevens <bbevens@maprtech.com>
Authored: Wed Aug 3 17:23:07 2016 -0700
Committer: Bridget Bevens <bbevens@maprtech.com>
Committed: Wed Aug 3 17:23:07 2016 -0700

----------------------------------------------------------------------
 .../020-hive-to-drill-data-type-mapping.md      |  6 +-
 _docs/query-data/050-querying-hive.md           |  6 +-
 _docs/sql-reference/080-reserved-keywords.md    |  4 +-
 .../sql-reference/sql-commands/053-describe.md  | 81 ++++++++++++++++----
 .../sql-commands/055-drop-table.md              | 65 +++++++++++++---
 .../sql-reference/sql-commands/056-drop-view.md | 47 ++++++++++--
 6 files changed, 173 insertions(+), 36 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/40029390/_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 fe196f6..7d0e433 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-06-29 01:29:05 UTC
+date: 2016-08-04 00:23:08 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:
@@ -86,7 +86,9 @@ You check that Hive mapped the data from the CSV to the typed values as
as expec
     8223372036854775807	true	3.5	-1231.4	3.14	42	"SomeText"	2015-03-25   2015-03-25 01:23:15
     Time taken: 0.524 seconds, Fetched: 1 row(s)
 
-### Connect Drill to Hive and Query the Data
+### Connect Drill to Hive and Query the Data  
+
+{% include startnote.html %}Drill 1.8 implements the IF EXISTS parameter for the DROP TABLE
and DROP VIEW commands, making IF a reserved word in Drill. As a result, you must include
backticks around the Hive \``IF`` conditional function when you use it in a query on Hive
tables. Alternatively, you can use the CASE statement instead of the IF function.{% include
endnote.html %}
 
 In Drill, you use the [Hive storage plugin]({{site.baseurl}}/docs/hive-storage-plugin). Using
the Hive storage plugin connects Drill to the Hive metastore containing the data.
 	

http://git-wip-us.apache.org/repos/asf/drill/blob/40029390/_docs/query-data/050-querying-hive.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/050-querying-hive.md b/_docs/query-data/050-querying-hive.md
index 422c9ac..46481e0 100644
--- a/_docs/query-data/050-querying-hive.md
+++ b/_docs/query-data/050-querying-hive.md
@@ -1,11 +1,13 @@
 ---
 title: "Querying Hive"
-date:  
+date: 2016-08-04 00:23:09 UTC
 parent: "Query Data"
 ---
 This is a simple exercise that provides steps for creating a Hive table and
 inserting data that you can query using Drill. Before you perform the steps,
-download the [customers.csv](http://doc.mapr.com/download/attachments/28868943/customers.csv?version=1&modificationDate=1426874930765&api=v2)
file.
+download the [customers.csv](http://doc.mapr.com/download/attachments/28868943/customers.csv?version=1&modificationDate=1426874930765&api=v2)
file.  
+
+{% include startnote.html %}Drill 1.8 implements the IF EXISTS parameter for the DROP TABLE
and DROP VIEW commands, making IF a reserved word in Drill. As a result, you must include
backticks around the Hive \``IF`` conditional function when you use it in a query on Hive
tables. Alternatively, you can use the CASE statement instead of the IF function.{% include
endnote.html %}
 
 To create a Hive table and query it with Drill, complete the following steps:
 

http://git-wip-us.apache.org/repos/asf/drill/blob/40029390/_docs/sql-reference/080-reserved-keywords.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/080-reserved-keywords.md b/_docs/sql-reference/080-reserved-keywords.md
index 7e14f3a..e631adf 100644
--- a/_docs/sql-reference/080-reserved-keywords.md
+++ b/_docs/sql-reference/080-reserved-keywords.md
@@ -1,6 +1,6 @@
 ---
 title: "Reserved Keywords"
-date:  
+date: 2016-08-04 00:23:09 UTC
 parent: "SQL Reference"
 ---
 When you use a reserved keyword in a Drill query, enclose the word in
@@ -13,5 +13,5 @@ keyword:
 The following table provides the Drill reserved keywords that require back
 ticks:
 
-<table ><tbody><tr><td valign="top" ><h1 id="ReservedKeywords-A">A</h1><p>ABS<br
/>ALL<br />ALLOCATE<br />ALLOW<br />ALTER<br />AND<br />ANY<br
/>ARE<br />ARRAY<br />AS<br />ASENSITIVE<br />ASYMMETRIC<br
/>AT<br />ATOMIC<br />AUTHORIZATION<br />AVG</p><h1 id="ReservedKeywords-B">B</h1><p>BEGIN<br
/>BETWEEN<br />BIGINT<br />BINARY<br />BIT<br />BLOB<br />BOOLEAN<br
/>BOTH<br />BY</p><h1 id="ReservedKeywords-C">C</h1><p>CALL<br
/>CALLED<br />CARDINALITY<br />CASCADED<br />CASE<br />CAST<br
/>CEIL<br />CEILING<br />CHAR<br />CHARACTER<br />CHARACTER_LENGTH<br
/>CHAR_LENGTH<br />CHECK<br />CLOB<br />CLOSE<br />COALESCE<br
/>COLLATE<br />COLLECT<br />COLUMN<br />COMMIT<br />CONDITION<br
/>CONNECT<br />CONSTRAINT<br />CONVERT<br />CORR<br />CORRESPONDING<br
/>COUNT<br />COVAR_POP<br />COVAR_SAMP<br />CREATE<br />CROSS<br
/>CUBE<br />CUME_DIST<br />CURRENT<br />CURRENT_CATALOG<br />CURRENT_DATE<br
/>CURRENT_DEFAULT_TRANSFORM_GROUP<br />CURRENT_PATH<br />CURRENT_ROLE<br
/>CURRENT_SCHEMA<br 
 />CURRENT_TIME<br />CURRENT_TIMESTAMP<br />CURRENT_TRANSFORM_GROUP_FOR_TYPE<br
/>CURRENT_USER<br />CURSOR<br />CYCLE</p></td><td valign="top"
><h1 id="ReservedKeywords-D">D</h1><p>DATABASES<br />DATE<br
/>DAY<br />DEALLOCATE<br />DEC<br />DECIMAL<br />DECLARE<br
/>DEFAULT<br />DEFAULT_KW<br />DELETE<br />DENSE_RANK<br />DEREF<br
/>DESCRIBE<br />DETERMINISTIC<br />DISALLOW<br />DISCONNECT<br />DISTINCT<br
/>DOUBLE<br />DROP<br />DYNAMIC</p><h1 id="ReservedKeywords-E">E</h1><p>EACH<br
/>ELEMENT<br />ELSE<br />END<br />END_EXEC<br />ESCAPE<br />EVERY<br
/>EXCEPT<br />EXEC<br />EXECUTE<br />EXISTS<br />EXP<br />EXPLAIN<br
/>EXTERNAL<br />EXTRACT</p><h1 id="ReservedKeywords-F">F</h1><p>FALSE<br
/>FETCH<br />FILES<br />FILTER<br />FIRST_VALUE<br />FLOAT<br
/>FLOOR<br />FOR<br />FOREIGN<br />FREE<br />FROM<br />FULL<br
/>FUNCTION<br />FUSION</p><h1 id="ReservedKeywords-G">G</h1><p>GET<br
/>GLOBAL<br />GRANT<br />GROUP<br />GROUPING</p><h1 id="ReservedKeywords-H">H</h1><p>HAVING<br
/>HOLD<b
 r />HOUR</p></td><td valign="top" ><h1 id="ReservedKeywords-I">I</h1><p>IDENTITY<br
/>IMPORT<br />IN<br />INDICATOR<br />INNER<br />INOUT<br />INSENSITIVE<br
/>INSERT<br />INT<br />INTEGER<br />INTERSECT<br />INTERSECTION<br
/>INTERVAL<br />INTO<br />IS</p><h1 id="ReservedKeywords-J">J</h1><p>JOIN</p><h1
id="ReservedKeywords-L">L</h1><p>LANGUAGE<br />LARGE<br />LAST_VALUE<br
/>LATERAL<br />LEADING<br />LEFT<br />LIKE<br />LIMIT<br />LN<br
/>LOCAL<br />LOCALTIME<br />LOCALTIMESTAMP<br />LOWER</p><h1
id="ReservedKeywords-M">M</h1><p>MATCH<br />MAX<br />MEMBER<br
/>MERGE<br />METHOD<br />MIN<br />MINUTE<br />MOD<br />MODIFIES<br
/>MODULE<br />MONTH<br />MULTISET</p><h1 id="ReservedKeywords-N">N</h1><p>NATIONAL<br
/>NATURAL<br />NCHAR<br />NCLOB<br />NEW<br />NO<br />NONE<br
/>NORMALIZE<br />NOT<br />NULL<br />NULLIF<br />NUMERIC</p><h1
id="ReservedKeywords-O">O</h1><p>OCTET_LENGTH<br />OF<br />OFFSET<br
/>OLD<br />ON<br />ONLY<br />OPEN<br />OR<br />ORDER<br
/>OUT<br />OUTER<br />OVER<
 br />OVERLAPS<br />OVERLAY</p></td><td valign="top" colspan="1" ><h1
id="ReservedKeywords-P">P</h1><p>PARAMETER<br />PARTITION<br />PERCENTILE_CONT<br
/>PERCENTILE_DISC<br />PERCENT_RANK<br />POSITION<br />POWER<br />PRECISION<br
/>PREPARE<br />PRIMARY<br />PROCEDURE</p><h1 id="ReservedKeywords-R">R</h1><p>RANGE<br
/>RANK<br />READS<br />REAL<br />RECURSIVE<br />REF<br />REFERENCES<br
/>REFERENCING<br />REGR_AVGX<br />REGR_AVGY<br />REGR_COUNT<br />REGR_INTERCEPT<br
/>REGR_R2<br />REGR_SLOPE<br />REGR_SXX<br />REGR_SXY<br />RELEASE<br
/>REPLACE<br />RESULT<br />RETURN<br />RETURNS<br />REVOKE<br
/>RIGHT<br />ROLLBACK<br />ROLLUP<br />ROW<br />ROWS<br />ROW_NUMBER</p><h1
id="ReservedKeywords-S">S</h1><p>SAVEPOINT<br />SCHEMAS<br />SCOPE<br
/>SCROLL<br />SEARCH<br />SECOND<br />SELECT<br />SENSITIVE<br
/>SESSION_USER<br />SET<br />SHOW<br />SIMILAR<br />SMALLINT<br
/>SOME<br />SPECIFIC<br />SPECIFICTYPE<br />SQL<br />SQLEXCEPTION<br
/>SQLSTATE<br />SQLWARNING<br />SQRT<br />START<br /
 >STATIC<br />STDDEV_POP<br />STDDEV_SAMP<br />SUBMULTISET<br />SUBSTRING<br
/>SUM<br />SYMMETRIC<br />SYSTEM<br />SYSTEM_USER</p></td><td
valign="top" colspan="1" ><h1 id="ReservedKeywords-T">T</h1><p>TABLE<br
/>TABLES<br />TABLESAMPLE<br />THEN<br />TIME<br />TIMESTAMP<br
/>TIMEZONE_HOUR<br />TIMEZONE_MINUTE<br />TINYINT<br />TO<br />TRAILING<br
/>TRANSLATE<br />TRANSLATION<br />TREAT<br />TRIGGER<br />TRIM<br
/>TRUE</p><h1 id="ReservedKeywords-U">U</h1><p>UESCAPE<br />UNION<br
/>UNIQUE<br />UNKNOWN<br />UNNEST<br />UPDATE<br />UPPER<br
/>USE<br />USER<br />USING</p><h1 id="ReservedKeywords-V">V</h1><p>VALUE<br
/>VALUES<br />VARBINARY<br />VARCHAR<br />VARYING<br />VAR_POP<br
/>VAR_SAMP</p><h1 id="ReservedKeywords-W">W</h1><p>WHEN<br />WHENEVER<br
/>WHERE<br />WIDTH_BUCKET<br />WINDOW<br />WITH<br />WITHIN<br
/>WITHOUT</p><h1 id="ReservedKeywords-Y">Y</h1><p>YEAR</p></td></tr></tbody></table></div>
+<table ><tbody><tr><td valign="top" ><h1 id="ReservedKeywords-A">A</h1><p>ABS<br
/>ALL<br />ALLOCATE<br />ALLOW<br />ALTER<br />AND<br />ANY<br
/>ARE<br />ARRAY<br />AS<br />ASENSITIVE<br />ASYMMETRIC<br
/>AT<br />ATOMIC<br />AUTHORIZATION<br />AVG</p><h1 id="ReservedKeywords-B">B</h1><p>BEGIN<br
/>BETWEEN<br />BIGINT<br />BINARY<br />BIT<br />BLOB<br />BOOLEAN<br
/>BOTH<br />BY</p><h1 id="ReservedKeywords-C">C</h1><p>CALL<br
/>CALLED<br />CARDINALITY<br />CASCADED<br />CASE<br />CAST<br
/>CEIL<br />CEILING<br />CHAR<br />CHARACTER<br />CHARACTER_LENGTH<br
/>CHAR_LENGTH<br />CHECK<br />CLOB<br />CLOSE<br />COALESCE<br
/>COLLATE<br />COLLECT<br />COLUMN<br />COMMIT<br />CONDITION<br
/>CONNECT<br />CONSTRAINT<br />CONVERT<br />CORR<br />CORRESPONDING<br
/>COUNT<br />COVAR_POP<br />COVAR_SAMP<br />CREATE<br />CROSS<br
/>CUBE<br />CUME_DIST<br />CURRENT<br />CURRENT_CATALOG<br />CURRENT_DATE<br
/>CURRENT_DEFAULT_TRANSFORM_GROUP<br />CURRENT_PATH<br />CURRENT_ROLE<br
/>CURRENT_SCHEMA<br 
 />CURRENT_TIME<br />CURRENT_TIMESTAMP<br />CURRENT_TRANSFORM_GROUP_FOR_TYPE<br
/>CURRENT_USER<br />CURSOR<br />CYCLE</p></td><td valign="top"
><h1 id="ReservedKeywords-D">D</h1><p>DATABASES<br />DATE<br
/>DAY<br />DEALLOCATE<br />DEC<br />DECIMAL<br />DECLARE<br
/>DEFAULT<br />DEFAULT_KW<br />DELETE<br />DENSE_RANK<br />DEREF<br
/>DESCRIBE<br />DETERMINISTIC<br />DISALLOW<br />DISCONNECT<br />DISTINCT<br
/>DOUBLE<br />DROP<br />DYNAMIC</p><h1 id="ReservedKeywords-E">E</h1><p>EACH<br
/>ELEMENT<br />ELSE<br />END<br />END_EXEC<br />ESCAPE<br />EVERY<br
/>EXCEPT<br />EXEC<br />EXECUTE<br />EXISTS<br />EXP<br />EXPLAIN<br
/>EXTERNAL<br />EXTRACT</p><h1 id="ReservedKeywords-F">F</h1><p>FALSE<br
/>FETCH<br />FILES<br />FILTER<br />FIRST_VALUE<br />FLOAT<br
/>FLOOR<br />FOR<br />FOREIGN<br />FREE<br />FROM<br />FULL<br
/>FUNCTION<br />FUSION</p><h1 id="ReservedKeywords-G">G</h1><p>GET<br
/>GLOBAL<br />GRANT<br />GROUP<br />GROUPING</p><h1 id="ReservedKeywords-H">H</h1><p>HAVING<br
/>HOLD<b
 r />HOUR</p></td><td valign="top" ><h1 id="ReservedKeywords-I">I</h1><p>IDENTITY<br
/>IF<br />IMPORT<br />IN<br />INDICATOR<br />INNER<br />INOUT<br
/>INSENSITIVE<br />INSERT<br />INT<br />INTEGER<br />INTERSECT<br
/>INTERSECTION<br />INTERVAL<br />INTO<br />IS</p><h1 id="ReservedKeywords-J">J</h1><p>JOIN</p><h1
id="ReservedKeywords-L">L</h1><p>LANGUAGE<br />LARGE<br />LAST_VALUE<br
/>LATERAL<br />LEADING<br />LEFT<br />LIKE<br />LIMIT<br />LN<br
/>LOCAL<br />LOCALTIME<br />LOCALTIMESTAMP<br />LOWER</p><h1
id="ReservedKeywords-M">M</h1><p>MATCH<br />MAX<br />MEMBER<br
/>MERGE<br />METHOD<br />MIN<br />MINUTE<br />MOD<br />MODIFIES<br
/>MODULE<br />MONTH<br />MULTISET</p><h1 id="ReservedKeywords-N">N</h1><p>NATIONAL<br
/>NATURAL<br />NCHAR<br />NCLOB<br />NEW<br />NO<br />NONE<br
/>NORMALIZE<br />NOT<br />NULL<br />NULLIF<br />NUMERIC</p><h1
id="ReservedKeywords-O">O</h1><p>OCTET_LENGTH<br />OF<br />OFFSET<br
/>OLD<br />ON<br />ONLY<br />OPEN<br />OR<br />ORDER<br
/>OUT<br />OUTER<br
  />OVER<br />OVERLAPS<br />OVERLAY</p></td><td valign="top"
colspan="1" ><h1 id="ReservedKeywords-P">P</h1><p>PARAMETER<br />PARTITION<br
/>PERCENTILE_CONT<br />PERCENTILE_DISC<br />PERCENT_RANK<br />POSITION<br
/>POWER<br />PRECISION<br />PREPARE<br />PRIMARY<br />PROCEDURE</p><h1
id="ReservedKeywords-R">R</h1><p>RANGE<br />RANK<br />READS<br
/>REAL<br />RECURSIVE<br />REF<br />REFERENCES<br />REFERENCING<br
/>REGR_AVGX<br />REGR_AVGY<br />REGR_COUNT<br />REGR_INTERCEPT<br
/>REGR_R2<br />REGR_SLOPE<br />REGR_SXX<br />REGR_SXY<br />RELEASE<br
/>REPLACE<br />RESULT<br />RETURN<br />RETURNS<br />REVOKE<br
/>RIGHT<br />ROLLBACK<br />ROLLUP<br />ROW<br />ROWS<br />ROW_NUMBER</p><h1
id="ReservedKeywords-S">S</h1><p>SAVEPOINT<br />SCHEMAS<br />SCOPE<br
/>SCROLL<br />SEARCH<br />SECOND<br />SELECT<br />SENSITIVE<br
/>SESSION_USER<br />SET<br />SHOW<br />SIMILAR<br />SMALLINT<br
/>SOME<br />SPECIFIC<br />SPECIFICTYPE<br />SQL<br />SQLEXCEPTION<br
/>SQLSTATE<br />SQLWARNING<br />SQRT<br />ST
 ART<br />STATIC<br />STDDEV_POP<br />STDDEV_SAMP<br />SUBMULTISET<br
/>SUBSTRING<br />SUM<br />SYMMETRIC<br />SYSTEM<br />SYSTEM_USER</p></td><td
valign="top" colspan="1" ><h1 id="ReservedKeywords-T">T</h1><p>TABLE<br
/>TABLES<br />TABLESAMPLE<br />THEN<br />TIME<br />TIMESTAMP<br
/>TIMEZONE_HOUR<br />TIMEZONE_MINUTE<br />TINYINT<br />TO<br />TRAILING<br
/>TRANSLATE<br />TRANSLATION<br />TREAT<br />TRIGGER<br />TRIM<br
/>TRUE</p><h1 id="ReservedKeywords-U">U</h1><p>UESCAPE<br />UNION<br
/>UNIQUE<br />UNKNOWN<br />UNNEST<br />UPDATE<br />UPPER<br
/>USE<br />USER<br />USING</p><h1 id="ReservedKeywords-V">V</h1><p>VALUE<br
/>VALUES<br />VARBINARY<br />VARCHAR<br />VARYING<br />VAR_POP<br
/>VAR_SAMP</p><h1 id="ReservedKeywords-W">W</h1><p>WHEN<br />WHENEVER<br
/>WHERE<br />WIDTH_BUCKET<br />WINDOW<br />WITH<br />WITHIN<br
/>WITHOUT</p><h1 id="ReservedKeywords-Y">Y</h1><p>YEAR</p></td></tr></tbody></table></div>
 

http://git-wip-us.apache.org/repos/asf/drill/blob/40029390/_docs/sql-reference/sql-commands/053-describe.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/053-describe.md b/_docs/sql-reference/sql-commands/053-describe.md
index 1a71f44..1bd347e 100644
--- a/_docs/sql-reference/sql-commands/053-describe.md
+++ b/_docs/sql-reference/sql-commands/053-describe.md
@@ -1,30 +1,51 @@
 ---
 title: "DESCRIBE"
-date:  
+date: 2016-08-04 00:23:09 UTC
 parent: "SQL Commands"
 ---
-The DESCRIBE command returns information about columns in a table or view.
+The DESCRIBE command returns information about columns in a table, view, or schema.
 
 ## Syntax
 
 The DESCRIBE command supports the following syntax:
 
     DESCRIBE [workspace.]table_name|view_name
+    DESCRIBE SCHEMA|DATABASE <name>[.workspace]
+
+
+##Parameters  
+*workspace*  
+The location, within a schema, where a table or view exists.  
+ 
+*view_name*  
+The unique name of a view.  
+
+*table_name*  
+The unique name of a table.  
+
+*schema/database*  
+A configured storage plugin instance with or without a configured workspace. 
+
 
 ## Usage Notes
 
-You can issue the DESCRIBE command against views created in a workspace and
-tables created in Hive and HBase. 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 [Data Types]({{site.baseurl}}/docs/data-types/)
for more information.  
 
-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.
+###DESCRIBE
+- You can issue the DESCRIBE command against views created in a workspace, tables created
in Hive and HBase, or schemas.  
+- 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, such hive or dfs.devworkspace.  
+- Currently, DESCRIBE does not support tables created in a file system.
 
-## Example
+###DESCRIBE SCHEMA  
+- You can issue the DESCRIBE SCHEMA command on any schema. However, you can only include
workspaces for file schemas, such as `dfs.myworkspace`.  
+- When you issue the DESCRIBE SCHEMA command on a particular schema, Drill returns all of
the schema properties. The schema properties correlate with the configuration information
in the Storage tab of the Drill Web Console for that schema.  
+- When you issue DESCRIBE SCHEMA against a schema and workspace, such as `dfs.myworkspace`,
Drill returns the workspace properties in addition to all of the schema properties.  
+- When you issue DESCRIBE SCHEMA against the `dfs` schema, Drill also returns the properties
of the “default” workspace. Issuing DESCRIBE SCHEMA against `dfs` or `` dfs.`default`
`` returns the same results. 
+
+
+## Examples
+
+###DESCRIBE  
 
 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
@@ -96,5 +117,37 @@ Complete the following steps to use the DESCRIBE command:
         | agg_rev   | VARCHAR   | NO        |
         | membership  | VARCHAR | NO        |
         +-------------+------------+-------------+
-        7 rows selected (0.403 seconds)
-
+        7 rows selected (0.403 seconds)  
+ 
+6. Issue the DESCRIBE SCHEMA command on `dfs.tmp` (the `dfs` schema and `tmp` workspace configured
within the `dfs` schema) from the current schema.  
+  
+        0: jdbc:drill:zk=drilldemo:5181> describe schema dfs.tmp;  
+       
+              {
+                "type" : "file",
+                "enabled" : true,
+                "connection" : "file:///",
+                "config" : null,
+                "formats" : {
+                  "psv" : {
+                    "type" : "text",
+                    "extensions" : [ "tbl" ],
+                    "delimiter" : "|"
+                  },
+                  "csv" : {
+                    "type" : "text",
+                    "extensions" : [ "csv", "bcp" ],
+                    "delimiter" : ","
+                  },
+                 ... 
+                },
+                "location" : "/tmp",
+                "writable" : true,
+                "defaultInputFormat" : null
+              }  
+
+
+
+       
+              
+       

http://git-wip-us.apache.org/repos/asf/drill/blob/40029390/_docs/sql-reference/sql-commands/055-drop-table.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/055-drop-table.md b/_docs/sql-reference/sql-commands/055-drop-table.md
index 8a1ea49..6857d25 100644
--- a/_docs/sql-reference/sql-commands/055-drop-table.md
+++ b/_docs/sql-reference/sql-commands/055-drop-table.md
@@ -1,17 +1,26 @@
 ---
 title: "DROP TABLE"
-date:  
+date: 2016-08-04 00:23:10 UTC
 parent: "SQL Commands"
 ---
 
-As of Drill 1.2, you can use the DROP TABLE command to remove tables (files or directories)
from a file system when the file system is configured as a DFS storage plugin. See [Storage
Plugin Registration]({{ site.baseurl }}/docs/storage-plugin-registration/). Currently, you
can only issue the DROP TABLE command against file system data sources.
+As of Drill 1.2, you can use the DROP TABLE command to remove tables (files or directories)
from a file system when the file system is configured as a DFS storage plugin. See [Storage
Plugin Registration]({{ site.baseurl }}/docs/storage-plugin-registration/). As of Drill 1.8,
you can include the IF EXISTS parameter with the DROP TABLE command. Currently, you can only
issue the DROP TABLE command against file system data sources.
 
 ## Syntax
 The DROP TABLE command supports the following syntax: 
 
-       DROP TABLE [workspace.]name;
+    DROP TABLE [IF EXISTS] [workspace.]name;  
 
-*name* is a unique directory or file name, optionally prefaced by a storage plugin name,
such as dfs, and a workspace, such as tmp using dot notation.
+## Parameters  
+
+IF EXISTS  
+Drill does not throw an error if the table does not exist. Instead, Drill returns "`Table
[name] not found.`"  
+
+*workspace*  
+The location of the table in subdirectories of a local or distributed file system.
+
+*name*  
+A unique directory or file name, optionally prefaced by a storage plugin name, such as `dfs`,
and a workspace, such as `tmp` using dot notation.  
 
 
 ## Usage Notes
@@ -200,7 +209,7 @@ Issuing the DROP TABLE command against the directory removes the directory
and d
 ###Example 4: Dropping a table that does not exist
 The following example shows the result of dropping a table that does not exist because it
was either already dropped or never existed. 
 
-       0: jdbc:drill:zk=local> use use dfs.tmp;
+       0: jdbc:drill:zk=local> use dfs.tmp;
        +-------+--------------------------------------+
        |  ok   |               summary                |
        +-------+--------------------------------------+
@@ -211,9 +220,47 @@ The following example shows the result of dropping a table that does
not exist b
        0: jdbc:drill:zk=local> drop table name_key;
 
        Error: VALIDATION ERROR: Table [name_key] not found
-       [Error Id: fc6bfe17-d009-421c-8063-d759d7ea2f4e on 10.250.56.218:31010] (state=,code=0)
+       [Error Id: fc6bfe17-d009-421c-8063-d759d7ea2f4e on 10.250.56.218:31010] (state=,code=0)
 
+
+### Example 5: Dropping a table that does not exist using the IF EXISTS parameter  
+The following example shows the result of dropping a table that does not exist (because it
was already dropped or never existed) using the IF EXISTS parameter with the DROP TABLE command:
 
+
+       0: jdbc:drill:zk=local> use dfs.tmp;
+       +-------+--------------------------------------+
+       |  ok   |               summary                |
+       +-------+--------------------------------------+
+       | true  | Default schema changed to 'dfs.tmp'  |
+       +-------+--------------------------------------+
+       1 row selected (0.289 seconds)  
+
+       0: jdbc:drill:zk=local> drop table if exists name_key;
+       +-------+-----------------------------+
+       |  ok   |         summary             |
+       +-------+-----------------------------+
+       | true  | Table 'name_key' not found  |
+       +-------+-----------------------------+
+       1 row selected (0.083 seconds)  
 
-###Example 5: Dropping a table without permissions 
+### Example 6: Dropping a table that exists using the IF EXISTS parameter  
+
+The following example shows the result of dropping a table that exists using the IF EXISTS
parameter with the DROP TABLE command.  
+
+       0: jdbc:drill:zk=local> use dfs.tmp;
+       +-------+--------------------------------------+
+       |  ok   |               summary                |
+       +-------+--------------------------------------+
+       | true  | Default schema changed to 'dfs.tmp'  |
+       +-------+--------------------------------------+
+       1 row selected (0.289 seconds)
+       
+       0: jdbc:drill:zk=local> drop table if exists name_key;
+       +-------+---------------------------+
+       |  ok   |        summary            |
+       +-------+---------------------------+
+       | true  | Table 'name_key' dropped  |
+       +-------+---------------------------+  
+       
+###Example 7: Dropping a table without permissions 
 The following example shows the result of dropping a table without the appropriate permissions
in the file system.
 
        0: jdbc:drill:zk=local> drop table name_key;
@@ -221,7 +268,7 @@ The following example shows the result of dropping a table without the
appropria
        Error: PERMISSION ERROR: Unauthorized to drop table
        [Error Id: 36f6b51a-786d-4950-a4a7-44250f153c55 on 10.10.30.167:31010] (state=,code=0)
 
 
-###Example 6: Dropping and querying a table concurrently  
+###Example 8: Dropping and querying a table concurrently  
 
 The result of this scenario depends on the delta in time between one user dropping a table
and another user issuing a query against the table. Results can also vary. In some instances
the drop may succeed and the query fails completely or the query completes partially and then
the table is dropped returning an exception in the middle of the query results.
 
@@ -245,7 +292,7 @@ The following example shows the result of dropping a table and issuing
a query a
        Fragment 1:0
        [Error Id: 6e3c6a8d-8cfd-4033-90c4-61230af80573 on 10.10.30.167:31010] (state=,code=0)
 
-###Example 7: Dropping a table with different file formats
+###Example 9: Dropping a table with different file formats
 The following example shows the result of dropping a table when multiple file formats exists
in the directory. In this scenario, the `sales_dir` table resides in the `dfs.sales` workspace
and contains Parquet, CSV, and JSON files.
 
 Running `ls` on `sales_dir` shows the different file types that exist in the directory.

http://git-wip-us.apache.org/repos/asf/drill/blob/40029390/_docs/sql-reference/sql-commands/056-drop-view.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/056-drop-view.md b/_docs/sql-reference/sql-commands/056-drop-view.md
index a0924aa..acf3139 100644
--- a/_docs/sql-reference/sql-commands/056-drop-view.md
+++ b/_docs/sql-reference/sql-commands/056-drop-view.md
@@ -1,16 +1,27 @@
 ---
 title: "DROP VIEW"
-date:  
+date: 2016-08-04 00:23:10 UTC
 parent: "SQL Commands"
 ---
 
-The DROP VIEW command removes a view that was created in a workspace using the CREATE VIEW
command.
+The DROP VIEW command removes a view that was created in a workspace using the CREATE VIEW
command. As of Drill 1.8, you can include the IF EXISTS parameter with the DROP VIEW command.
 
 ## Syntax
 
 The DROP VIEW command supports the following syntax:
 
-     DROP VIEW [workspace.]view_name;
+    DROP VIEW [IF EXISTS] [workspace.]view_name;  
+
+## Parameters  
+
+IF EXISTS  
+Drill does not throw an error if the view does not exist. Instead, Drill returns "`View [view_name]
not found in schema [workspace].`"  
+
+*workspace*  
+The location of the view in subdirectories of a local or distributed file system.
+
+*name*  
+A unique directory or file name, optionally prefaced by a storage plugin name, such as `dfs`,
and a workspace, such as `tmp` using dot notation. 
 
 ## Usage Notes
 
@@ -18,8 +29,10 @@ When you drop a view, all information about the view is deleted from the
workspa
 
 ## Example
 
-This example shows you some steps to follow when you want to drop a view in Drill using the
DROP VIEW command. A workspace named “donuts” was created for the steps in this example.
-Complete the following steps to drop a view in Drill:
+This example shows you some steps to follow when you want to drop a view in Drill using the
DROP VIEW command. A workspace named “donuts” was created for the steps in this example.
 
+
+Complete the following steps to drop a view in Drill:  
+
 Use the writable workspace from which the view was created.
 
     0: jdbc:drill:zk=local> use dfs.donuts;
@@ -44,5 +57,25 @@ Use the DROP VIEW command to remove a view created in another workspace.
     +------------+------------+
     |   ok  |  summary   |
     +------------+------------+
-    | true      | View 'yourdonuts' deleted successfully from 'dfs.tmp' schema |
-    +------------+------------+
+    | true      | View 'yourdonuts' deleted successfully from 'dfs.tmp' schema |  
+    +------------+------------+  
+
+Use the DROP VIEW command with or without the IF EXISTS parameter to remove a view created
in the current workspace.  
+
+    0: jdbc:drill:zk=local> drop view if exists mydonuts;
+    +------------+--------------------------------------------------------------+
+    |     ok     | summary                                                      |
+    +------------+--------------------------------------------------------------+
+    | true       | View 'mydonuts' deleted successfully from 'dfs.donuts' schema|
+    +------------+--------------------------------------------------------------+
+
+Use the DROP VIEW command with the IF EXISTS parameter to remove a view that does not exist
in the current workspace, either because it was never created or it was already removed.
+
+    0: jdbc:drill:zk=local> drop view if exists mydonuts;
+    +-------+---------------------------------------------------+
+    |  ok   |                   summary                         |
+    +-------+---------------------------------------------------+
+    | true  | View 'mydonuts' not found in schema 'dfs.donuts'  |
+    +-------+---------------------------------------------------+
+    1 row selected (0.085 seconds)
+


Mime
View raw message