Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-2225

Poor error message when group by missing on select t.*

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.2.4
    • Fix Version/s: Impala 2.5.0, Impala 2.3.2
    • Component/s: None
    • Labels:
      None

      Description

      The error message below (NullPointerException: null) leaves much to be desired. I've reproduced this on the Impala currently built from a153aabec4f0fd1911af219f8c221f01b609c82d and the Impala in CDH 5.4.x.

      [nightly-2:21000] > select version(); create table t1 (a string); create table t2 (b string); select t1.*, max(b) from t1 join t2 on a=b;
      Query: select version()
      +----------------------------------------------------------------------------------------------+
      | version()                                                                                    |
      +----------------------------------------------------------------------------------------------+
      | impalad version 2.3.0-cdh5-INTERNAL RELEASE (build a153aabec4f0fd1911af219f8c221f01b609c82d) |
      | Built on Mon, 17 Aug 2015 21:18:38 PST                                                       |
      +----------------------------------------------------------------------------------------------+
      Fetched 1 row(s) in 0.18s
      Query: create table t1 (a string)
      
      Query: create table t2 (b string)
      
      Query: select t1.*, max(b) from t1 join t2 on a=b
      ERROR: AnalysisException: null
      CAUSED BY: NullPointerException: null
      

        Attachments

          Activity

            People

            • Assignee:
              cchanning Chris Channing
              Reporter:
              philip Philip Zeyliger
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: