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!