GitHub user zellerh opened a pull request:
https://github.com/apache/trafodion/pull/1525
[TRAFODION-3028] Support CONTROL QUERY SHAPE (CQS) for Hive insert
Adding fast_extract() and hive_insert() CQS operator syntax to be able to
force shapes of Hive insert statements.
Example:
control query shape hive_insert(cut);
explain insert into hive.hive.t values(1,1);
Note: I don't think this fix works for UNLOAD, since that seems to be
an "ExeUtil" statement that gets executed in two phases.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/zellerh/trafodion bug/R23a
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1525.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 #1525
----
commit 81fadbc34683b33875892ded7a92d84793cc73c4
Author: Hans Zeller <hzeller@...>
Date: 2018-04-18T21:38:03Z
[TRAFODION-3028] Support CONTROL QUERY SHAPE (CQS) for Hive insert
Adding fast_extract() and hive_insert() CQS operator syntax to be able to
force shapes of Hive insert statements.
Example:
control query shape hive_insert(cut);
explain insert into hive.hive.t values(1,1);
Note: I don't think this fix works for UNLOAD, since that seems to be
an "ExeUtil" statement that gets executed in two phases.
----
---
