question Re: Run multiple queries on Hive / Phoenix? in Archives of Support Questions (Read Only)

Run multiple queries on Hive / Phoenix?

zack_riesland — Thu, 04 Feb 2016 22:10:46 GMT

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?

Re: Run multiple queries on Hive / Phoenix?

aervits — Thu, 04 Feb 2016 22:13:27 GMT

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

Re: Run multiple queries on Hive / Phoenix?

zack_riesland — Thu, 04 Feb 2016 22:16:11 GMT

Thanks @Artem Ervits. I followed the other question.

Re: Run multiple queries on Hive / Phoenix?

bleonhardi — Mon, 19 Aug 2019 10:08:19 GMT

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.

Re: Run multiple queries on Hive / Phoenix?

nsabharwal — Thu, 04 Feb 2016 23:06:26 GMT

@Zack Riesland See this