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

Query fails when disabling PPD optimization

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.1.0
    • None
    • Logical Optimizer
    • None

    Description

      Query fails when disabling PPD optimization (necessary until https://issues.apache.org/jira/browse/HIVE-19652 is solved):

       

      :0 jdbc:hive2://> CREATE TABLE t (x INT) PARTITIONED BY (y INT);
      0: jdbc:hive2://> SELECT * FROM t WHERE y IS NOT NULL;
      ---------++-

      t.x t.y

      ---------++-
      ---------++-
      0: jdbc:hive2://> SET hive.optimize.ppd=false;
      0: jdbc:hive2://> SELECT * FROM t WHERE y IS NOT NULL;
      Error: Error while compiling statement: FAILED: SemanticException [Error 10041]: No partition predicate found for Alias "t" Table "t" (state=42000,code=10041)

       

      Current version: 1.1.0-cdh5.11.1

      Attachments

        Activity

          People

            Unassigned Unassigned
            rafaelmourao Rafael Mourao
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: