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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 0.6.0
    • 0.6.2
    • zeppelin-zengine
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: