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

Scheduled execution of JDBC alias interpreters (like %hive) fails

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 0.6.0
    • Fix Version/s: 0.6.2
    • Component/s: zeppelin-zengine
    • Labels:
      None
    • Environment:

      HDP 2.5.3, Zeppelin 0.6.0

      Description

      We have configured following paragraph to run periodically (scheduled cron job functionality)

      %hive
      select current_timestamp
      

      This fails with following exception in the logs:

      ERROR [2017-01-20 23:59:00,003] ({DefaultQuartzScheduler_Worker-9} QuartzScheduler.java[schedulerError]:2425) - Job (note.2C8WZQ8HT threw an exception.
      org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: java.lang.NullPointerException]
              at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
              at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      Caused by: java.lang.NullPointerException
              at org.apache.zeppelin.notebook.Note.runAll(Note.java:404)
              at org.apache.zeppelin.notebook.Notebook$CronJob.execute(Notebook.java:642)
              at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
              ... 1 more
      

      I suspect that alias intepreters are not handled correctly when running from scheduler. Workaround would be using same datasource configured as default for JDBC intepreter, then everything works as expected

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                vadim.lositski Vadim Lositski
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: