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/
