You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/07/03 17:58:00 UTC
[jira] [Commented] (TRAFODION-3086) Traf support for DDL operations
directly on Hive objects
[ https://issues.apache.org/jira/browse/TRAFODION-3086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16531742#comment-16531742 ]
ASF GitHub Bot commented on TRAFODION-3086:
-------------------------------------------
GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/trafodion/pull/1628
TRAFODION-3086 DDL on Hive objs: use database and msck support
-- traf "set schema hive.<sch>" now behaves the same as Hive "use <db>".
1) <sch> is validated to exist at set schema time.
2) <sch> is set in Hive environment for that session. Any unqualified
object reference in ddl uses that default schema (database)
-- added support for msck (meta store check) command.
This command repairs database by refreshing untracked files/partitions
in hive metadata.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/trafodion ansharma_hiveddl_br
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1628.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 #1628
----
commit f5885e4fb34a90e99adcf7ec841e70f85e70191a
Author: Anoop Sharma <an...@...>
Date: 2018-07-03T17:54:33Z
TRAFODION-3086 DDL on Hive objs: use database and msck support
-- traf "set schema hive.<sch>" now behaves the same as Hive "use <db>".
1) <sch> is validated to exist at set schema time.
2) <sch> is set in Hive environment for that session. Any unqualified
object reference in ddl uses that default schema (database)
-- added support for msck (meta store check) command.
This command repairs database by refreshing untracked files/partitions
in hive metadata.
----
> Traf support for DDL operations directly on Hive objects
> ----------------------------------------------------------
>
> Key: TRAFODION-3086
> URL: https://issues.apache.org/jira/browse/TRAFODION-3086
> Project: Apache Trafodion
> Issue Type: New Feature
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
> Priority: Minor
> Attachments: HiveDDL.docx
>
>
> A previous Jira, TRAFODION-2498, added support to pass through some DDL commands to hive API. It was done via: process hive statement 'hive-ddl-command' syntax. The supplied command was passed in as-is to the underlying interface.
> This current Jira is to add support to directly perform DDL operations on Hive objects without having to use 'process hive statement'.
> Example: create table hive.hive.t (...) ...
> or: alter table hive.hivesch.t ....
> With this enhancement, Hive objects will be treated similar to traf objects while performing DDL operations. Things like registration/unregistration in traf MD, query invalidation, cleanup, etc will be done automatically.
> A detailed spec/note will be added later.
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)