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

Kylin build cube error with Oracle data source

Agile BoardAttach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • v2.6.6
    • None
    • Driver - JDBC
    • None
    • Hadoop 2.7.6
      hbase 1.4.5
      hive 2.3.2
      Kylin 2.6.6

    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.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            cs4680ok haiquanhe

            Dates

              Created:
              Updated:

              Slack

                Issue deployment