You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Konstantinov (JIRA)" <ji...@apache.org> on 2018/03/13 04:18:00 UTC
[jira] [Updated] (IGNITE-7927) Web console: failed to execute query
in demo
[ https://issues.apache.org/jira/browse/IGNITE-7927?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Konstantinov updated IGNITE-7927:
---------------------------------------
Description:
If I set 'Allow non-collocated joins' option for demo query
{code}
SELECT p.name, count(*) AS cnt
FROM "ParkingCache".Parking p
INNER JOIN "CarCache".Car c
ON (p.id) = (c.parkingId)
GROUP BY P.NAME
{code}
then I got the following error
{code}
Error: Failed to prepare distributed join query: join condition does not use index [joinedCache=CarCache, plan=SELECT P__Z0.NAME AS __C0_0, COUNT(*) AS __C0_1 FROM "ParkingCache".PARKING P__Z0 /* "ParkingCache".PARKING.__SCAN_ */ INNER JOIN "CarCache".CAR C__Z1 /* batched:broadcast "CarCache".CAR.__SCAN_ */ ON 1=1 WHERE P__Z0.ID = C__Z1.PARKINGID GROUP BY P__Z0.NAME]
{code}
Please add necessary indices
was:
If I set 'Allow non-collocated joins' then I got the following error
{code}
Error: Failed to prepare distributed join query: join condition does not use index [joinedCache=CarCache, plan=SELECT P__Z0.NAME AS __C0_0, COUNT(*) AS __C0_1 FROM "ParkingCache".PARKING P__Z0 /* "ParkingCache".PARKING.__SCAN_ */ INNER JOIN "CarCache".CAR C__Z1 /* batched:broadcast "CarCache".CAR.__SCAN_ */ ON 1=1 WHERE P__Z0.ID = C__Z1.PARKINGID GROUP BY P__Z0.NAME]
{code}
Please add necessary indices
> Web console: failed to execute query in demo
> --------------------------------------------
>
> Key: IGNITE-7927
> URL: https://issues.apache.org/jira/browse/IGNITE-7927
> Project: Ignite
> Issue Type: Bug
> Reporter: Pavel Konstantinov
> Priority: Major
>
> If I set 'Allow non-collocated joins' option for demo query
> {code}
> SELECT p.name, count(*) AS cnt
> FROM "ParkingCache".Parking p
> INNER JOIN "CarCache".Car c
> ON (p.id) = (c.parkingId)
> GROUP BY P.NAME
> {code}
> then I got the following error
> {code}
> Error: Failed to prepare distributed join query: join condition does not use index [joinedCache=CarCache, plan=SELECT P__Z0.NAME AS __C0_0, COUNT(*) AS __C0_1 FROM "ParkingCache".PARKING P__Z0 /* "ParkingCache".PARKING.__SCAN_ */ INNER JOIN "CarCache".CAR C__Z1 /* batched:broadcast "CarCache".CAR.__SCAN_ */ ON 1=1 WHERE P__Z0.ID = C__Z1.PARKINGID GROUP BY P__Z0.NAME]
> {code}
> Please add necessary indices
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)