Re: Issue in Distributed joins

Hello, Any update on this from SQL people? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

igniteClient.query(new SqlFieldsQuery(" ALTER USER 'ignite' WITH PASSWORD 'password' ")); igniteClient.query(new SqlFieldsQuery(" ALTER USER "ignite'' WITH PASSWORD 'password' ")); 1) Both give the same result. i.e query runs without throwing any error/exception. 2) Unable to connect with the

Re: HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

Hello, The below query ran without throwing any error. : igniteClient.query(new SqlFieldsQuery("ALTER USER \"ignite\" WITH PASSWORD 'password'")); But when I am trying to connect with new password i.e. ClientCfg.setUserName("ignite"); ClientCfg.setUserPassword("password");

HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

ClientConfiguration cfg = new ClientConfiguration() .setAddresses("127.0.0.1:10800") .setUserName("ignite") .setUserPassword("ignite"); try (IgniteClient igniteClient = Ignition.startClient(ClientCfg)) { igniteClient.query(new SqlFieldsQuery("ALTER USER IGNITE WI

Re: Issue in Distributed joins

Hello again! Having one table as replicated and other as partitioned works already. Can you please file a defect for why nested joins are not working in the distributed mode as claimed. Regards Deepika Singh -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Issue in Distributed joins

Hello Ilya, Please find the script in the attachment. The file also contains the query to run in comments. Also, *we have enabled non-collocated joins check. * forDistributedJoins.sql Regards Deepika Singh

Re: Issue in Distributed joins

Hello Ilya, Sure I'll do that Regards Deepika -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Issue in Distributed joins

Hello, I'll appreciate, if you can find time to look into the issue. Regards -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Issue in Distributed joins

Hi, Kindly follow the PDF to track the observations made on distributed joins. Issue_with_Distributed_joins.pdf Regards Deepika -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Does Ignite support nested joins for partitioned cache?

Hi,Its really important for me to undersatnd whats going wrong here with joins. Its kind of big blocker for me. I am not getting the correct data when joining more than 3 tables (picture 4 in above attachments ). Any help will be much appericiated. Thanx -- Sent from: http://apache-ignite-

Duplicate column name while creating table

*I am able to create the table with duplicate column name.* I was expecting some error saying "cannot create table; duplicate column name: NAME" Is there some reason that Ignite is not throwing error/exception OR is it a bug? CREATE TABLE Person(ID INTEGER PRIMARY KEY, NAME VARCHAR(100), NAME

Re: Does Ignite support nested joins for partitioned cache?

Hi,any update on the issue ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Does Ignite support nested joins for partitioned cache?

Hi, Thankyou for replying. *cache configration for all 4 tables : * SQL_PUBLIC_PERSON.SQL_PUBLIC_PERSON SQL_PUBLIC_CITY.SQL_PUBLIC_CITY

Does Ignite support nested joins for partitioned cache?

I have been trying to implement nested joins with or without subquery but unable get right results. My caches are partitioned ,so enabling Allow non-collocated joins check. P.S. It has been observed that if i am tyring to join 3 tables,i get expected result but for more than 3 tables worries me.

IgniteSQLException

catch (Exception e) { ///System.out.println(superCache.err); if (e instanceof CacheException) { IgniteSQLException sqLEx = X.cause(e, IgniteSQLException.class); System.out.println("> statusCode " + sqLEx.statusCode()); } I am trying to fetch the exact stri

Does ignite support FULL OUTER JOIN ?

I am giving the syntax as : SELECT * FROM person Outer join city ON person.city_id = city.city_id Same query works well with inner ,left ,right join . Please correct me if i am doing something wrong. P.S. Both tables have index over city_id column -- Sent from: http://apache-ignite-users

Re: Is Apache planning to release support for table joins with updates .

TE statements. > But you may change it in the following way: > > UPDATE table1 SET table1.quantity = 6 WHERE EXISTS > > (SELECT * FROM table2 WHERE table2.pid=table1.pid AND table2.zip > ='abc') > ; > > > Denis > > чт, 27 дек. 2018 г. в 12:49, DS

Is Apache planning to release support for table joins with updates .

I am looking solution for queries like below : Update Person SET lastName ='pit' where person.id =city.id AND city.zipCode ='B8Q97' OR UPDATE table1, table2 SET table1.quantity = 6 where table1.pid =table2.pid AND table2.zip ="abc" -- Sent from: http://apache-ignite-users.70518.x6.nab