Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-3028

Control query shape (CQS) does not work for Hive insert and unload

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0-incubating
    • 2.3
    • sql-cmp
    • None

    Description

      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:

      control query shape fast_extract(...)
      

      Attachments

        Issue Links

          Activity

            People

              hzeller Hans Zeller
              hzeller Hans Zeller
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: