Uploaded image for project: 'Zeppelin'
  1. Zeppelin
  2. ZEPPELIN-1962

jdbc interpreter SqlCompleter takes extreamly long time - 4 hours

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 0.6.2
    • Fix Version/s: None
    • Component/s: Interpreters
    • Labels:
      None

      Description

      I tried to connect zeppelin jdbc interpreter to our oracle pre-production database.
      And the simple query "select sysdate from dual" took almost 4 hours.

      I guess the problem in SqlCompleter because i see in the logs:

      DEBUG [2017-01-12 20:18:27,097] ({pool-1-thread-4} Interpreter.java[getProperty]:179) - key: zeppelin.jdbc.concurrent.use, value: true
       INFO [2017-01-12 20:18:28,566] ({pool-2-thread-2} SqlCompleter.java[getSqlKeywordsCompletions]:142) - JDBC DriverName:/oracle-jdbc-driver-sql.keywords
      DEBUG [2017-01-13 00:11:03,393] ({pool-2-thread-2} SqlCompleter.java[getColumnNames]:221) - ..here columns and table names.......
      

      I think there should be possibility to disable this feature.

        Attachments

        1. zeppelin-jdbc-0.7.2.jar
          37 kB
          Dmitry Lukyanov
        2. 4hrs.png
          9 kB
          Dmitry Lukyanov

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              dlukyanov Dmitry Lukyanov
            • Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated: