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

Accessing Hive table via JDBC Interpreter - Slow

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

    Details

    • Flags:
      Important

      Description

      Simple Hive query : Select * from <default.sampleTable> limit 25 yielded response for 

      Hive Client : <1 sec

      Zeppelin %JDBC(Hive) : 30 sec.

      While analyzing the logs, I understand it was taking time to fetch metadata of schema and did the same even when configuration specified default schema. Ideally the performance should be close to hive client with little latency but not major. Please advise if current data fetch approach is optimized for hive jdbc queries.

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mothi86 Mothilal

              Dates

              • Created:
                Updated:

                Issue deployment