Re: sql insert with composite primary key

2017-11-30 Thread vkulichenko
Then the insert syntax I provided should work. -Val -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: sql insert with composite primary key

2017-11-29 Thread Fff
HI, Thanks for your help! We define it using QueryEntity by providing 'keyFields' property: triggerId biEventId

Re: sql insert with composite primary key

2017-11-29 Thread vkulichenko
Hi, How do you define the schema? Using DDL or in CacheConfiguration? Basically, you don't need to use _key at all here since TriggerId and BiEventId actually compose the primary key. But you need to make sure Ignite knows about that. For example, if you create a table like this: CREATE TABLE Tr

sql insert with composite primary key

2017-11-29 Thread Fff
Hi, My POJO has composite primary key. e.g. public class TriggerDefinition { @Id private TriggerDefinitionKey triggerDefinitionKey; } public TriggerDefinitionKey(Long triggerId, Long biEventId) { this.triggerId = triggerId; this.biEventId = biEventId; } My questio