The only items of note so far are:
[15:28:31,737][WARNING][Executor task launch worker-1][GridQueryProcessor]
Some classes in query configuration cannot be written in binary format
because they either implement Externalizable interface or have
writeObject/readObject methods. Instances of these classes will be
deserialized in order to build indexes. Please ensure that all nodes have
these classes in classpath. To enable binary serialization either implement
Binarylizable interface or set explicit serializer using
BinaryTypeConfiguration.setSerializer() method: [class
o.a.i.lang.IgniteUuid, class o.a.i.lang.IgniteUuid]
and
[15:30:13,968][WARNING][sys-#23%null%][IgniteH2Indexing] Query execution is
too long [time=8172 ms, sql='SELECTMYOBJECT._KEY __C0,MYOBJECT._VAL __C1FROM
"cache".MYOBJECT', plan=SELECT MYOBJECT._KEY AS __C0, MYOBJECT._VAL AS
__C1FROM "cache".MYOBJECT /* "cache".MYOBJECT.__SCAN_ */,
parameters=[]][15:30:15,468][INFO][grid-timeout-worker-#33%null%][IgniteKernal]
Metrics for local node (to disable set 'metricsLogFrequency' to 0) ^--
Node [id=39d71b7a, name=null] ^-- H/N/C [hosts=4, nodes=7, CPUs=32]
^-- CPU [cur=36.07%, avg=6.14%, GC=3.97%] ^-- Heap [used=442MB,
free=53.66%, comm=955MB] ^-- Public thread pool [active=0, idle=16,
qSize=0] ^-- System thread pool [active=0, idle=16, qSize=0] ^--
Outbound messages queue [size=0]
I changed the setup to be a standalone grid, with spark as a client and at
least got keys to cache. For example:
scala> cache.sql("select _key, _val from MyObject limit 5")res6:
org.apache.spark.sql.DataFrame = [_KEY: string, _VAL: struct<>]scala>
res6.collect.foreach(println)[A,[]][B,[]][C,[]][D,[]][E,[]]
but still no _val. will continue to debug further.
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/Guidance-on-Ignite-Spark-SQL-Functionality-tp3138p3155.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
