Forum: Building VoltDB Applications

Post: nested queries limitations

nested queries limitations
sanjoseuser
Feb 5, 2014
Are nested queries supported by VoltDB ? I couldn't find any link with the limitations of VoltDB. It would be great if someone can share the link for voltdb limitations.

select col1 from table1 where col2 in (select col3 from table2)

I get the following Error while executing the above query:
Unexpected Ad Hoc Planning Error: java.lang.RuntimeException: Error compiling query: org.voltdb.planner.PlanningErrorException: unexpected end of statement: required: (

There was no reference to Nested/SubQueries in https://voltdb.com/docs/UsingVoltDB/sqlref_select.php
rbetts
Feb 5, 2014
Are nested queries supported by VoltDB ? I couldn't find any link with the limitations of VoltDB. It would be great if someone can share the link for voltdb limitations.

select col1 from table1 where col2 in (select col3 from table2)

I get the following Error while executing the above query:
Unexpected Ad Hoc Planning Error: java.lang.RuntimeException: Error compiling query: org.voltdb.planner.PlanningErrorException: unexpected end of statement: required: (

There was no reference to Nested/SubQueries in https://voltdb.com/docs/UsingVoltDB/sqlref_select.php


Hi,

Presently, VoltDB does not support nested queries. The link you posted describes VoltDB SQL's support - it expresses the SELECT queries that are possible with VoltDB as of the current version.

Thanks,
Ryan.