This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git
The following commit(s) were added to refs/heads/gh-pages by this push:
new fa878af edit
fa878af is described below
commit fa878af1a75b435b0e3b46e2293a0d308fe14e17
Author: Bridget Bevens <[email protected]>
AuthorDate: Tue Apr 16 13:42:21 2019 -0700
edit
---
.../plugins/070-hive-storage-plugin.md | 7 -------
_docs/query-data/050-querying-hive.md | 18 +++++++++++++++---
2 files changed, 15 insertions(+), 10 deletions(-)
diff --git a/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md
b/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md
index 267f293..a852b88 100644
--- a/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md
+++ b/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md
@@ -8,13 +8,6 @@ Prior to Drill 1.13, Drill supported Hive 1.0. Drill 1.13 and
later includes ver
To access Hive tables using custom SerDes or InputFormat/OutputFormat, all
nodes running Drillbits must have the SerDes or InputFormat/OutputFormat `JAR`
files in the
`<drill_installation_directory>/jars/3rdparty` folder.
-## Hive Views
-
-Starting in Drill 1.16, you can query Hive views from Drill like you would
query Hive tables in a hive schema, for example:
-
- SELECT * FROM hive.`hive_view`;
-
-For storage-based authorization, access to Hive views depends on the user’s
permissions on the underlying tables in the view definition. When a user
selects from a Hive view, the view is expanded (converted into a query), and
the underlying tables referenced in the query are validated for permissions.
## Setting Hive Properties
diff --git a/_docs/query-data/050-querying-hive.md
b/_docs/query-data/050-querying-hive.md
index ded28ce..24993f2 100644
--- a/_docs/query-data/050-querying-hive.md
+++ b/_docs/query-data/050-querying-hive.md
@@ -1,13 +1,25 @@
---
title: "Querying Hive"
-date: 2018-06-26 00:42:18 UTC
+date: 2019-04-16
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 %}
+
+{% 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 %}
+
+## Hive Views
+
+Starting in Drill 1.16, you can query Hive views from Drill like you would
query Hive tables in a hive schema, for example:
+
+ SELECT * FROM hive.`hive_view`;
+
+For storage-based authorization, access to Hive views depends on the user’s
permissions on the underlying tables in the view definition. When a user
selects from a Hive view, the view is expanded (converted into a query), and
the underlying tables referenced in the query are validated for permissions.
+
+
+##Creating and Querying a Hive Table
To create a Hive table and query it with Drill, complete the following steps:
