[IGNITE-7927] Web console: failed to execute query in demo

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.5
• Component/s: wizards
• Assignee: Pavel Konstantinov
• Reporter: Pavel Konstantinov
• Created: 13/Mar/18 04:16
• Updated: 11/May/18 04:55
• Resolved: 10/Apr/18 10:29

Description

If I set 'Allow non-collocated joins' option for demo query

SELECT p.name, count(*) AS cnt
FROM "ParkingCache".Parking p
INNER JOIN "CarCache".Car c
  ON (p.id) = (c.parkingId)
GROUP BY P.NAME

then I got the following error

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]

Please add necessary indices