Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-3552

Data Source SDK to ingest data from different JDBC sources

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: v2.6.0
    • Component/s: Query Engine, RDBMS Source
    • Labels:
      None

      Description

      Kylin already supports JDBC source, but it takes much efforts to develop an implementation to a new source engine, like supporting metadata sync, cube build and query pushdown. It’s mainly because the SQL dialects and jdbc implementations between source engines are quite different.

      We propose to develop a data source sdk, which provides APIs to help developers handle these dialect differences and easily implement an adaptor for one source engine. With this SDK, users can achieve followings from a JDBC source:

      1. synchronize metadata and data from jdbc source.
      2. Build cube from jdbc source.
      3. query pushdown to jdbc source engine when cube is unmatched. 

      The SDK will define some interfaces of adaptors. To implement a new source, developers only need to implement an adaptor for the source.

      To keep compatibly, we will keep the existing JDBC source module, and implement a new JDBC source module as the caller of the SDK. Besides, we will also provide a pushdown implementation class as the caller of SDK for pushdown scenarios.

        Attachments

        1. test_evidence_datasource.docx
          494 kB
          youcheng.zhang

          Activity

            People

            • Assignee:
              youcheng.zhang youcheng.zhang
              Reporter:
              youcheng.zhang youcheng.zhang
            • Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: