Run multiple queries on Hive / Phoenix?

[#1]

I’m sure this is a total rookie question, but I’m months into using Hive and Phoenix 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 (and also Phoenix), I can’t do this. Even one query will fail if it has a semicolon character.

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

[#2 · Accepted solution]

@Zack Riesland you're not the only one reporting this link

[#3]

Thanks @Artem Ervits. I followed the other question.

[#4]

That is weird. I am using Eclipse Datatools with 2.3.0 and 2.3.2 and in both cases I can run multiple commands delimited by ";" Like in any other database.

However I am using a "generic JDBC connection in Eclipse. Not sure what Aqua Studio does there.

( The screenshot below uses only DDL language but I have examples with SELECTS as well.

[#5]

@Zack Riesland See this