interactive shell

Hi Can Ignite have an interactive shell (like pyspark) for SQL similar operations in the future version? Thanks

[ANNOUNCE] Apache Ignite 2.12.0 Released

The Apache Ignite Community is pleased to announce the release of Apache Ignite 2.12.0. Apache Ignite® is a Distributed Database For High-Performance Computing With In-Memory Speed. https://ignite.apache.org The Apache Ignite community has made a lot of changes in the 2.12.0 release. This blog

Re: Reading partition file in work/db

It’s not that simple. When you write into a table it is not put directly in the partition file. Instead it goes into the write ahead log and only later, during a checkpoint, gets written to the partition file(s). There’s really no reason to look directly inside the partition files. > On 17 Jan

Re: SqlQuery deprecated

Yes. ignite-dataframe > On 17 Jan 2022, at 13:31, capitnfrak...@free.fr wrote: > > Can Ignite support the spark like dataframe API? Thanks > > On 17/01/2022 20:31, Pavel Tupitsyn wrote: >> Hi,

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 to >

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 2.9 or

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 Person";

Re: Reading partition file in work/db

Hi Stephen, I was trying to verify how data is stored in partitions. Though i verified by running local scan query on each node, i was wondering if we can open partition files like we can read kafka partitions. On Mon, Jan 17, 2022, 16:24 Stephen Darlington < stephen.darling...@gridgain.com>

Re: i need sql syntax for CASEWHEN with multiple conditions

Not tested, but something like: CASEWHEN (condition1, ’New’, CASEWHEN(condition2, ‘Average’, CASEWHEN (condition3, ‘Old’, ‘Old))) It’s just an if/then statement, so you need to nest. > On 17 Jan 2022, at 10:09, Karthik Nandagiri > wrote: > > Thank you Stephen, I have already read this

Re: Reading partition file in work/db

What’s the use case for reading the data inside the partition files? > On 17 Jan 2022, at 10:16, Surinder Mehra wrote: > > I still havent found a way to read partition files. Not sure if we can > > 2nd: i created sample application to test it. I was able to see records > colocated as per

Re: Reading partition file in work/db

I still havent found a way to read partition files. Not sure if we can 2nd: i created sample application to test it. I was able to see records colocated as per "companyid/dept" combination. On Fri, Jan 14, 2022, 22:54 Surinder Mehra wrote: > Team, > Please reply > > On Thu, Jan 13, 2022,

Re: i need sql syntax for CASEWHEN with multiple conditions

Thank you Stephen, I have already read this document link. But it does not explain the syntax for multiple when conditions. Like below SELECT somecolumn,CASE WHEN condition1 THEN 'New' WHEN condition2 THEN 'Average' WHEN condition3 1990 THEN 'Old' ELSE 'Old' END AS condition

Re: i need sql syntax for CASEWHEN with multiple conditions

Different syntax, but it looks like the CASEWHEN function should do what you need: https://ignite.apache.org/docs/latest/sql-reference/system-functions#casewhen > On 17 Jan 2022, at 07:58, Karthik Nandagiri > wrote: > > Hi Team, > > I want to write below SQL with Ignite SQL case. > >

Re: h2 vulnerabilities

2.12 just came out, so the earliest would be 2.13. I’m sure a pull request would be welcomed if you want to take a look yourself. > On 17 Jan 2022, at 01:29, Lo, Marcus wrote: > > Thanks. Is there any timeline when this ticket would be picked up and fixed? > Thanks. > > Regards, > Marcus >