Support Questions

Find answers, ask questions, and share your expertise

Run multiple queries on Hive / Phoenix?

avatar
Super Collaborator

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?

1 ACCEPTED SOLUTION

avatar
Master Mentor

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

View solution in original post

4 REPLIES 4

avatar
Master Mentor

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

avatar
Super Collaborator

Thanks @Artem Ervits. I followed the other question.

avatar
Master Guru

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.

1795-screen-shot-2016-02-04-at-21945-pm.png

avatar
Master Mentor

@Zack Riesland See this