You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by "Riesland, Zack" <Za...@sensus.com> on 2016/02/02 11:55:57 UTC

How to run multiple queries from one tool

I'm sure this is a total rookie question, but I'm months into using Hive and it hasn't become obvious to me yet:

When I use a tool like Aqua Data Studio and point it at a MSSQL Server database, I can run multiple queries, separated by a semicolon character ';'

So:

select blah from blah where criteria = 1;

select blah from blah where criteria = 2;

I can click 'execute' or 'ctrl + e' and both queries fire.

But in Hive, I can't do this. Even one query will fail if it has a semicolon character.

Is there a different delineator, or is this just a hard limitation of the drivers?

Thanks!