[jira] [Commented] (KYLIN-3052) Support Redshift as data source

["Shaoxiong Zhan (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-3052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16275470#comment-16275470 ] 

Shaoxiong Zhan commented on KYLIN-3052:
---------------------------------------

Be similar to  KYLIN-3044:
To use Amazon Redshit as KYLIN data source, following properties should be added to kylin.properties:
kylin.source.jdbc.connection-url=jdbc:redshift://host:5439/sample
kylin.source.jdbc.driver=com.amazon.redshift.jdbc.Driver
kylin.source.jdbc.dialect=default
kylin.source.jdbc.user=user
kylin.source.jdbc.pass=pass
kylin.source.jdbc.sqoop-home=/usr/hdp/current/sqoop-client/bin
kylin.source.default=8
kylin.source.jdbc.filed-delimiter=|
JDBC driver will not be shipped by KYLIN. Users should add proper driver by themselves.
For release package, jdbc driver jar should be added to $KYLIN_HOME/ext
For IDE, add jdbc driver jar to class path manually.
Add sqoop needs the jdbc driver as well, users should also add jdbc driver to $SQOOP_HOME/lib

> Support Redshift as data source
> -------------------------------
>
>                 Key: KYLIN-3052
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3052
>             Project: Kylin
>          Issue Type: New Feature
>          Components: Job Engine, Metadata
>            Reporter: Shaoxiong Zhan
>            Assignee: Shaoxiong Zhan
>         Attachments: KYLIN-3052.patch
>
>
> KYLIN-1351 has added Vertica as data source, KYLIN-3044 is working on enable SQL Server as data source.Base on the work of KYLIN-1351 and KYLIN-3044, I'd like to enable Amazon RedShift as data source of Kylin.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)