unsubscribe

unsubscribe

unsubscribe

Kurt Semba Principal Software Engineer / Extreme Networks GmbH kse...@extremenetworks.com<mailto:kse...@extremenetworks.com> Phone: +49 (0)69 4 786 0-136 Mobile: +49 (0)172 66 399 53

RE: Issue querying id column only

SERT INTO people (id, first_name, last_name) VALUES (1, 'John', 'Doe'); INSERT INTO people (id, first_name, last_name) VALUES (2, 'John', 'Foe'); SELECT id FROM people; Denis On 17 Oct 2019, 09:02 +0300, Kurt Semba mailto:kse...@extremenetworks.com>&g

Query Parallelism through SQL

Hi all, Is there a way to define query parallelism for tables created through a SQL CREATE TABLE statement? Thanks Kurt

Issue querying id column only

Hi all, Is it possible for a table through the SQL interface to only return some subset of data if querying against a specific column? e.g. We have a cache configuration defined based on Java SQL Query annotations that contains an id field and some other string fields. The value of the id fiel

RE: Cancel SQL Queries

SQL Queries External Email: Use caution in opening links or attachments. Hello! Timeout on JDBC connection will be provided in 2.8. Until then, you should be able to use Web Console to cancel queries. Regards, -- Ilya Kasnacheev пн, 14 окт. 2019 г. в 10:47, Kurt Semba mailto:kse

Caches and H2 tables

Hi all, is there a way to associate already existing caches that were not defined with the SQL DML commands/Spring configuration with the meta tables in H2? My understanding is that if “CREATE TABLE…” is created, some meta information is defined in H2 and is backed by the Ignite cache. If I def

Cancel SQL Queries

Hi all, We have a reporting application that is being built with Logi Info Studio that leverages the Ignite JDBC Thin Driver to access a remote Ignite server node that contains caches that have native persistence enabled. When certain queries are not designed correctly, there is a possibility t

RE: Authorizing thin clients

rks.com%7Cc02ae08f47434df9ab0608d7471ab370%7Cfc8c2bf6914d4c1fb35246a9adb87030%7C0%7C0%7C637056052333547344&sdata=YX6UO3jaaxnvZDEB%2Bc3JV9SbHjdoYV7iwcOAGn3crDw%3D&reserved=0> BR, Andrei 10/1/2019 3:08 PM, Kurt Semba пишет: Hi all, is there a way to define which SQL statements a thin cl

Authorizing thin clients

Hi all, is there a way to define which SQL statements a thin client is allowed to execute (some users don’t need the rights to drop / create /alter tables, etc.)? Or which SQL tables that client is allowed to query? Thanks Kurt

RE: Authentication

n-for-apache-ignite&data=02%7C01%7Cksemba%40extremenetworks.com%7C1f29f6282342405ec62408d73b4c0c93%7Cfc8c2bf6914d4c1fb35246a9adb87030%7C0%7C0%7C637043070136808175&sdata=TJ8p%2BdRvJFTJUP3Q0zeImvPJiTXX8yq92uu6CG5VxQY%3D&reserved=0> BR, Andrei 9/16/2019 1:26 PM, Kurt Semba пишет: H

RE: Authentication

fb35246a9adb87030%7C0%7C0%7C637042255736551100&sdata=okrAhi7i44OewjWQxYQqUdECIEqpFxBPBA%2F13%2F%2FvMBI%3D&reserved=0> BR, Andrei 9/16/2019 10:43 AM, Kurt Semba пишет: Hi all, I used the web-console to auto-generate some code and then extended the ServerNodeCodeStartup.java class acco

Authentication

Hi all, I used the web-console to auto-generate some code and then extended the ServerNodeCodeStartup.java class according to the documentation to enable authentication (which requires to enable persistence) like this: public static void main(String[] args) throws Exception { IgniteConf

RE: Data from multiple MySQL DBs

from multiple MySQL DBs Hello! I think the best course will be to read all DBs in user code and use data streamer to populate Ignite. Regards, -- Ilya Kasnacheev вт, 10 сент. 2019 г. в 18:01, Kurt Semba mailto:kse...@extremenetworks.com>>: Hi all, I need to sync data from multiple MySQL

Data from multiple MySQL DBs

Hi all, I need to sync data from multiple MySQL databases into Ignite. All those MySQL databases follow the same schema / same tables but obviously contain different data. They are separate instances of the same DB and we want to pull all that data into Ignite to have a central store to query a