Re: How to find primary keys column of a table in ignite using sys tables?

2022-06-02 Thread Sachin janani
Hi , Thanks for the information. But the PARGMA is not working. Its giving parse exception as seen below. I tried different combination of this statement but none of it worked. 0: jdbc:ignite:thin://127.0.0.1/> PRAGMA PUBLIC.table_info(SUPPLIER); Error: Failed to parse query. Syntax error in SQL

Re: How to find primary keys column of a table in ignite using sys tables?

2022-06-02 Thread Юрий
Hi, There is the ticket [1] for the issue. While the ticket is not resolved try to use PRAGMA table_info(table-name); as explained in the SQLite PRAGMA documentation [2]. [1] https://issues.apache.org/jira/browse/IGNITE-16667 [2] http://www.sqlite.org/pragma.html#pragma_table_info пн, 30 мая

How to find primary keys column of a table in ignite using sys tables?

2022-05-30 Thread Sachin janani
Hi , I have created a table in ignite using SQLLine and I want to see which columns in that table are the primary key. When i queried *SYS.TABLE_COLUMNS* I don't see the Primary key columns.Can someone please help me how can i get the primary key columns of already created ignite table? Following

Re: 3rd party persistence: Mapping with RDBMS tables that don't have primary keys

2020-07-25 Thread Denis Magda
Hi Alex, > I'm not going to write any new records or update existing ones for such > tables through Ignite. So I can skip the overrides in CacheStore > implementation, right? (I'm using default implementation at the moment) That's right. https://apacheignite.readme.io/docs/id-generator > Thi

Re: 3rd party persistence: Mapping with RDBMS tables that don't have primary keys

2020-07-22 Thread Alex Panchenko
Hi Denis, thanks for your reply >>How will you access such records in Ignite? SQL lookups? Yes, using SQL lookups >>The default CacheStore implementation that writes down changes to a relational database needs to be overridden. I'm not going to write any new records or update existing ones for

Re: 3rd party persistence: Mapping with RDBMS tables that don't have primary keys

2020-07-21 Thread Denis Magda
to update those Postgres tables with Ignite data. - Denis On Tue, Jul 21, 2020 at 12:27 PM Alex Panchenko wrote: > Hi, > > I have an Ignite cluster with 3rd party persistence enabled (Postgres db). > I > have a few tables in Postgres which don't have primary keys bur I

3rd party persistence: Mapping with RDBMS tables that don't have primary keys

2020-07-21 Thread Alex Panchenko
Hi, I have an Ignite cluster with 3rd party persistence enabled (Postgres db). I have a few tables in Postgres which don't have primary keys bur I need to keep these tables in Ignite: They look like this table (as an example): KeyValuesTable { key: UUID value: String } NOTE

Re: primary keys

2020-06-19 Thread Ilya Kasnacheev
cheev >> >> >> чт, 18 июн. 2020 г. в 16:11, narges saleh : >> >>> Thanks Ilya. >>> Now I can see the complete plan, and it shows scanning the large tables >>> (but not the others). Increasing index size didn't help. >>> I only have primar

Re: primary keys

2020-06-18 Thread narges saleh
ery plans. > > Regards, > -- > Ilya Kasnacheev > > > чт, 18 июн. 2020 г. в 16:11, narges saleh : > >> Thanks Ilya. >> Now I can see the complete plan, and it shows scanning the large tables >> (but not the others). Increasing index size didn't help. >> I only have

Re: primary keys

2020-06-18 Thread Ilya Kasnacheev
> I only have primary keys on the caches and the fields in the primary keys > are the ones used in my where clause, so I am not sure > what's going on. > Currently, I am testing on one node only, so all the data should be in one > place. > > > On Thu, Jun 18, 2020 at

Re: primary keys

2020-06-18 Thread narges saleh
Thanks Ilya. Now I can see the complete plan, and it shows scanning the large tables (but not the others). Increasing index size didn't help. I only have primary keys on the caches and the fields in the primary keys are the ones used in my where clause, so I am not sure what's going on. Currently

Re: primary keys

2020-06-18 Thread Ilya Kasnacheev
versions may not be able to search by its fields. Regards, -- Ilya Kasnacheev чт, 18 июн. 2020 г. в 13:13, narges saleh : > Hi All, > > Shouldn't primary keys result in indexes and if so, shouldn't I be able to > see them when I list indexes? > Does inline index size applicable to p

primary keys

2020-06-18 Thread narges saleh
Hi All, Shouldn't primary keys result in indexes and if so, shouldn't I be able to see them when I list indexes? Does inline index size applicable to primary keys too? Additionally, when I do explain plan on a query which involves tables with primary keys, shouldn't I see the primary key/index