Re: Load data to cache

Hi, I tried following code to load cache. Could you please correct the code, If It is wrong? IIgnite ignite = Ignition.Start(@"F:\Visual Studio2015\Projects\CreateCluster\CreateCluster\my-file.xml"); var cache = ignite.GetCache("NORTHWND"); object[] arg

Re: What is the best approach for large number of concurrent mappings?

Hi, Can you please clarify what you mean by continuous mapper here? Actually, your use case sounds similar to one implemented in the WordCount example provided with Ignite: https://github.com/apache/ignite/tree/master/examples/src/main/java/org/apache/ignite/examples/streaming/wordcount -Val

Re: Distributed Closures VS Executor Service

Hi Kyriako, - If I want to pass data to callables, for example Lists of objects, small to -medium size (collections from 2000 to 6000 objects maximum, with average object size some ~200KBs) what is the best way to do this: to pass them as argument in callables or put them in the distributed cache

Re: Query execution is too long warning while running Yardstick-ignite

I've run benchmark on my laptop and doesn't see long running queries. Les't verify that we use the same configs and scripts. Could you share the first lines from ThroughputLacencyProbe.cvs? I got the following: --Probe dump file for probe:

Re: Distributed Closures VS Executor Service

Hi, Ignite has internal implementation ThreadPoolExecutor, which used in ignite compute, and it has BlockingQueue with Integer#MAX_VALUE internal. Lock at in IgniteThreadPoolExecutor [1]. [1]:

Re: New blog post: LINQ vs SQL in Ignite.NET: Performance

Easy readable and as usually a comprehensive blog from Pavel! Recommend everyone to spend a couple of minutes for it. Pavel, do you think we can apply the same optimizations LING does for our “raw” SQL queries? Prachi, please post to DZone and find a time updating the blogs page. — Denis >

New blog post: LINQ vs SQL in Ignite.NET: Performance

Enjoy: https://ptupitsyn.github.io/LINQ-vs-SQL-in-Ignite/

Re: How can I perform SqlFieldsQuery on DateTime field (binary cache)?

Can you attach full exception details, with inner exception and so on? On Mon, Mar 27, 2017 at 4:29 PM, ozgurnevres wrote: > > > Hi, again > Thanks for the answer. > > Now my PopulateCache method is like below (I didn't change any other thing > from my previous post): >

Re: How can I perform SqlFieldsQuery on DateTime field (binary cache)?

Sorry my mistake it works, thanks! I wrote "birthdate" instead of "birthday" at the query line. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-can-I-perform-SqlFieldsQuery-on-DateTime-field-binary-cache-tp11457p11474.html Sent from the Apache Ignite Users

Re: How can I perform SqlFieldsQuery on DateTime field (binary cache)?

Hi, again Thanks for the answer. Now my PopulateCache method is like below (I didn't change any other thing from my previous post): private static void PopulateCache(ICache cache) { IBinary binary = cache.Ignite.GetBinary(); //

Re: How can I perform SqlFieldsQuery on DateTime field (binary cache)?

Use SetTimestampField with DateTime instead of SetField, and use ToUniversalTime on values. DateTime can be written in two formats, details: https://apacheignite-net.readme.io/docs/sql-queries#section-java-type-name-mapping On Mon, Mar 27, 2017 at 3:02 PM, ozgurnevres

Re: Load data to cache

I can't see you putting any value into your cache. If you want to load it from a storage you need to call cache.loadCache(); Best Regards, Igor On Mon, Mar 27, 2017 at 2:27 PM, kavitha wrote: > Okay fine. > I have NORTHWND sql database. Table name is 'Categories' and

Re: How can I perform SqlFieldsQuery on DateTime field (binary cache)?

And I forgot to answer your question, yes, this is Ignite.net -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-can-I-perform-SqlFieldsQuery-on-DateTime-field-binary-cache-tp11457p11470.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: How can I perform SqlFieldsQuery on DateTime field (binary cache)?

Hi, Pitupitsyn Thanks for the quick reply! After trying a bit more, I realized that there might be another problem. Here my steps if you want to reproduce (Five steps total): 1- I downloaded Apache.Ignite.Examples sln and working on it. 2- On BinaryCodeExample.cs, I first added a DateTime field

Re: Load data to cache

Okay fine. I have NORTHWND sql database. Table name is 'Categories' and their columns are CategoryID, CategoryName, Description. My code is below. But I can't get data. Empty Table only displayed. Can you please say me what I am missing here? using System; using System.Collections.Generic; using

Re: Pessimistic TXN did not release lock on a key, all subsequent txns failed

It's very strange NPE. It looks like cache is closed or destoryed. Is it possible that you start and close/destroy caches dynamically? On Fri, Mar 24, 2017 at 5:43 PM, bintisepaha wrote: > Hey Andrey, Thanks a lot for getting back. > > These errors were a result of a bad

Re: Create Ignite database

Hi, What do you mean by "create database"? You should just create some caches, put your data in them, then connect to one of the cluster's nodes and run SQL queries just as if the caches were schemas and the value types were tables. Currently, you can't create caches or tables using SQL as

Re: Monitoring Cache - Data counters, Cache Data Size

Hi Binti, First of all, cache metrics must be enabled with CacheConfiguration.setStatisticsEnabled(true). But size and keySize show local values anyway, that looks like a bug. I've filed a ticket for that [1]. If you want, feel free to contribute. [1]

Re: Load data to cache

Currently, Ignite does not support DDL, though it is planned for the Ignite 2.0, so you can't create databases using SQL now. Instead you should assume that you already have database, where the schemas are caches and tables are types. So to get data from your caches you'd need to run some query

Re: ODBC driver installation error

Well, the issue is that logging config file is absent. To solve it you should add a logging config file. Alternatively, you can enable "log4j" module. Best Regards, Igor On Mon, Mar 27, 2017 at 8:54 AM, kavitha wrote: > Hi, > > While starting node with Spring XML file,

Re: Load data to cache

Hi, This is my ODBC code. Is it possible to create database as mentioned below. OdbcConnection con = new OdbcConnection("DRIVER={Apache Ignite};ADDRESS=localhost:10800;CACHE=Person"); con.Open(); var command = con.CreateCommand(); command.CommandText = "create

Re: Load data to cache

You say you connect to the Ignite using ODBC driver, right? So the question is how you do that. Do you use some external tool or do you write some code to do so on your own? I can't see any ODBC-related code here or any mentions on how you are trying to get the data. You only say you've failed to

Re: Load data to cache

Hi Igor, I shared all my code previously. I don't understand what you ask. ODBC code means? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Load-data-to-cache-tp11394p11460.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Load data to cache

I've tried to reproduce the issue and I'm getting the data from the cluster using ODBC. Can you share your ODBC code, which queries data? Or do you use some third-party tool for that? Best Regards, Igor On Sat, Mar 25, 2017 at 6:33 AM, kavitha wrote: > Hi Igor, > >

Re: How can I perform SqlFieldsQuery on DateTime field (binary cache)?

Hi, this is Ignite.NET, right? You should always use SQL parameters: var rows = _cache.QueryFields(new SqlFieldsQuery("select productid, recorddate, inventory from product where inventory > ?", 10)); With DateTime just make sure it is UTC: var rows = _cache.QueryFields(new

How can I perform SqlFieldsQuery on DateTime field (binary cache)?

My query is: var rows = _cache.QueryFields(new SqlFieldsQuery("select productid, recorddate, inventory from product where recorddate > '2016-03-27'")); and I get the exception below: Failed to run map query remotely but this works: var rows = _cache.QueryFields(new SqlFieldsQuery("select

Create Ignite database

Hi, How create own database to connect through ignite ODBC driver? Anyone please elaborate this? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Create-Ignite-database-tp11456.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.