Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-158

table aliases dont work for sampled tables in joins

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.3.0
    • Query Processor
    • None
    • Reviewed

    Description

      The following query:

      FROM table1 TABLESAMPLE (BUCKET 1 OUT OF 512 ON col1) a JOIN table2 b ON (a.j1 = b.j2) SELECT a.col1, a.j1, b.j2;

      results in the error:

      ERROR ql.Driver (SessionState.java:printError(263)) - FAILED: Error in semantic analysis: line 1:88 Invalid Table Alias a

      Attachments

        1. hive-158.2.patch
          23 kB
          Raghotham Murthy
        2. hive-158.3.patch
          1.02 MB
          Raghotham Murthy
        3. hive-158.patch
          1 kB
          Raghotham Murthy

        Activity

          People

            rsm Raghotham Murthy
            rsm Raghotham Murthy
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: