[jira] [Created] (KYLIN-2495) query exception when integer column encoded as date/time encoding

["hongbin ma (JIRA)" <ji...@apache.org>]

hongbin ma created KYLIN-2495:
---------------------------------

             Summary: 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)