You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Amruth S (JIRA)" <ji...@apache.org> on 2018/01/25 07:06:00 UTC

[jira] [Created] (HIVE-18537) Queries with a nested distinct clause and a windowing function seem to fail with calcite Assertion error

Amruth S created HIVE-18537:
-------------------------------

             Summary: Queries with a nested distinct clause and a windowing function seem to fail with calcite Assertion error
                 Key: HIVE-18537
                 URL: https://issues.apache.org/jira/browse/HIVE-18537
             Project: Hive
          Issue Type: Bug
          Components: Hive
    Affects Versions: 2.3.2
            Reporter: Amruth S


Sample test case to re-produce the issue

 
{code:java}
create table test_cbo (
 `a` BIGINT,
 `b` STRING,
 `c` TIMESTAMP,
 `d` STRING
 );
SELECT 1
 FROM
 (SELECT
 DISTINCT
 a AS a_,
 b AS b_,
 rank() over (partition BY a ORDER BY c DESC) AS c_,
 d AS d_
 FROM test_cbo
 WHERE b = 'some_filter' ) n
 WHERE c_ = 1;
{code}
 

This might be related to https://issues.apache.org/jira/browse/CALCITE-1868
  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)