Select that worked in previous Apache Ignite versions doesn't work in 2.8.0

I am using Apache Ignite 2.8.0. In old versions I was able to select node_attributes by regular select from cache.

SELECT t.VALUE FROM ignite.node_attributes t WHERE t.name = 'MONITOR_NODE'

In 2.8.0 this select not working for me anymore. Maybe there is some options in ignite I forgot to change? Or there is a different selection for node attributes?

1 answer

  • answered 2020-09-14 09:29 Vladimir Pligin

    In Apache Ignite 2.8.0 you should use SYS schema to query node attributes. Something like that:

    SELECT t.VALUE FROM sys.node_attributes t WHERE t.name = 'MONITOR_NODE';