[
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)
