You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "Jean-Luc BELLIER (JIRA)" <ji...@apache.org> on 2018/02/16 13:17:14 UTC

[jira] [Created] (KYLIN-3256) Filter of dates do not work

Jean-Luc BELLIER created KYLIN-3256:
---------------------------------------

             Summary: Filter of dates do not work
                 Key: KYLIN-3256
                 URL: https://issues.apache.org/jira/browse/KYLIN-3256
             Project: Kylin
          Issue Type: Bug
    Affects Versions: v2.2.0
            Reporter: Jean-Luc BELLIER


Hello,

 

I am wondering how to filter date columns with Kylin.

I am working with the sample cube of the learn_kylin project. I have slightly modified the cube to add a few more columns, but that is all.

In the advanced section, I put KYLIN_SALES.PART_DT in the 'Rowkeys' section, defined as 'date' type.

 

I would like to add a filter like 'WHERE KYLIN_SALES.DT_PART = '2012-06-24'

but the Kylin interface gives me a mistake : 'error while compiling generated Java code'

This works fine with hive console.

I also tried with TO_DATE('2012-06-24').

Using "WHERE KYLIN_SALES.DT_PART BETWEEN '2012-06-24'  AND '2012-06-25'", it works fine.

 

Are  there limitations or internal transformations on the 'date' type in Kylin ?

 

Thank you for your help. Have a good day.

 

Best regards;

Jean-Luc.



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

Re: [jira] [Created] (KYLIN-3256) Filter of dates do not work

Posted by Qiwen Li <ra...@163.com>.
Hi Jean_Luc.:

You may need to rewrite your query like the below:
WHERE KYLIN_SALES.DT_PART = date ‘2012-06-24’

Actually, ‘date’ type in kylin should be used like the below:
select TRANS_ID,PART_DT,PRICE from KYLIN_SALES where PART_DT =date '2012-01-01’

OR

select TRANS_ID,PART_DT,PRICE from KYLIN_SALES where PART_DT =cast ('2012-01-01' as date)

> 在 2018年2月16日，下午9:17，Jean-Luc BELLIER (JIRA) <ji...@apache.org> 写道：
> 
> Jean-Luc BELLIER created KYLIN-3256:
> ---------------------------------------
> 
>             Summary: Filter of dates do not work
>                 Key: KYLIN-3256
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3256
>             Project: Kylin
>          Issue Type: Bug
>    Affects Versions: v2.2.0
>            Reporter: Jean-Luc BELLIER
> 
> 
> Hello,
> 
>  
> 
> I am wondering how to filter date columns with Kylin.
> 
> I am working with the sample cube of the learn_kylin project. I have slightly modified the cube to add a few more columns, but that is all.
> 
> In the advanced section, I put KYLIN_SALES.PART_DT in the 'Rowkeys' section, defined as 'date' type.
> 
>  
> 
> I would like to add a filter like 'WHERE KYLIN_SALES.DT_PART = '2012-06-24'
> 
> but the Kylin interface gives me a mistake : 'error while compiling generated Java code'
> 
> This works fine with hive console.
> 
> I also tried with TO_DATE('2012-06-24').
> 
> Using "WHERE KYLIN_SALES.DT_PART BETWEEN '2012-06-24'  AND '2012-06-25'", it works fine.
> 
>  
> 
> Are  there limitations or internal transformations on the 'date' type in Kylin ?
> 
>  
> 
> Thank you for your help. Have a good day.
> 
>  
> 
> Best regards;
> 
> Jean-Luc.
> 
> 
> 
> --
> This message was sent by Atlassian JIRA
> (v7.6.3#76005)