I am new to optiq. And would like to know if there is any support for hiearchical query in optiq ?
I tried a simple query like :
SELECT EMP_ID, EMP_NAME,MGR_ID FROM OPTIQ_EMPLOYEE CONNECT BY EMP_ID = MGR_ID,
But there was an SQLException for CONNECT.
java.sql.SQLException: while executing SQL: SELECT EMP_ID, EMP_NAME,MGR_ID FROM OPTIQ_EMPLOYEE CONNECT BY EMP_ID = MGR_ID
Caused by: org.eigenbase.sql.parser.SqlParseException: Encountered "CONNECT" at line 1, column 52.
Was expecting one of:
Is there any other way to handle such hierarchical queries in optiq ?