the timestamp in kafka table can be recognized and automatically be changed 
into date format,but the timestamp in hive can't be used?
在 2017-09-30 16:24:43,"Alberto Ramón" <a.ramonporto...@gmail.com> 写道:
>I think yes. You have 3 format to choose o column sompose
>
>On 30 September 2017 at 09:21, 崔苗 <cuim...@danale.com> wrote:
>
>> the time column in our table is timestamp such as 1501210920742,saved as
>> bigint in hive,not the date format as yyyy-MM-dd HH:mm:ss,so we must change
>> the timestamp to date format?
>> 在 2017-09-30 16:05:23,"Alberto Ramón" <a.ramonporto...@gmail.com> 写道:
>> >As resume:
>> >
>> >yyyy-MM-dd / *yyyyMMdd* / yyyy-MM-dd HH:mm:ss
>> >
>> >Check this JIRAS:
>> >https://issues.apache.org/jira/browse/KYLIN-1101
>> >https://issues.apache.org/jira/browse/KYLIN-1441
>> >https://issues.apache.org/jira/browse/KYLIN-1427
>> >
>> >On 30 September 2017 at 04:45, 崔苗 <cuim...@danale.com> wrote:
>> >
>> >> we have a  timestamp column used as the partition column,what should be
>> >> used to encoed the column,date or time? what's the difference between
>> the
>> >> two code? BTW, can kylin recognize all the level of timestamp ,no matter
>> >> it's s or ms timestamp?
>> >>
>> >>
>> >> thanks in advanced for your reply.
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>>
>>
>>


Reply via email to