Created 02-04-2016 02:10 PM
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?
Created 02-04-2016 02:13 PM
@Zack Riesland you're not the only one reporting this link
Created 02-04-2016 02:13 PM
@Zack Riesland you're not the only one reporting this link
Created 02-04-2016 02:16 PM
Thanks @Artem Ervits. I followed the other question.
Created on 02-04-2016 02:34 PM - edited 08-19-2019 03:08 AM
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.
Created 02-04-2016 03:06 PM
@Zack Riesland See this