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)

Reply via email to