question Re: Does zeppelin support multiple hive queries in one paragraph ? in Support Questions

Does zeppelin support multiple hive queries in one paragraph ?

nuspengcheng — Tue, 27 Dec 2016 19:20:07 GMT

Hi All,

I just wonder if zeppelin is able to run multiple hive queries in just one paragraph ?

If yes , how to do ?

if no, how to understand the below description in https://zeppelin.apache.org/docs/0.6.2/interpreter/hive.html

"You can also run multiple queries up to 10 by default. Changing these settings is not implemented yet."

Any response is welcome, thanks !

Re: Does zeppelin support multiple hive queries in one paragraph ?

jzhang — Tue, 27 Dec 2016 19:38:41 GMT

This means you can run at most 10 queries parallelly in each paragraph rather than in the same paragraph. This is because the interpreter process can at most allocate 10 threads for query execution.

Re: Does zeppelin support multiple hive queries in one paragraph ?

frank93 — Thu, 19 Jan 2017 16:39:20 GMT

@jzhang @Binu Mathew @Artem Ervits Sorry guys, but I've lost. Is it possible to run multiquery in the same paragraph? This post results it should work.

Re: Does zeppelin support multiple hive queries in one paragraph ?

lgeorge — Sat, 21 Jan 2017 02:13:07 GMT

@Edgar Daeds, from what I understand, not yet--you need to use multiple paragraphs. @jzhang, to confirm: did you mean (for now, in HDP 2.5.x) that they can run 10 queries in parallel, in 10 separate paragraphs?

Re: Does zeppelin support multiple hive queries in one paragraph ?

bikas — Mon, 23 Jan 2017 09:30:13 GMT

In HDP 2.5 Zeppelin JDBC interpreter can run 1 query in a paragraph. There is a limit of 10 queries that can be run simultaneously overall.

Re: Does zeppelin support multiple hive queries in one paragraph ?

v_glushak — Wed, 15 Nov 2017 21:23:54 GMT

Hi,

On the same topic. Zeppelin allow me to run multiple single line queries in one paragraphs.

The issue appears if I have multi-line query. It does not allow me to set semicolon at the end of such queries, instead it's expecting for EOF.

Any views on it

Re: Does zeppelin support multiple hive queries in one paragraph ?

mqadri — Mon, 20 Nov 2017 03:28:18 GMT

Check this post https://community.hortonworks.com/questions/34815/zeppelin-unable-to-run-multiple-hive-queries.html

Re: Does zeppelin support multiple hive queries in one paragraph ?

hskundhal — Thu, 28 Jun 2018 20:32:29 GMT

Please add below property to hive interpreter and it will run multiple queries.

default.splitQueries = true

hive.splitQueries = true

Regards,

Harpreet