[KYLIN-4538] Kylin build cube error with Oracle data source

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: v2.6.6
• Component/s: Driver - JDBC
• Environment: Hadoop 2.7.6 ; hbase 1.4.5 ; hive 2.3.2 ; Kylin 2.6.6
• Assignee: Unassigned
• Reporter: haiquanhe
• Created: 28/May/20 02:23
• Updated: 28/May/20 02:23

Description

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.