Hello! You can use SqlFieldsQuery to return data from system views (of the node on which you invoke the SqlFieldsQuery). Please note that cache SYS does not exist initially, nor any other caches with schema SYS. You may use any existing cache instead.
You can run any code on the server nodes also, in the form of services, Spring beans or distributed compute. You can run compute operations on server node from the client node, for example. Regards, -- Ilya Kasnacheev сб, 30 янв. 2021 г. в 01:06, Nathan Neely <nathan.ne...@benefitfocus.com>: > How can I query system views from a server node? I have looked at example > code for clients: > https://ignite.apache.org/docs/latest/monitoring-metrics/system-views, > but I can’t seem to find any examples for server nodes. > > Can you use SqlFieldsQuery to return data from system views? > > > > IgniteCache<?, ?> cache = getIgnite().cache("SYS"); > if(cache != null){ > SqlFieldsQuery sqlq = new SqlFieldsQuery("SELECT * from NODES" > ).setSchema("SYS"); > cache.query(sqlq).getAll(); > } > > > > > > Thanks, > > > > *Nathan Neely* > > *Engineer IV, Software 5x Core* > > Benefitfocus for *life*™ > > Benefitfocus® (NASDAQ: BNFT) unifies the entire benefits industry on a > single technology platform to protect consumers for life. Our powerful > cloud-based software, data-driven insights and thoughtfully-designed > services enable employers, insurance brokers, health plans and suppliers to > simplify the complexity of benefits administration and deliver health, > wealth, property and lifestyle products through a world-class benefits > experience. Our mission is simple: to improve lives with benefits. Learn > more at www.benefitfocus.com, LinkedIn > <https://www.linkedin.com/company/benefitfocus> and Twitter > <http://www.twitter.com/benefitfocus>. >