Re: interactive shell

2022-01-18 Thread Ilya Korol
Hi. What about sqlline that is available out of the box? Is it not enough for you? 18.01.2022 17:57, Adriel Peng пишет: Hi Can Ignite have an interactive shell (like pyspark) for SQL similar operations in the future version? Thanks

Re: interactive shell

2022-01-18 Thread Stephen Darlington
If you’re using Java 11, you can use jshell for anything you can’t do using SQL. Best to use the thin client and just make sure ignite-core*jar and cache-api-*.jar are in your class path. > On 18 Jan 2022, at 09:06, Ilya Korol wrote: > > Hi. What about sqlline that is available out of the box?

SELECT FOR UPDATE and UPSERT semantics

2022-01-18 Thread Rob Shepherd
Hi, In our current RDMS-based solution we rely on a couple of SQL routines based on SELECT for UPDATE and UPSERT statements that allow us to find and modify some rows to be updated in-place (based on the select criteria) and to insert some rows if they don't exist. I appreciate these aren't avail