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

Kylin pushdown to support postgresql

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: v2.5.2
    • Fix Version/s: v3.1.0
    • Component/s: Query Engine
    • Labels:
      None

      Description

      when I run pushdown to postgresql in my env, I encount the below exception.
      it seems that kylin need support more JDBC Driver, PushDownRunnerJdbcImpl.class should be more general.

      2019-02-26 16:12:53,168 ERROR [Query 207dcf77-7c14-8078-ea8b-79644a0c576d-48] service.QueryService:989 : pushdown engine failed current query too
      java.sql.SQLException: Unrecognized column type: int8
      at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.toSqlType(PushDownRunnerJdbcImpl.java:260)
      at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.extractColumnMeta(PushDownRunnerJdbcImpl.java:192)
      at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.executeQuery(PushDownRunnerJdbcImpl.java:68)
      at org.apache.kylin.query.util.PushDownUtil.tryPushDownQuery(PushDownUtil.java:122)
      at org.apache.kylin.query.util.PushDownUtil.tryPushDownSelectQuery(PushDownUtil.java:69)

        Attachments

          Activity

            People

            • Assignee:
              codingforfun weibin0516
              Reporter:
              aahi hailin.huang
            • Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: