1 Reply Latest reply on Mar 5, 2019 2:36 PM by dbb-Oracle

    Query Malformed exception

    mohanr.k

      I am getting below query malformed exception for "SELECT ir.label FROM TEST_DATA  MATCH (i)-[r]->(ir)  GROUP BY i" query. I am running this pgql query on Cytoscape version 3.6.1.

       

      I am not sure what I am doing wrong here. Any help is appreciated.

       

      PGX Server: 3.1.0

      Oracle: 18c

       

      09:16:51.996 [http-nio-7007-exec-8] ERROR oracle.pgx.rest.mapper.AbstractExceptionMapper - exception mapper caught exception with code PGX-ERROR-23HE3AZPMBV5B

      java.util.concurrent.ExecutionException: oracle.pgx.api.MalformedQueryException: Error(s) in line 1:

       

       

      SELECT ir.label FROM TEST_DATA  MATCH (i)-[r]->(ir)  GROUP BY i

             ^^

      Unresolved variable (did you mean to use a group key?)

      at java.util.concurrent.CompletableFuture.reportGet(Unknown Source) ~[?:1.8.0_201]

      at java.util.concurrent.CompletableFuture.get(Unknown Source) ~[?:1.8.0_201]

      at oracle.pgx.api.PgxFuture.get(PgxFuture.java:99) ~[pgx-api-3.1.0.jar:3.1.0]

      at oracle.pgx.rest.PgxFutureWrapper.getAsJson(PgxFutureWrapper.java:66) ~[classes/:?]

      at oracle.pgx.rest.EndpointUtils.checkHttpMethod(EndpointUtils.java:218) ~[classes/:?]

      at oracle.pgx.rest.endpoints.FutureResource.getFuture(FutureResource.java:100) ~[classes/:?]

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_201]

      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_201]

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_201]

      at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_201]