kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chetan Dixit <Chetan_Dix...@symantec.com>
Subject Timestamp related issues
Date Tue, 27 Oct 2015 04:45:48 GMT
Hello Kylin Team,

We are facing following issues while using Kylin could you please help.


1.      Is there any issue with Timestamp/Date values ?
               We see issues in queries using "WHERE columnname = timestamp '2015-07-23 10:30:00'
" it does not return any results.
               If we use "WHERE columnname = '2015-07-23 10:30:00' " it returns ERROR
               If use timestamp column in projection list, it truncates the timestamp part
i.e. 2015-07-23 10:30:00 to 2015-07-23 00:00:00


2.      For measures with distinct count, it uses approximations with certain error rates,
lowest of which is <1.22%. Does this guarantee that counts would be accurate ?
               We have seen for a count of 1000 results as 982, 1000 etc.

Thanks,
Chetan


Mime
View raw message