question zeppelin - how to remove results cache from notebook in Archives of Support Questions (Read Only)

zeppelin - how to remove results cache from notebook

rainer_geissend — Wed, 23 Mar 2016 23:58:20 GMT

Dear Experts,

I created a quite complex zeppelin notebook and accidentally returned a rather big result set for one of the queries (that I had to abort).

Now when I reopen the notebook in the browser, zeppelin takes ages and breaks after a while (I assume my browsers buffers are running over ...)

Any Idea on how I can clear/reset the zeppelin result sets without accessing/entering the notebook?

Any other idea on how I can bring back my notebook?

Thanks and br,

Rainer

Re: zeppelin - how to remove results cache from notebook

phargis — Thu, 24 Mar 2016 00:54:34 GMT

Zeppelin stores all displayable information in a JSON format file named "note.json" (default), located under the home directory, usually /user/zeppelin/notebook. This JSON file includes source code, markup, and output results. Easiest thing to do is:

ssh into the machine where zeppelin service is running
cd to the notebook directory (cd /user/zeppelin/notebook)
cd to the specific notebook sub-directory; each notebook is in separate sub-dir (cd 2A94M5J1Z)
edit the note.json file and remove the unwanted results

If you use a good editor (like TextMate or vim) that has JSON plugin to format the contents, you can easily locate the results section and rip it out. Make sure you don't break the integrity of the JSON file itself; you just want to eliminate the inner JSON contents where the superfluous result is stored. Here is an example of a results field from note.json:

      "result": {
        "code": "SUCCESS",
        "type": "HTML",
        "msg": "\u003ch2\u003eWelcome to Zeppelin.\u003c/h2\u003e\n\u003ch5\u003eThis is a live tutorial, you can run the code yourself. (Shift-Enter to Run)\u003c/h5\u003e\n"
      },

Re: zeppelin - how to remove results cache from notebook

rainer_geissend — Thu, 24 Mar 2016 03:02:46 GMT

Worked like a charm 🙂 Thanks for your support!

Re: zeppelin - how to remove results cache from notebook

aervits — Thu, 24 Mar 2016 03:42:37 GMT

Rainer, next time instead of closing the question, hit accept. That's a best practice when you receive a satisfactory answer. I accepted the answer on your behalf but we would rather you accept answers going forward. Thanks

Re: zeppelin - how to remove results cache from notebook

rainer_geissend — Fri, 25 Mar 2016 01:44:35 GMT

Will do, thanks ... me constantly improving 🙂

Re: zeppelin - how to remove results cache from notebook

hevertoncss — Sat, 06 May 2017 02:10:46 GMT

Thanks, resolve my problem.

Re: zeppelin - how to remove results cache from notebook

goguladileepkum — Mon, 04 Dec 2017 21:49:19 GMT

Resolved my issue after modifying the JSON file and restarting zeppelin. Thanks for the help