hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gopal V <gop...@apache.org>
Subject Re: Tez session after closing CLI
Date Tue, 09 Dec 2014 07:30:43 GMT
On 12/8/14, 10:09 PM, Fabio wrote:
> Hi everyone,
> when running Hive on Tez, a Tez session is alive within the Hive CLI
> until I leave the CLI. So if I run on the terminal something like "hive
> -f query.sql", once the query is completed the Tez session is closed. Is
> there a way to run a query in this way (let's say from the linux
> terminal using the -f parameter) but still keeping the Tez session open
> among subsequent commands of this kind?

Not in the way you described, but HiveServer2 can pool connections.

Then beeline (not fat client, but the thin SQL CLI) can connect to it 
and pick up an existing session for reuse.

There's an earlier thread which discusses how this is configured

http://mail-archives.apache.org/mod_mbox/hive-user/201412.mbox/%3CCAG6Lhyf3TazE7GrEM1PsuquK6g+mPMDYNo8j6oKpCLEQNVY5wA@mail.gmail.com%3E

To use this effectively, you need HiveServer2 to use the GRANT/ALLOW 
security model (similar to how mysql runs all queries as mysql user, 
while allowing granular table level security).

Cheers,
Gopal

Mime
View raw message