Hive
  1. Hive
  2. HIVE-763

getSchema returns invalid column names, getThriftSchema does not return old style string schemas

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 0.4.0
    • Fix Version/s: 0.6.0
    • Component/s: Query Processor
    • Labels:
      None
    • Environment:

      Cent OS 5.3

    • Hadoop Flags:
      Incompatible change, Reviewed

      Description

      SELECT AVG(total) as avg,STDDEV(total) as stddevr FROM (SELECT COUNT(phrase) as total FROM TABLE GROUP BY phrase) t2

      getSchema and getThriftSchema both return

      col0: double
      col1 : double

      expected results

      avg : double
      stddevr : double

      col0 & col1 are useless column names.

        Activity

        Scott created issue -
        John Sichi made changes -
        Field Original Value New Value
        Assignee John Sichi [ jvs ]
        John Sichi made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        Hide
        John Sichi added a comment -

        This patch should fix the bug.

        Show
        John Sichi added a comment - This patch should fix the bug.
        John Sichi made changes -
        Attachment HIVE-763.1.patch [ 12431394 ]
        Hide
        Namit Jain added a comment -

        +1

        looks good - will commit if the tests pass

        Show
        Namit Jain added a comment - +1 looks good - will commit if the tests pass
        Hide
        Namit Jain added a comment -

        committed. Thanks John

        Show
        Namit Jain added a comment - committed. Thanks John
        Namit Jain made changes -
        Status In Progress [ 3 ] Resolved [ 5 ]
        Hadoop Flags [Incompatible change] [Incompatible change, Reviewed]
        Fix Version/s 0.6.0 [ 12314524 ]
        Resolution Fixed [ 1 ]
        Carl Steinbach made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            John Sichi
            Reporter:
            Scott
          • Votes:
            3 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development