./run.sh test_queries/11.sql 1/4 -- using 1528199543 as a seed to the RNG 2/4 3/4 4/4 select ps_partkey, sum(ps_supplycost * ps_availqty) as value from partsupp, supplier, nation where ps_suppkey = s_suppkey and s_nationkey = n_nationkey and n_name = 'GERMANY' group by ps_partkey having sum(ps_supplycost * ps_availqty) > ( select sum(ps_supplycost * ps_availqty) * 0.0001 from partsupp, supplier, nation where ps_suppkey = s_suppkey and s_nationkey = n_nationkey and n_name = 'GERMANY' ) order by value desc; Error: class org.apache.ignite.IgniteException: Failed to generate REDUCE query. Data table found: PUBLIC.PARTSUPP SELECT __C0_0 PS_PARTKEY, SUM(__C0_1) AS VALUE FROM PUBLIC.__T0 GROUP BY __C0_0 HAVING SUM(__C0_2) > (SELECT (SUM(__C0_3) * 0.0001) FROM PUBLIC.PARTSUPP __Z3 INNER JOIN PUBLIC.SUPPLIER __Z4 ON TRUE INNER JOIN PUBLIC.NATION __Z5 ON TRUE WHERE (__Z5.N_NAME = 'GERMANY') AND ((__Z3.PS_SUPPKEY = __Z4.S_SUPPKEY) AND (__Z4.S_NATIONKEY = __Z5.N_NATIONKEY))) ORDER BY 2 DESC (state=50000,code=0) java.sql.SQLException: class org.apache.ignite.IgniteException: Failed to generate REDUCE query. Data table found: PUBLIC.PARTSUPP SELECT __C0_0 PS_PARTKEY, SUM(__C0_1) AS VALUE FROM PUBLIC.__T0 GROUP BY __C0_0 HAVING SUM(__C0_2) > (SELECT (SUM(__C0_3) * 0.0001) FROM PUBLIC.PARTSUPP __Z3 INNER JOIN PUBLIC.SUPPLIER __Z4 ON TRUE INNER JOIN PUBLIC.NATION __Z5 ON TRUE WHERE (__Z5.N_NAME = 'GERMANY') AND ((__Z3.PS_SUPPKEY = __Z4.S_SUPPKEY) AND (__Z4.S_NATIONKEY = __Z5.N_NATIONKEY))) ORDER BY 2 DESC at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:751) at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:210) at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:473) at sqlline.Commands.execute(Commands.java:823) at sqlline.Commands.sql(Commands.java:733) at sqlline.SqlLine.dispatch(SqlLine.java:795) at sqlline.SqlLine.runCommands(SqlLine.java:1706) at sqlline.Commands.run(Commands.java:1317) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) at sqlline.SqlLine.dispatch(SqlLine.java:791) at sqlline.SqlLine.initArgs(SqlLine.java:595) at sqlline.SqlLine.begin(SqlLine.java:643) at sqlline.SqlLine.start(SqlLine.java:373) at sqlline.SqlLine.main(SqlLine.java:265) Aborting command set because "force" is false and command failed: "select ps_partkey, sum(ps_supplycost * ps_availqty) as value from partsupp, supplier, nation where ps_suppkey = s_suppkey and s_nationkey = n_nationkey and n_name = 'GERMANY' group by ps_partkey having sum(ps_supplycost * ps_availqty) > ( select sum(ps_supplycost * ps_availqty) * 0.0001 from partsupp, supplier, nation where ps_suppkey = s_suppkey and s_nationkey = n_nationkey and n_name = 'GERMANY' ) order by value desc;" Closing: org.apache.ignite.internal.jdbc.thin.JdbcThinConnection