Re: Ignite benchmarking with YCSB

Hello! I would start with tuning thread pool sizes if I see CPU under-loaded: https://apacheignite.readme.io/docs/thread-pools You will need to do thread dump mid-benchmark to see which thread pools are full. Regards, -- Ilya Kasnacheev чт, 22 нояб. 2018 г. в 20:28, summasumma : > Hi all,

Re: In which case will ignite run following sql?

Hello! This is just reducer phase query of SELECT _key, _val FROM table; https://apacheignite-sql.readme.io/docs/select#section-description Which is something you will do implicitly if you run an empty SqlFieldsQuery (without WHERE). Regards, -- Ilya Kasnacheev чт, 22 нояб. 2018 г. в 15:13,

Re: (IF NOT EXISTS) in CREATE TABLE statement does not work

Hello! I guess you will have to search server node log for complete stack trace with cause. Here we don't see what caused the exception. Regards, -- Ilya Kasnacheev пн, 26 нояб. 2018 г. в 10:15, Qingping <15075...@qq.com>: > When testing Ignite 2.6.0 (2018-07-16), it was found that (IF NOT

(IF NOT EXISTS) in CREATE TABLE statement does not work

When testing Ignite 2.6.0 (2018-07-16), it was found that (IF NOT EXISTS) in the CREATE TABLE statement did not work. code show as below: Class.forName("org.apache.ignite.IgniteJdbcThinDriver");try (Connection conn = DriverManager.getConnection("jdbc:ignite:thin://127.0.0.1/")){

Re: Optimum storage startegy (Advice?)

Hello! I think you should be using Streaming Mode or Data Streamer to insert data for SQL, which you seem to already do. Regards, -- Ilya Kasnacheev сб, 24 нояб. 2018 г. в 16:49, joseheitor : > Given the following model structure: > > { > "trans": { > "cust": { > "firstname":

Re: JDBC Streaming

Hello! Yes, streaming mode is not supported by client node driver. In this case your best bet is using Data Streamer anyway. https://apacheignite.readme.io/v2.6/docs/data-streamers Regards, -- Ilya Kasnacheev вс, 25 нояб. 2018 г. в 11:45, joseheitor : > Is Streaming perhaps not supported

Re: Continuous queries and duplicates

Hello! SQL queries have no isolation currently so it is not possible to avoid the problem that you described. You could try switching to ScanQuery, see if it helps; or learning to deal with duplicates. Regards, -- Ilya Kasnacheev пт, 23 нояб. 2018 г. в 19:25, Sobolewski, Krzysztof <

Re: Re: can ignite accelerate sparkOnHive

@Franke , we use spark sql do OLAP and ETL , where the data was store on hive. So I wonder if ignite is suitable for such a scenario, make IFGS as a transparent cache about HDFS , and spark sql on hive can benefit from it. 2018-11-26 lk_hadoop 发件人：Jörn Franke 发送时间：2018-11-23 16:12 主题：Re:

Re: How to write Trigger Script

https://apacheignite.readme.io/docs/continuous-queries сб, 24 нояб. 2018 г. в 03:55, Malashreepolo : > How to write Triggers in Ignite Database. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >

Re: BinaryObject nested fields syntax?

Hi, In this case, customer should be also a BinaryObject, so, you have to access it at first and only after get a certain field. Evgenii сб, 24 нояб. 2018 г. в 00:38, joseheitor : > Given the following model data structure for a given document record: > > { > "trans": { > "cust": { >

Re: Are QuerySqlField indexes used in ScanQueries?

Hi, No, ScanQuery doesn't use QuerySqlField indexes Evgenii сб, 24 нояб. 2018 г. в 01:34, joseheitor : > If model class fields are annotated with: > > @QuerySqlField(index = true) > > ... will ScanQueries with IgniteBiPredicates on the annotated fields > leverage the indexes? > > > > -- > Sent

Re: Ignite startu is very slow

For this particular case, it's just enough to stop cluster gracefully before starting it again. Just deactivate cluster before stopping. In this case, when you will start the nodes again, they won't need to apply WAL changes. Evgenii вс, 25 нояб. 2018 г. в 04:54, kvenkatramtreddy : > Heap size

Re: Ignite startu is very slow

Heap size is 3 GB. And MaxDirectMemorySize is 1.5 GB. My cache size is around 2 GB and on Disk around 5-6 GB maximum. My total cache elements are around 50-60 thousands. I will receive around 700-800 thousand messages for a day and I will update that in cache. So please could you let me know

Re: JDBC Streaming

Is Streaming perhaps not supported with JDBC Client driver...? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/