You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Yiming Liu <li...@gmail.com> on 2016/09/13 01:30:42 UTC
Re: How to use date dictionary
Hi Shaofeng,
KYLIN-2010 is created and assigned to myself. I will investigate first.
https://issues.apache.org/jira/browse/KYLIN-2010
2016-09-13 9:12 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:
> This should be a bug of the "Date" encoding, Billy could you please open a
> JIRA for tracking? As a workaround, please use "dict" encoding.
>
> 2016-09-12 20:48 GMT+08:00 Yiming Liu <li...@gmail.com>:
>
>> No matter why dictionary we choose, the result value should not be
>> changed. The expectation should be '20160401' still, not the epoch
>> timestamp. I think it would be a bug.
>>
>> 2016-09-11 22:54 GMT+08:00 Yiming Liu <li...@gmail.com>:
>>
>>> Is this related to https://issues.apache.org/jira/browse/KYLIN-1798?
>>>
>>>
>>> 2016-09-10 22:42 GMT+08:00 Yiming Liu <li...@gmail.com>:
>>>
>>>> Hi Kylin experts,
>>>>
>>>> I have a dimension, call DAY_ID, varchar type, data likes "20160401".
>>>> And I use Date type for encoding. When the cube is built successfully, I
>>>> just query the table group by DAY_ID, the result DAY_ID column is
>>>> '1459468800000', not '20160401'. Is that expectation result?
>>>>
>>>> --
>>>> With Warm regards
>>>>
>>>> Yiming Liu (刘一鸣)
>>>>
>>>
>>>
>>>
>>> --
>>> With Warm regards
>>>
>>> Yiming Liu (刘一鸣)
>>>
>>
>>
>>
>> --
>> With Warm regards
>>
>> Yiming Liu (刘一鸣)
>>
>
>
>
> --
> Best regards,
>
> Shaofeng Shi
>
>
--
With Warm regards
Yiming Liu (刘一鸣)
Re: How to use date dictionary
Posted by ShaoFeng Shi <sh...@apache.org>.
Thanks Billy!
2016-09-13 9:30 GMT+08:00 Yiming Liu <li...@gmail.com>:
> Hi Shaofeng,
>
> KYLIN-2010 is created and assigned to myself. I will investigate first.
> https://issues.apache.org/jira/browse/KYLIN-2010
>
> 2016-09-13 9:12 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:
>
>> This should be a bug of the "Date" encoding, Billy could you please open
>> a JIRA for tracking? As a workaround, please use "dict" encoding.
>>
>> 2016-09-12 20:48 GMT+08:00 Yiming Liu <li...@gmail.com>:
>>
>>> No matter why dictionary we choose, the result value should not be
>>> changed. The expectation should be '20160401' still, not the epoch
>>> timestamp. I think it would be a bug.
>>>
>>> 2016-09-11 22:54 GMT+08:00 Yiming Liu <li...@gmail.com>:
>>>
>>>> Is this related to https://issues.apache.org/jira/browse/KYLIN-1798?
>>>>
>>>>
>>>> 2016-09-10 22:42 GMT+08:00 Yiming Liu <li...@gmail.com>:
>>>>
>>>>> Hi Kylin experts,
>>>>>
>>>>> I have a dimension, call DAY_ID, varchar type, data likes "20160401".
>>>>> And I use Date type for encoding. When the cube is built successfully, I
>>>>> just query the table group by DAY_ID, the result DAY_ID column is
>>>>> '1459468800000', not '20160401'. Is that expectation result?
>>>>>
>>>>> --
>>>>> With Warm regards
>>>>>
>>>>> Yiming Liu (刘一鸣)
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> With Warm regards
>>>>
>>>> Yiming Liu (刘一鸣)
>>>>
>>>
>>>
>>>
>>> --
>>> With Warm regards
>>>
>>> Yiming Liu (刘一鸣)
>>>
>>
>>
>>
>> --
>> Best regards,
>>
>> Shaofeng Shi
>>
>>
>
>
> --
> With Warm regards
>
> Yiming Liu (刘一鸣)
>
--
Best regards,
Shaofeng Shi