You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Hans Zeller (JIRA)" <ji...@apache.org> on 2018/04/18 21:26:00 UTC

[jira] [Created] (TRAFODION-3028) Control query shape (CQS) does not work for Hive insert and unload

Hans Zeller created TRAFODION-3028:
--------------------------------------

             Summary: Control query shape (CQS) does not work for Hive insert and unload
                 Key: TRAFODION-3028
                 URL: https://issues.apache.org/jira/browse/TRAFODION-3028
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
    Affects Versions: 2.0-incubating
            Reporter: Hans Zeller
            Assignee: Hans Zeller
             Fix For: 2.3


We don't have the right syntax in the CONTROL QUERY SHAPE (CQS) command to force the shape of an insert into a Hive table or an unload statement.

The shape in a CQS has to start with the top node. For Hive insert or unload, that is a HiveInsert or FastExtract node, which does not yet have a corresponding syntax element in CQS.

Note that the SHOWSHAPE command already shows what the syntax should (or could) be, this is what showshape displays:

{noformat}
control query shape fast_extract(...)
{noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)