haiquanhe created KYLIN-4538:
--------------------------------

             Summary: Kylin build cube error with Oracle data source 
                 Key: KYLIN-4538
                 URL: https://issues.apache.org/jira/browse/KYLIN-4538
             Project: Kylin
          Issue Type: Bug
          Components: Driver - JDBC
    Affects Versions: v2.6.6
         Environment: Hadoop 2.7.6
hbase 1.4.5
hive 2.3.2
Kylin 2.6.6
            Reporter: haiquanhe
         Attachments: error.log, kylin.properties

I setup a kylin test environment, and I try to using oracle as JDBC data source.
I can get the table structure in Kylin, but fail to build cube.
I find the SQL  in cubes :
SELECT
T_IOT_CARD.ID as T_IOT_CARD_ID
 FROM UBI_OLAP.T_IOT_CARD as T_IOT_CARD
WHERE 1=1
 
But this sql can't run sucessfull in ORACLE, Oracle can't support table alias 
with as.
Can you point out what should I do , which parameter I should set.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to