ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vasiliy Sisko (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (IGNITE-7927) Web console: failed to execute query in demo
Date Tue, 13 Mar 2018 04:18:00 GMT

     [ https://issues.apache.org/jira/browse/IGNITE-7927?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Vasiliy Sisko reassigned IGNITE-7927:
-------------------------------------

    Assignee: Vasiliy Sisko

> 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
>            Assignee: Vasiliy Sisko
>            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)

Mime
View raw message