[
https://issues.apache.org/jira/browse/KYLIN-2495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15904662#comment-15904662
]
hongbin ma edited comment on KYLIN-2495 at 3/10/17 9:14 AM:
------------------------------------------------------------
updated KYLIN-2222 so that string type no longer support date/time encoding,
test data:
{code}
create table fact0310(intdate int, realdate date, realtime timestamp, longtime
bigint);
19980302 1998-03-02 2015-06-01 00:00:00 1433116800000
19920403 1992-04-03 2015-05-15 17:00:00 1431709200000
19920403 1992-04-03 2016-01-15 12:00:00 1452859200000
{code}
make sure both intdate and realdate can use date encoding, and realtime and
longtime can use time encoding by following query:
{code:sql}
select intdate,realdate,realtime,longtime,count(*) from fact0310
group by intdate,realdate,realtime,longtime
{code}
was (Author: mahongbin):
updated KYLIN-2222 so that string type no longer support date/time encoding,
test data:
{code}
create table fact0310(intdate int, realdate date, realtime timestamp, longtime
bigint);
19980302 1998-03-02 2015-06-01 00:00:00 1433116800000
19920403 1992-04-03 2015-05-15 17:00:00 1431709200000
19920403 1992-04-03 2016-01-15 12:00:00 1452859200000
{code}
make sure both intdate and realdate can use date encoding, and realtime and
longtime can use time encoding
> 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
>
> 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
(v6.3.15#6346)
