[
https://issues.apache.org/jira/browse/TRAFODION-2492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15878887#comment-15878887
]
ASF GitHub Bot commented on TRAFODION-2492:
-------------------------------------------
GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/incubator-trafodion/pull/976
TRAFODION-2492 Support for native hive views, plus few more changes
-- added support for native hive views created externally. These views
can be accessed in a traf sql query.
There are some restrictions as listed below:
-- privileges support has not yet been added. That will be done, as
needed, in the next checkin.
-- usage info for tables contained in a native hive view is not
maintained.
-- native hive views cannot be inserted/updated/deleted
-- cannot update stats on a native hive view
-- support for GET statements to retrieve hive data
get tables/views/objects in schema hive.sch;
-- this will return all tables/views in specified schema(hive database)
get tables/views/objects in catalog hive;
-- this will return all tables/views in hive
get schemas in catalog hive;
-- this will return all schemas(databases) that exist in hive
-- GET statements to retrieve hive data now supports optional MATCH clause.
This can be used to filter results.
-- showddl will show if an external table on hive was created implicitly
for internal usage (upd stats, privileges, views) or explicitly by user.
Internal creation of external table now use 'create implicit external
table'
syntax and that info is stored in metadata.
-- drop external table will drop that table even if underlying hive table
is missing. Currently it returns an error.
-- at runtime, accessing a missing hive table now returns a better error
message instead of an internal "data mod check failed" message.
-- regress/tools/runallsb has 2 new options:
-basetests (this will run core,compGeneral,executor,seabase,hive)
-othertests (this will run all other tests suites)
-- optimizer/NATable.cpp was incorrectly indented by some checkin from
a few days back. TABs were used instead of spaces which caused code
to become all crooked. That has been fixed.
-- regress/hive/TEST007 has been updated with additional hive view tests
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/incubator-trafodion
ansharma_hiveviews_br
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/976.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #976
----
commit 4c3077ce8277ac4ced7d114464348b992e94b4b0
Author: Anoop Sharma <[email protected]>
Date: 2017-02-22T18:02:05Z
TRAFODION-2492 Support for native hive views, plus few more changes
-- added support for native hive views created externally. These views
can be accessed in a traf sql query.
There are some restrictions as listed below:
-- privileges support has not yet been added. That will be done, as
needed, in the next checkin.
-- usage info for tables contained in a native hive view is not
maintained.
-- native hive views cannot be inserted/updated/deleted
-- cannot update stats on a native hive view
-- support for GET statements to retrieve hive data
get tables/views/objects in schema hive.sch;
-- this will return all tables/views in specified schema(hive database)
get tables/views/objects in catalog hive;
-- this will return all tables/views in hive
get schemas in catalog hive;
-- this will return all schemas(databases) that exist in hive
-- GET statements to retrieve hive data now supports optional MATCH clause.
This can be used to filter results.
-- showddl will show if an external table on hive was created implicitly
for internal usage (upd stats, privileges, views) or explicitly by user.
Internal creation of external table now use 'create implicit external
table'
syntax and that info is stored in metadata.
-- drop external table will drop that table even if underlying hive table
is missing. Currently it returns an error.
-- at runtime, accessing a missing hive table now returns a better error
message instead of an internal "data mod check failed" message.
-- regress/tools/runallsb has 2 new options:
-basetests (this will run core,compGeneral,executor,seabase,hive)
-othertests (this will run all other tests suites)
-- optimizer/NATable.cpp was incorrectly indented by some checkin from
a few days back. TABs were used instead of spaces which caused code
to become all crooked. That has been fixed.
-- regress/hive/TEST007 has been updated with additional hive view tests
----
> Add support to access native hive views from trafodion
> ------------------------------------------------------
>
> Key: TRAFODION-2492
> URL: https://issues.apache.org/jira/browse/TRAFODION-2492
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
> Priority: Minor
>
> If a native hive view created on hive tables is accessed
> from trafodion, that operation fails and an error is returned.
> This jira is to enhance trafodion to access native hive views
> in traf sql queries.
> A different jira (trafodion-2439) handled the enhancement of creating
> trafodion views on hive tables through trafodion interface.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
