You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Billy Liu (JIRA)" <ji...@apache.org> on 2018/01/24 16:19:00 UTC
[jira] [Resolved] (KYLIN-2495) query exception when integer column
encoded as date/time encoding
[ https://issues.apache.org/jira/browse/KYLIN-2495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Billy Liu resolved KYLIN-2495.
------------------------------
Resolution: Fixed
Fix Version/s: v2.0.0
Commit: https://git1-us-west.apache.org/repos/asf?p=kylin.git;a=commit;h=c5f3b228
> query exception when integer column encoded as date/time encoding
> ------------------------------------------------------------------
>
> Key: KYLIN-2495
> URL: https://issues.apache.org/jira/browse/KYLIN-2495
> Project: Kylin
> Issue Type: Bug
> Reporter: hongbin ma
> Assignee: hongbin ma
> Priority: Major
> Fix For: v2.0.0
>
>
> in KYLIN-2222, we claimed that integer column can use date/time encoding. however when I tried to query on such cube, an exception is thrown:
> {code}
> java.sql.SQLException: Error while executing SQL "select * from fact0309
> LIMIT 50000": For input string: "702259200000"
> {code}
> the fact table desc is:
> {code}
> hive> desc fact0309
> > ;
> OK
> tdate int
> country string
> price decimal(10,0)
> {code}
> and the sample data is:
> {code}
> 19980302 US 100
> 19920403 CN 100
> 19920403 US 33
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)