Thanks,
that is absolutely correct.
If explain is used only the first colum contains a value.
Thus the following statement prints out the execution plan:
try (FieldsQueryCursor> joinCursor = activityCache.query(sql)) {
for (List row : joinCursor){
The result set is different when you add explain - it only returns execution
plans:
https://apacheignite-sql.readme.io/docs/performance-and-debugging#using-explain-statement
However, you're trying to get values for multiple columns which are not
there, therefore it fails.
-Val
--
Sent from: ht
Hi,
I am trying to do an explain analysis on an SQL statement:
SqlFieldsQuery sql = new SqlFieldsQuery(
" explain SELECT act.id as id, act.actDef as actDef,
act.status,
act.prio as prio, o.orgId, p.userId "
+ " FROM Activity as act left join