[jira] [Created] (HIVE-13973) Using boolean in windowing query partitioning clause causes error

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

Jesus Camacho Rodriguez created HIVE-13973:
----------------------------------------------

             Summary: Using boolean in windowing query partitioning clause causes error
                 Key: HIVE-13973
                 URL: https://issues.apache.org/jira/browse/HIVE-13973
             Project: Hive
          Issue Type: Bug
    Affects Versions: 2.2.0
            Reporter: Jesus Camacho Rodriguez
            Assignee: Jesus Camacho Rodriguez


Following windowing query using boolean column in partitioning clause
{code:sql}
create table all100k(t tinyint, si smallint, i int,
    b bigint, f float, d double, s string,
    dc decimal(38,18), bo boolean, v varchar(25),
    c char(25), ts timestamp, dt date);
select  rank() over (partition by i order by bo  nulls first, b nulls last range between unbounded preceding and current row),
    row_number()  over (partition by bo order by si desc, b nulls last range between unbounded preceding and unbounded following) as fv
from all100k order by fv;
{code}
fails with the following error:
{noformat}
FAILED: SemanticException Failed to breakup Windowing invocations into Groups. At least 1 group must only depend on input columns. Also check for circular dependencies.
Underlying error: Primitve type BOOLEAN not supported in Value Boundary expression
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)