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 585d9db add note about ability to query hive views in hive sp doc
585d9db is described below
commit 585d9dbfc92562351c35e86bf62ff7977aa978ec
Author: Bridget Bevens <[email protected]>
AuthorDate: Tue Apr 16 13:07:50 2019 -0700
add note about ability to query hive views in hive sp doc
---
.../connect-a-data-source/plugins/070-hive-storage-plugin.md | 12 ++++++++++--
1 file changed, 10 insertions(+), 2 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 cfea93a..267f293 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
@@ -1,12 +1,20 @@
---
title: "Hive Storage Plugin"
-date: 2018-12-08
+date: 2019-04-16
parent: "Connect a Data Source"
---
Prior to Drill 1.13, Drill supported Hive 1.0. Drill 1.13 and later includes
version 2.3.2 of the Hive client, which adds support for queries on
transactional (ACID) and non-transactional Hive bucketed ORC tables. The
updated Hive libraries are backward compatible with earlier versions of the
Hive server and metastore.
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.
+`<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
