Re: Issue in Distributed joins

[DS]

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

[DS]

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 new password.

3) Again tried with 'ignite' as password, it connects back.




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

[DS]

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");
 Ignition.startClient(ClientCfg)

It throws an exception >
SEVERE: The user name or password is incorrect [userName=ignite]





--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

[DS]

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 WITH
PASSWORD 'test'")).getAll()
}catch {...}

Using java thin client I am able to connect the server with default username
= 'ignite' and password = 'ignite'.

 if I try to change the password via above  Alter query, 
it throws me this error :

org.apache.ignite.internal.client.thin.ClientServerError: Ignite failed to
process request [1]: Operation failed
[nodeId=f0f0660d-3063-4a66-a25c-c8ca44d06cd2,
opId=c21a59ad071-98068f3f-df17-4b3e-9222-e747fc738ccf, err=class
org.apache.ignite.internal.processors.authentication.UserManagementException:
User doesn't exist [userName=IGNITE]] (server status code [1])










--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Issue in Distributed joins

[DS]

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

[DS]

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
  



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Issue in Distributed joins

[DS]

Hello Ilya,
Sure I'll do that


Regards 
Deepika 



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Issue in Distributed joins

[DS]

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

[DS]

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?

[DS]

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-users.70518.x6.nabble.com/

Duplicate column name while creating table

[DS]

*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
VARCHAR(100),  AGE INTEGER (64));




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Does Ignite support nested joins for partitioned cache?

[DS]

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?

[DS]

Hi, 
Thankyou for replying.

*cache configration for all 4 tables :
* SQL_PUBLIC_PERSON.SQL_PUBLIC_PERSON

  
SQL_PUBLIC_CITY.SQL_PUBLIC_CITY

  
SQL_PUBLIC_MEDICAL_INFO.SQL_PUBLIC_MEDICAL_INFO

  
SQL_PUBLIC_BLOOD_GROUP_INFO.SQL_PUBLIC_BLOOD_GROUP_INFO

  


*Expecting result :
*I am expecting 7 rows but only getting 4 .
Also,data for column blood_group and universal_donor is missing.

*Below are the screenshots and cache_configration of all 4 tables and the
query result .
*
*Table :person
*
 

*Table :city 
*
 

*Table :medical_info
*

 

*Table: blood_group_info
*

 

*Result of join query : 
*
 






--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Does Ignite support nested joins for partitioned cache?

[DS]

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.

Please let me know if i am doing something wrong with query below:

SELECT
_medical_info.age,_medical_info.name,_medical_info.city_id,_medical_info.weight,_medical_info.blood_group,blood_group_info.universal_donor
 
FROM 
   ( SELECT
_person.age,_person.name,_person.city_id,medical_info.blood_group,medical_info.weight
 
FROM (
SELECT person.age,person.name,city.city_id 
FROM person 
LEFT JOIN  city ON person.city_id = city.city_id
) AS _person 
LEFT JOIN  medical_info ON _person.name = medical_info.name 
) AS _medical_info  
LEFT JOIN  blood_group_info ON _medical_info.blood_group =
blood_group_info.blood_group 


 



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

IgniteSQLException

[DS]

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 string for the sql statusCode.
But i am getting statusCode :1001 (parsing error ) for both wrong SQL syntax 
and table does not exist(3001). 

P.S
I am trying to understand how SQL error works. and how to caputure precise
string for particular statusCode.
eg :

CACHE_NOT_FOUND 4006
COLUMN_ALREADY_EXISTS   3009




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Does ignite support FULL OUTER JOIN ?

[DS]

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.70518.x6.nabble.com/

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

[DS]

Denis Mekhanikov wrote
> Is it a single query? Why not execute these two updates separately?
> I don't see any problems in the first one.
> 
> The second one needs some refactoring though.
> Ignite uses an SQL query engine of H2, which doesn't support JOINs in
> UPDATE 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 

> deepika.singh@

> :
> 
>> 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.nabble.com/
>>

 Query i ran  over GridGain :

UPDATE personalDetails SET personalDetails.age = 26
WHERE EXISTS (SELECT * FROM cityDEtails WHERE
 cityDEtails.id=personalDetails.F_id AND cityDEtails.pincode = 560102)

It ran but didn't update the value ?? .

any idea why?






--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

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

[DS]

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.nabble.com/