[
https://issues.apache.org/jira/browse/TRAFODION-2498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15883657#comment-15883657
]
ASF GitHub Bot commented on TRAFODION-2498:
-------------------------------------------
GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/incubator-trafodion/pull/979
TRAFODION-2498 Add support to run hive stmts from traf interface
Syntax:
process hive statement '<string>';
<string>: hive statement starting with create/drop/alter/truncate.
These are the only stmts currently supported.
Ex:
>>process hive statement 'create database trafsch';
will create hive database 'trafsch'
>>process hive statement 'create table trafsch.t (a int)';
will create hive table 't' in hive schema 'trafsch'.
'process hive statment ..' could be issued from any traf interface
(sqlci/trafci/jdbc...)
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/incubator-trafodion
ansharma_hivesql_br
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/979.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 #979
----
commit e9389fa010c031669e97385f264d758043b9e4ac
Author: Anoop Sharma <[email protected]>
Date: 2017-02-24T22:34:09Z
TRAFODION-2498 Add support to run hive stmts from traf interface
Syntax:
process hive statement '<string>';
<string>: hive statement starting with create/drop/alter/truncate.
These are the only stmts currently supported.
Ex:
>>process hive statement 'create database trafsch';
will create hive database 'trafsch'
>>process hive statement 'create table trafsch.t (a int)';
will create hive table 't' in hive schema 'trafsch'.
'process hive statment ..' could be issued from any traf interface
(sqlci/trafci/jdbc...)
----
> Add support to run hive DDL commands from trafodion interface
> -------------------------------------------------------------
>
> Key: TRAFODION-2498
> URL: https://issues.apache.org/jira/browse/TRAFODION-2498
> Project: Apache Trafodion
> Issue Type: New Feature
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
> Priority: Minor
>
> Currently, native hive DDL (create/drop/alter of tables/views) need to be
> done from a hive shell/commandline interface.
> After creating them, they can then be accessed from trafodion
> using a 3-part name where the first(catalog) part is "hive".
> This jira is to enhance trafodion so hive ddl statements can be issued
> from any trafodion interface (sqlci, trafci, odbc/jdbc..).
> It provides one interface to do hive ddl and trafodion operations.
> This is also useful in developing test suites that can issue hive
> ddl commands from traf interface without having to switch to a different hive
> interface.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
