Hi,
I attended Turbocharge SQL on Ignite webinar earlier in the week and
wanted to get familiar with the examples. I downloaded the code from
https://github.com/vkulichenko/zeppelin-demo and tried to run Query.java
after loading the data. I am getting the below error running Query 2.
Also I did not understand the part where in Load.java why the cache name
was set to null while creating the cache to load Persons.
try (IgniteDataStreamer<AffinityKey<Long>, Person> personStreamer =
ignite.dataStreamer(null)) { - Line 67 in Load.java
14:51:49] Ignite node started OK (id=f2e7030f)
[14:51:49] Topology snapshot [ver=4, servers=1, clients=1, CPUs=4,
heap=3.5GB]
500
500000
Query 1:
Time: 293
Time: 71
Time: 65
Query 2:
[14:51:50] Ignite node stopped OK [uptime=00:00:00:848]
Exception in thread "main" javax.cache.CacheException: class
org.apache.ignite.IgniteException: Failed to bind parameters: [qry=SELECT
o.name as Organization, avg(p.salary) as Salary FROM Person p,
"Organizations".Organization o WHERE p.orgId = o.id AND p.managerId is null
GROUP BY o.name ORDER BY p.salary LIMIT 100, params=[10]]
at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:656)
at org.apache.ignite.zeppelin.Query.query(Query.java:58)
at org.apache.ignite.zeppelin.Query.main(Query.java:50)
Caused by: class org.apache.ignite.IgniteException: Failed to bind
parameters: [qry=SELECT o.name as Organization, avg(p.salary) as Salary
FROM Person p, "Organizations".Organization o WHERE p.orgId = o.id AND
p.managerId is null GROUP BY o.name ORDER BY p.salary LIMIT 100,
params=[10]]
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:806)
at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:647)
... 2 more
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to bind
parameters: [qry=SELECT o.name as Organization, avg(p.salary) as Salary
FROM Person p, "Organizations".Organization o WHERE p.orgId = o.id AND
p.managerId is null GROUP BY o.name ORDER BY p.salary LIMIT 100,
params=[10]]
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:1782)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:799)
... 3 more
Caused by: javax.cache.CacheException: Failed to bind parameters:
[qry=SELECT o.name as Organization, avg(p.salary) as Salary FROM Person p,
"Organizations".Organization o WHERE p.orgId = o.id AND p.managerId is null
GROUP BY o.name ORDER BY p.salary LIMIT 100, params=[10]]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:1050)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:801)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:799)
at
org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:1764)
... 4 more
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to bind
parameter [idx=1, obj=10, stmt=prep5: SELECT o.name as Organization,
avg(p.salary) as Salary FROM Person p, "Organizations".Organization o WHERE
p.orgId = o.id AND p.managerId is null GROUP BY o.name ORDER BY p.salary
LIMIT 100]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.bindObject(IgniteH2Indexing.java:489)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.bindParameters(IgniteH2Indexing.java:914)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:1047)
... 8 more
Caused by: org.h2.jdbc.JdbcSQLException: Invalid value "1" for parameter
"parameterIndex" [90008-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:172)
at org.h2.message.DbException.getInvalidValueException(DbException.java:218)
at
org.h2.jdbc.JdbcPreparedStatement.setParameter(JdbcPreparedStatement.java:1338)
at
org.h2.jdbc.JdbcPreparedStatement.setObject(JdbcPreparedStatement.java:451)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.bindObject(IgniteH2Indexing.java:486)
... 10 more
Thanks,
Murthy.
