kylin.rest.timezone=GMT+8
kylin.rest.servers=10.20.150.201:7070
kylin.job.jar=/u01/apache-kylin-2.6.6-bin-hbase1x/lib/kylin-job-2.6.6.jar
kylin.coprocessor.local.jar=/u01/apache-kylin-2.6.6-bin-hbase1x/lib/kylin-coprocessor-2.6.6.jar
kyin.server.mode=all 
kylin.rest.servers=10.20.150.201:7070 

#oracle jdbc
kylin.source.default=8
kylin.source.jdbc.connection-url=jdbc:oracle:thin:@10.20.150.xxxx:1521/xxxx
kylin.source.jdbc.driver=oracle.jdbc.driver.OracleDriver
kylin.source.jdbc.dialect=oracle
kylin.source.jdbc.user=xxxxx
kylin.source.jdbc.pass=xxxxxx
kylin.source.jdbc.sqoop-home=/opt/sqoop-1.4.7.bin__hadoop-2.6.0
kylin.source.jdbc.filed-delimiter=|
kylin.source.hive.quote-enabled=false


SELECT
T_IOT_CARD.ID as T_IOT_CARD_ID
 FROM UBI_OLAP.T_IOT_CARD as T_IOT_CARD
WHERE 1=1