Hive
  1. Hive
  2. HIVE-825

Better error messages regarding partitions and union all?

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      I'm having trouble debugging a pretty complicated query. I see this two messages currently, which I can fix after a bunch of debugging...but I would like to suggest some possible changes to the errors.

      FAILED: Error in semantic analysis: The query does not reference any valid partition. To run this query, set hive.mapred.mode=nonstrict

      ...it would be awesome if you could tell me what table (real name and/ or alias, and/or the line where it was first referenced) is lacking the partition query. I'm almost certain that this is because my ds='foo' requirement is in an ON clause and not a WHERE clause, but I don't want to set nonstrict in the general case because it scares me.

      Also:

      FAILED: Error in semantic analysis: Schema of both sides of union should match: source:_col0 source

      ...it would similarly be awesome if it could tell me what "source:_col0" means, how the sides of the union do not match, why they don't match, or what doesn't match.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Adam Kramer
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Development