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

The error message for "No partition predicate found" shows the incorrect table alias.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      Running the following queries.

      create table t1(key string, value string) partitioned by (ds string);
      create table t2(key string, value string) partitioned by (ds string);
      select * from (select * from t1 join t2 on t1.key=t2.key where t1.ds='1') t3;
      FAILED: SemanticException [Error 10041]: No partition predicate found for Alias "t3:t1" Table "t2"
      

      In fact, the alias on the message should be "t3:t2".

      Attachments

        Activity

          People

            Unassigned Unassigned
            aihuaxu Aihua Xu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: