Re: SqlQuery deprecated

Tupitsyn wrote: >> Hi, >> The reason for deprecation is that SqlQuery is a limited subset of >> SqlFieldsQuery, which may be confusing. >> https://issues.apache.org/jira/browse/IGNITE-11334 >> On Mon, Jan 17, 2022 at 2:59 PM Surinder Mehra >> wrote: >>>

Re: SqlQuery deprecated

Can Ignite support the spark like dataframe API? Thanks On 17/01/2022 20:31, Pavel Tupitsyn wrote: Hi, The reason for deprecation is that SqlQuery is a limited subset of SqlFieldsQuery, which may be confusing. https://issues.apache.org/jira/browse/IGNITE-11334 On Mon, Jan 17, 2022 at 2:59 PM

Re: SqlQuery deprecated

Hi, The reason for deprecation is that SqlQuery is a limited subset of SqlFieldsQuery, which may be confusing. https://issues.apache.org/jira/browse/IGNITE-11334 On Mon, Jan 17, 2022 at 2:59 PM Surinder Mehra wrote: > I found the link how to read full object. But would still like

Re: SqlQuery deprecated

I found the link how to read full object. But would still like to understand why SqlQuery is deprecated. https://stackoverflow.com/questions/66248464/how-to-get-ignite-cache-sql-query-to-return-value-object On Mon, Jan 17, 2022 at 4:54 PM Surinder Mehra wrote: > Hi, > With Ignite

SqlQuery deprecated

Hi, With Ignite 2.9 or before Ignite supported SqlQuery but in 2.11 I see it is deprecated. Could you please tell us why and what is the alternative to it. SqlFieldQuery does not allow to read full object like below but individual fields which is cumbersome String sql1 = "select * from P

Re: SqlQuery Deprecated Since 2.8, please use SqlFieldsQuery instead....How to get result as passing model Type with SqlFieldsQuery?

Hello! Why not: SELECT t.*, t._val from materials t INNER JOIN ... Regards, -- Ilya Kasnacheev чт, 21 янв. 2021 г. в 19:19, siva : > Hi, > > It's working fine in "select _val from mytesttable" query but in case of > sub > query or joins it's failing with an error like column not found > > It'

Re: SqlQuery Deprecated Since 2.8, please use SqlFieldsQuery instead....How to get result as passing model Type with SqlFieldsQuery?

Hi, It's working fine in "select _val from mytesttable" query but in case of sub query or joins it's failing with an error like column not found It's failing access column with and without table Aliases. for example Query::> SELECT t.* from (select _val FROM materials ) as t INNER JOIN "F2DEDF6

Re: SqlQuery Deprecated Since 2.8, please use SqlFieldsQuery instead....How to get result as passing model Type with SqlFieldsQuery?

Hello, Try this: "select _val from mytesttable" чт, 21 янв. 2021 г. в 17:38, siva : > Hi, > I am using .net Ignite v2.9.1 and > > Since SqlQuery deprecated in documentation suggesting please use > SqlFieldsQuery. > > what is the way to get result as Type using

SqlQuery Deprecated Since 2.8, please use SqlFieldsQuery instead....How to get result as passing model Type with SqlFieldsQuery?

Hi, I am using .net Ignite v2.9.1 and Since SqlQuery deprecated in documentation suggesting please use SqlFieldsQuery. what is the way to get result as Type using sqlfieldsquery? for example query select * from mytesttable Thanks. -- Sent from: http://apache-ignite-users.70518.x6

Re: SqlQuery in CPP thin client

C++ thin client will support SQL in the future. Just a matter of time. - Denis On Thu, Feb 6, 2020 at 11:45 AM Abhay Gupta wrote: > Hi, > > Sorry I saw only the example , but all the details about ODBC connector > were mentioned on the site and I missed it . > > Thanks for your help . > > Rega

Re: SqlQuery in CPP thin client

Hi, Sorry I saw only the example , but all the details about ODBC connector were mentioned on the site and I missed it . Thanks for your help . Regards, Abhay > On 06-Feb-2020, at 10:32 PM, Abhay Gupta wrote: > > Hi > > Can you provide a reference example of using odbc driver to connect

Re: SqlQuery in CPP thin client

Hi Can you provide a reference example of using odbc driver to connect to ignite without using jvm where we provide the IP address if ignite node to connect or do you mean that only ignite odbc library has to be used and connection made as we do for normal odbc connection If that is the case c

Re: SqlQuery in CPP thin client

Hello! ODBC examples use JVM to run server node (which you obviously need), but ODBC driver does not have any Java dependency. Regards, -- Ilya Kasnacheev чт, 6 февр. 2020 г. в 19:48, Abhay Gupta : > Hi > > ODBC of ignite also used jvm as I saw in example and not thin client mode > which does

Re: SqlQuery in CPP thin client

Hi ODBC of ignite also used jvm as I saw in example and not thin client mode which does not require JNI . Am I missing something ? Regards Abhay > On 06-Feb-2020, at 9:43 PM, Ilya Kasnacheev wrote: > >  > Hello! > > You should use ODBC to do SQL queries from C/C++ code when running Igni

Re: SqlQuery in CPP thin client

Hello! You should use ODBC to do SQL queries from C/C++ code when running Ignite node is not desired. Regards, -- Ilya Kasnacheev чт, 6 февр. 2020 г. в 16:16, Abhay : > Hi, > > I checked with Java JDBC and we have the option to run query and same is > true for dot net client as well . > > In

SqlQuery in CPP thin client

Hi, I checked with Java JDBC and we have the option to run query and same is true for dot net client as well . In CPP thin connector using CacheClient we have option to Get , Put , Remove etc but no option to run Query . In the link given on site for binary protocol https://apacheignite.readme.

Re: SqlQuery retrieves same cache entry twice. ScanQuery results conflicts with indentical SqlQuery

Hi Ilya, Thanks for quick reply on my problem. I am running 2.5. Looks like issue i have has to do with IGNITE-8900 . I keep my fingers crossed that this serious issue is gone with 2.7. -- Sent from: http://apache-ignite-users.70518.x6.nabbl

Re: SqlQuery retrieves same cache entry twice. ScanQuery results conflicts with indentical SqlQuery

Hi Ilya, Thanks a lot for your reply. I am running 2.5. Looks like my problem has to do with IGNITE-8900 which should be fixed for 2.7. Keep my fingers crossed that 2.7 fixes this serious issue -- Sent from: http://apache-ignite-users.7051

Re: SqlQuery retrieves same cache entry twice. ScanQuery results conflicts with indentical SqlQuery

Hello! What is the Ignite version that you are using? Can you re-try using 2.7 if you're using an earlier one? Regards, -- Ilya Kasnacheev вс, 6 янв. 2019 г. в 20:54, oshevchenko : > Met very strange SqlQuery when executing simple query on partitioned. The > problem that the same

SqlQuery retrieves same cache entry twice. ScanQuery results conflicts with indentical SqlQuery

Met very strange SqlQuery when executing simple query on partitioned. The problem that the same cache entry is retrieved twice. Looks like first time entry gets retrieved from primary partition and second time it is taken from back up. Another problem that same ScanQuery gives correct results

RE: How to use SqlQuery for multi tables

you always specify schema explicitly in SQL query, there is no difference in which one to use. Thanks, Stan From: takumi Sent: 8 марта 2018 г. 18:02 To: user@ignite.apache.org Subject: RE: How to use SqlQuery for multi tables I solved my self. It was the cause that I didn't set to SqlSche

RE: How to use SqlQuery for multi tables

I solved my self. It was the cause that I didn't set to SqlSchema of CacheConfigration. Please tell me in connection with this. I don't know which instance query() method should be called. If it is an instance of the same schema, whichever one I am using will not change? -- Sent from: http://

RE: How to use SqlQuery for multi tables

Thank you for your reply. In addition to this, I want to know how to use SqlFieldsQuery instead of SqlQuery. I would like you to teach me about that. My code is here. -- public class Main { private static final String CACHE_NAME1 = "binaryC

RE: How to use SqlQuery for multi tables

From: takumi Sent: 7 марта 2018 г. 18:40 To: user@ignite.apache.org Subject: How to use SqlQuery for multi tables I want to use sql "select" from 2 caches. For example. SqlQuery sql = new SqlQuery(cache1, "select a.* from cache1 a, cache2 b where a.id = b.id"); QueryCursor>

How to use SqlQuery for multi tables

I want to use sql "select" from 2 caches. For example. SqlQuery sql = new SqlQuery(cache1, "select a.* from cache1 a, cache2 b where a.id = b.id"); QueryCursor> results = cache.query(sql); ※ cache1, cache2 have BinaryObject Data. I call QueryE

Re: SqlQuery with Cassandra cache

I was starting to think that was the case. Thanks for the help and verifying that for me, Val. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SqlQuery with Cassandra cache

Hi Kenan, SQL queries are executed against the data that is in memory. Read-though semantics works for key-based access only. If you need to query data that is both in memory and on disk, I'd recommend to take a look at Ignite native persistence: https://apacheignite.readme.io/docs/distributed-per

SqlQuery with Cassandra cache

Can someone explain to me what I'm doing wrong? I'm trying to query an Ignite cache backed up by Cassandra, but I keep getting the following error. Can a SqlQuery be created against a C*-backed cache? I would think so, but not sure exactly how and there are no good examples that I c

Re: Can JAVA API SqlQuery query a cache create by SQL DDL?

vkulichenko， thanks for your advice。 It works, by setting value_type=person during DDL, then running SqlQuery sql = new SqlQuery("person","id >? and id http://apache-ignite-users.70518.x6.nabble.com/

Re: Can JAVA API SqlQuery query a cache create by SQL DDL?

Hi, You should specify type name instead of cache name when creating the query: SqlQuery sql = new SqlQuery("person","id >? and id http://apache-ignite-users.70518.x6.nabble.com/

Can JAVA API SqlQuery query a cache create by SQL DDL?

Hi guys, I use JDBC client driver to create a table,like: stmt.executeUpdate("CREATE TABLE IF NOT EXISTS person ( id int,orgId LONG, name VARCHAR, salary LONG ,PRIMARY KEY (id)) WITH \"backups=1, affinityKey=id\""); Could I use SqlQuery API to query this cache? I tried t

Re: SqlQuery results missing

Ok, I found the problem. CacheConfiguration.setIndexTypes(a1,a2,...) requires pairs of type key.class and value.class. I used String.class for key while I should have been using AffinityKey.class. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SqlQuery results missing

donna.ignite.workshop.sql.SqlDataGridTest > ordered06_zoekPassantSectiePassages_SqlQuery_Test STANDARD_OUT *53 *gevonden passages van 'passant-7' met SQL (zoektijd: ca. 357 msec) As you can see from this output the test searches the sectie-passage cache for all SectiePassage w

Re: SqlQuery results missing

Hi Pim, Can you make sure: - Your SqlQuery is NOT local (sql.isLocal() must be false) - You did not restart any of your 5 server nodes during your exercises. Remember, if you restarted a node after loading data to the cluster, the data on that node is gone and you no longer have 5000

Re: SqlQuery results missing

The data is generated during start-up of the test. Data has a non expiration policy -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SqlQuery results missing

Hi, Yes, in fact I also have a map task to search each cache on each node. That task does find all items. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SqlQuery results missing

Pim, Can you confirm you really have 5000 items loaded to the cache (using visor or Web Console). Can you also share how you load the data. Normally your queries must find all 5000 items as you expected.

SqlQuery results missing

leName() + "[" + id + "](" + key() + ")"; } } This entity is registered with my cache configuration when my client (mode=true) connects with the cluster using: setIndexedTypes(String.class,SectiePassage.class); When the client is connected and executes a SqlQuery:

Re: Affinity and String key (was: SQLQuery with simple Join return no results)

… > > PortKey.java: > > public class PortKey implements Serializable { > > private UUIDid;// port-id; PK > private UUIDswitchId; // affinity key; not really part of PK > > … > > > > From: Denis Magda [mailto:dma...@apache.o

Affinity and String key (was: SQLQuery with simple Join return no results)

Magda [mailto:dma...@apache.org] Sent: Friday, September 01, 2017 3:07 PM To: user@ignite.apache.org Subject: Re: SQLQuery with simple Join return no results If you use Strings as the keys you won’t get affinity collocation set up properly and distributed joins will return an incomplete result

Re: SQLQuery with simple Join return no results

Yes, this one of the ways. Denis On Friday, September 1, 2017, matt wrote: > OK thanks for that. So does that then mean that the key type (K) for my > Cache > needs to be AffinityKey ? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >

Re: SQLQuery with simple Join return no results

OK thanks for that. So does that then mean that the key type (K) for my Cache needs to be AffinityKey ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SQLQuery with simple Join return no results

( qry); > > Roger > > -Original Message- > From: matt [mailto:goodie...@gmail.com <mailto:goodie...@gmail.com>] > Sent: Friday, September 01, 2017 1:52 PM > To: user@ignite.apache.org <mailto:user@ignite.apache.org> > Subject: SQLQuery with simple Join r

RE: SQLQuery with simple Join return no results

); qry.setDistributedJoins( true); queryCursor = aCache.query( qry); Roger -Original Message- From: matt [mailto:goodie...@gmail.com] Sent: Friday, September 01, 2017 1:52 PM To: user@ignite.apache.org Subject: SQLQuery with simple Join return no results I have 2 caches defined, both with

SQLQuery with simple Join return no results

. My index types are set on the caches as well. If I do a ScanQuery, I can see that all of the fields and IDs are correct, Ignite returns them all. But when doing a SqlQuery, I get nothing back. Ignite is not complaining about the query, it's just returning an empty cursor. If I remove the Jo

Re: SqlQuery inside affinityCall

-ignite-users.70518.x6.nabble.com/SqlQuery-inside-affinityCall-tp16205p16212.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

SqlQuery inside affinityCall

message in context: http://apache-ignite-users.70518.x6.nabble.com/SqlQuery-inside-affinityCall-tp16205.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: [Paging] QueryCursor and SqlQuery

nabble.com/Paging-QueryCursor-and-SqlQuery-tp15712p15743.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: [Paging] QueryCursor and SqlQuery

Hi, Ignite API does not provide pagination out of box. You can achieve it by your SQL query as in most of DB. On Thu, Jul 27, 2017 at 4:33 AM, woo charles wrote: > Hi, > How can I do paging when query from ignite cache? > > Can I get records by range? specific page? > > If I have 1 rows of

[Paging] QueryCursor and SqlQuery

Hi, How can I do paging when query from ignite cache? Can I get records by range? specific page? If I have 1 rows of records with page size set to 20, how can I get the 21-40 (Page 2)?

Re: SqlQuery for hibernate entities defined in *.hbm.xml

-mix.readme.io/docs/hibernate-l2-cache -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SqlQuery-for-hibernate-entities-defined-in-hbm-xml-tp12546p15031.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: SQLQuery and Datatypes

; that I can create queries on the same line if I choose not to use setArgs. > > Thanks, > -Sam > > > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/SQLQuery-and-Datatypes-tp12167p12210.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >

Re: SQLQuery and Datatypes

-ignite-users.70518.x6.nabble.com/SQLQuery-and-Datatypes-tp12167p12210.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: SQLQuery and Datatypes

various parameters. For static SQL it always been workarounded. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQLQuery-and-Datatypes-tp12167p12200.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

SQLQuery and Datatypes

Hi My cached object is Binarylizable. I am using SQLQuery and SQLFieldQuery. In some cases I need to query on a hardcoded/fixed filter e.g. Name = 'xyz'. Same usecase for Long, Date, TimeStamp datatype as well. Basically not using setArgs(). I see it works fine for String, Int, Lo

Re: SQLQuery

Hi, thank you very much -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQLQuery-tp8785p8830.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: SQLQuery

entUpdate type. This way you can simply query LinkObject-s without a join. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQLQuery-tp8785p8791.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

SQLQuery

this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQLQuery-tp8785.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Is SqlQuery efficient than SqlFieldsQuery?

Hi Patrick, Please properly subscribe to the mailing list so that the community can receive email notifications for your messages. To subscribe, send empty email to user-subscr...@ignite.apache.org and follow simple instructions in the reply. wbyeh wrote > I have used a SqlQuery to instead o

Re: SqlQuery on hierarchy of classes doesn't work

r the `cache`, nothing is returned > back (even though the cache.size() eq to 5). Same true in H2 console - > trying to query for * entries returns empty resultset (even doing new > `SqlQuery<>(Location.class, "1 == 1");` returns empty list back. > > Although if I

SqlQuery on hierarchy of classes doesn't work

returns empty resultset (even doing new `SqlQuery<>(Location.class, "1 == 1");` returns empty list back. Although if I change everything to use the concrete class PlayerLocation, everything then works like expected, I can query entries from H2, get the expected resultset from Java co

Re: SQLQuery JOIN does not accept multiple parameters in list/array as placeholder.

Thanks It worked ! -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQLQuery-JOIN-does-not-accept-multiple-parameters-in-list-array-as-placeholder-tp6837p6868.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: SQLQuery JOIN does not accept multiple parameters in list/array as placeholder.

Hi, I responded earlier to a similar issue here: http://apache-ignite-users.70518.x6.nabble.com/Getting-exception-in-SQL-Query-JOINS-td6674.html. Did it work for you? -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQLQuery-JOIN-does-not-accept-multiple

Re: SQLQuery JOIN does not accept multiple parameters in list/array as placeholder.

Can some one please reply to this. Is it a bug or I am doing something wrong. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQLQuery-JOIN-does-not-accept-multiple-parameters-in-list-array-as-placeholder-tp6837p6854.html Sent from the Apache Ignite Users

SQLQuery JOIN does not accept multiple parameters in list/array as placeholder.

Hi, I am trying to use SqlQuery JOIN clause as mentioned in below link which is work around to avoid IN clause of Sql Query. As mentioned in docuents, we can pass array or lits of parameters, but query does not accept array or list with more than one parameter http://apacheignite.gridgain.org/docs

Re: Is there any such thing as SQlBuilder in apache Ignite for SQLQuery

-in-apache-Ignite-for-SQLQuery-tp6541p6597.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Is there any such thing as SQlBuilder in apache Ignite for SQLQuery

random page. > > -Val > > -- > If you reply to this email, your message will be added to the discussion > below: > > http://apache-ignite-users.70518.x6.nabble.com/Is-there-any-such-thing-as-SQlBuilder-in-apache-Ignite-for-SQLQuery-tp6541p6572.html > To unsubscribe from

Re: Is there any such thing as SQlBuilder in apache Ignite for SQLQuery

page. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Is-there-any-such-thing-as-SQlBuilder-in-apache-Ignite-for-SQLQuery-tp6541p6572.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Is there any such thing as SQlBuilder in apache Ignite for SQLQuery

-SQlBuilder-in-apache-Ignite-for-SQLQuery-tp6541p6560.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Is there any such thing as SQlBuilder in apache Ignite for SQLQuery

different results in case an update happened between two executions of the query. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Is-there-any-such-thing-as-SQlBuilder-in-apache-Ignite-for-SQLQuery-tp6541p6546.html Sent from the Apache Ignite Users mailing list

Is there any such thing as SQlBuilder in apache Ignite for SQLQuery

I am using sql queries to implement pagination in ignite cache. Below is my code to build sql to be passed to SQLQuery. It looks very messy as there are lot of checks and if else. Is there something in ignite like builder which will do the task? String sql = " select * from Employee&quo

Re: cursor.getAll() throws NoSuchMethodError excepion when SqlQuery is executed

-SqlQuery-is-executed-tp6489p6492.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Column not found exception while running SqlQuery i Ignite.

olumn-not-found-exception-while-running-SqlQuery-i-Ignite-tp6464p6486.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >

cursor.getAll() throws NoSuchMethodError excepion when SqlQuery is executed

I am getting below exception when i call getAll() on cursor returned from SqlQuery. My POJO class fields are annotated with @QuerySqlField(index=true) except the ones which are collections(Set and Lits of other cutom Objet. I have enabled indexing in cache using below configuration

Re: Column not found exception while running SqlQuery i Ignite.

-exception-while-running-SqlQuery-i-Ignite-tp6464p6486.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Column not found exception while running SqlQuery i Ignite.

Hi Thanks, Sorry for typo, It still does not work. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Column-not-found-exception-while-running-SqlQuery-i-Ignite-tp6464p6480.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Column not found exception while running SqlQuery i Ignite

This thread duplicates http://apache-ignite-users.70518.x6.nabble.com/Column-not-found-exception-while-running-SqlQuery-i-Ignite-td6464.html -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Column-not-found-exception-while-running-SqlQuery-i-Ignite-tp6466p6476

Re: Column not found exception while running SqlQuery i Ignite.

Hello begineer, Please use the same type for parameter as property type for example Date startdate = new Date(2016, 03, 03); -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Column-not-found-exception-while-running-SqlQuery-i-Ignite-tp6464p6467

Column not found exception while running SqlQuery i Ignite

Hi, I am getting column not found exception when I run SqlQuery. not sure why. below is my code. When I query using name and Id, I get results, When I use date or localDate types to query, I get exception " Caused by: org.h2.jdbc.JdbcSQLException: Column "COMPANY.INAGURATION"

Re: SqlQuery and removing/evict items from the cache

t; the cache? > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/SqlQuery-and-removing-evict-items-from-the-cache-tp5754.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Best regards, Alexei Scherbakov

SqlQuery and removing/evict items from the cache

.70518.x6.nabble.com/SqlQuery-and-removing-evict-items-from-the-cache-tp5754.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: .NET SQLQuery Error

that >> till 1.6 is GA? >> On Apr 11, 2016 7:28 AM, "Pavel Tupitsyn" wrote: >> >>> In fact, keyType and valType can be arbitrary strings. >>> They are used to create SQL tables internally. >>> Look at SqlQuery constructors: some of them

Re: .NET SQLQuery Error

se that > till 1.6 is GA? > On Apr 11, 2016 7:28 AM, "Pavel Tupitsyn" wrote: > >> In fact, keyType and valType can be arbitrary strings. >> They are used to create SQL tables internally. >> Look at SqlQuery constructors: some of them accept "st

Re: .NET SQLQuery Error

ed to create SQL tables internally. > Look at SqlQuery constructors: some of them accept "string queryType". > This string must be equal to valType string in configuration. > > Using type name without namespace is just a convention. SqlQuery > constructor with "Type q

Re: .NET SQLQuery Error

In fact, keyType and valType can be arbitrary strings. They are used to create SQL tables internally. Look at SqlQuery constructors: some of them accept "string queryType". This string must be equal to valType string in configuration. Using type name without namespace is just a

Re: .NET SQLQuery Error

t;>>>> >>>>>> Apache.Ignite.Core.Common.IgniteException was unhandled >>>>>> HResult=-2146233088 >>>>>> Message=Indexing is disabled for cache: BU. Use setIndexedTypes or >>>>>> setTypeMetadata methods on CacheConfiguration to en

Re: .NET SQLQuery Error

StackTrace: >>>>>at >>>>> Apache.Ignite.Core.Impl.Unmanaged.UnmanagedCallbacks.Error(Void* target, >>>>> Int32 errType, SByte* errClsChars, Int32 errClsCharsLen, SByte* >>>>> errMsgChars, Int32 er

Re: .NET SQLQuery Error

t;>>> ctx, Void* obj, Int32 type, Int64 memPtr) >>>>at >>>> Apache.Ignite.Core.Impl.Unmanaged.UnmanagedUtils.CacheOutOpQueryCursor(IUnmanagedTarget >>>> target, Int32 type, Int64 memPtr) >>>>

Re: .NET SQLQuery Error

.CacheImpl`2.Query(QueryBase qry) >>>at TestIgniteSQLClient.IgniteSQLClient.Main(String[] args) in >>> C:\Data\Professional\dotnet\workspace\TestIgnite\TestIgniteSQLClient\IgniteSQLClient.cs:line >>> 34 >>> InnerException: &g

Re: .NET SQLQuery Error

pr 9, 2016 at 11:32 AM, Pavel Tupitsyn >> wrote: >> >>> Hi Satya, >>> >>> > Indexing is disabled for cache: BU. >>> In the XML configuration, please set cache name like this: >>> >>> ... >>> >>> >>> .

Re: .NET SQLQuery Error

please set cache name like this: >> >> ... >> >> >> ... >> >> >> > do I have to specify the column type classes in java(ex java.lang.Long >> etc) in the config xml even if I am working in .NET world

Re: .NET SQLQuery Error

using Spring XML and Java types is the only way. > This is already fixed, and in upcoming Ignite 1.6 everything can be > configured right from C#. > > Thanks, > Pavel. > > On Sat, Apr 9, 2016 at 5:10 PM, Murthy Kakarlamudi > wrote: > >

Re: .NET SQLQuery Error

ML and Java types is the only way. This is already fixed, and in upcoming Ignite 1.6 everything can be configured right from C#. Thanks, Pavel. On Sat, Apr 9, 2016 at 5:10 PM, Murthy Kakarlamudi wrote: > Hi All, > I am running into below error trying to run SqlQ

.NET SQLQuery Error

Hi All, I am running into below error trying to run SqlQuery in .NET. Apache.Ignite.Core.Common.IgniteException was unhandled HResult=-2146233088 Message=Indexing is disabled for cache: BU. Use setIndexedTypes or setTypeMetadata methods on CacheConfiguration to enable. Source

Re: SqlQuery Error

type=TestTable1&pzs=10&cacheName=TestTable1Cache&arg0=2&qry=id%3d%3f > > {"error":"class org.apache.ignite.IgniteException: Failed to find SQL table > for type: TestTable1","response":null,"sessionToken":"","successStatus&qu

Re: SqlQuery Error

"","successStatus":1} Any advice? Thanks. Tony -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SqlQuery-Error-tp3658p3708.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: SqlQuery Error

quot;, "java.lang.String"); fields.put("attribute3", "java.lang.String"); Query - SqlQuery sql = new SqlQuery(Testtable1.class, "id=?").setArgs("9"); Can you please check if it works for you? --Yakov 2016-03-24 12:31 GMT+03:00 16616...@qq.com <16616...@qq.co

Re: SqlQuery Error

You can download my src file here. <http://artadv.cn/src.zip> Thanks! -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SqlQuery-Error-tp3658p3662.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: SqlQuery Error

at.id != null) > return false; > > if (attribute1 != null ? !attribute1.equals(that.attribute1) : > that.attribute1 != null) > return false; > > if (attribute2 != null ? !attribute2.equals(that.attribute2) : > that.attribute2 != null) > return false; > > if (attribute3 != null ? !attribute3.equals(that.attribute3) : > that.attribute3 != null) > return false; > > return true; > } > > /** {@inheritDoc} */ > @Override public int hashCode() { > int res = id != null ? id.hashCode() : 0; > > res = 31 * res + (attribute1 != null ? attribute1.hashCode() : 0); > > res = 31 * res + (attribute2 != null ? attribute2.hashCode() : 0); > > res = 31 * res + (attribute3 != null ? attribute3.hashCode() : 0); > > return res; > } > > /** {@inheritDoc} */ > @Override public String toString() { > return "Testtable1 [id=" + id + > ", attribute1=" + attribute1 + > ", attribute2=" + attribute2 + > ", attribute3=" + attribute3 + > "]"; > } > } > > > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/SqlQuery-Error-tp3658p3660.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >

Re: SqlQuery Error

* res + (attribute2 != null ? attribute2.hashCode() : 0); res = 31 * res + (attribute3 != null ? attribute3.hashCode() : 0); return res; } /** {@inheritDoc} */ @Override public String toString() { return "Testtable1 [id=" + id + ", attribute1=" + attribute1 + ", attribute2=" + attribute2 + ", attribute3=" + attribute3 + "]"; } } -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SqlQuery-Error-tp3658p3660.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

  1   2   >