How to get the column names(or fieldsNames) of existing ignite sql table

[siva]

Hi,

Creating tables using sql api

                 IgniteCache cache = ignite.getOrCreateCache(new
CacheConfiguration<>().setSqlSchema("PUBLIC").setName(cacheName));

createtableQuery = create table Person(name varchar ,id int primarykey) with
"template ="Replicated".

 cache.query(new SqlFieldsQuery(createtableQuery)).getAll();



Quetions:
=======
1.How to get the existing table columnNames ?

i am trying to use this query but its throwing exception

*select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where
TABLE_NAME='Person'*

2.When i create a table with above configurations

two caches gets creating 

one is *cache-SQL_PUBLIC_PERSON*
another which i have passed while creating table cache-Persons

is it default functionality of ignite?















--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/