[jira] [Created] (IGNITE-16243) HASH_JOIN: Index "HASH_JOIN_IDX" not found

[YuJue Li (Jira)]

YuJue Li created IGNITE-16243:
---------------------------------

             Summary: HASH_JOIN: Index "HASH_JOIN_IDX" not found
                 Key: IGNITE-16243
                 URL: https://issues.apache.org/jira/browse/IGNITE-16243
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.11.1
            Reporter: YuJue Li
             Fix For: 2.13


Execute the following script and the error will occur:

CREATE TABLE Country (
  Code CHAR(3) PRIMARY KEY,
  Name VARCHAR,
  Continent VARCHAR,
  Region VARCHAR,
  SurfaceArea DECIMAL(10,2),
  IndepYear SMALLINT,
  Population INT,
  LifeExpectancy DECIMAL(3,1),
  GNP DECIMAL(10,2),
  GNPOld DECIMAL(10,2),
  LocalName VARCHAR,
  GovernmentForm VARCHAR,
  HeadOfState VARCHAR,
  Capital INT,
  Code2 CHAR(2)
) WITH "template=partitioned, backups=1, CACHE_NAME=Country, 
VALUE_TYPE=demo.model.Country";

CREATE TABLE City (
  ID INT,
  Name VARCHAR,
  CountryCode CHAR(3),
  District VARCHAR,
  Population INT,
  PRIMARY KEY (ID, CountryCode)
) WITH "template=partitioned, backups=1, CACHE_NAME=City, 
KEY_TYPE=demo.model.CityKey, VALUE_TYPE=demo.model.City";


CREATE INDEX idx_country_code ON city (CountryCode);

INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES 
(1,'Kabul','AFG','Kabol',1780000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES 
(2,'Qandahar','AFG','Qandahar',237500);

INSERT INTO Country(Code, Name, Continent, Region, SurfaceArea, IndepYear, 
Population, LifeExpectancy, GNP, GNPOld, LocalName, GovernmentForm, 
HeadOfState, Capital, Code2) VALUES ('AFG','Afghanistan','Asia','Southern and 
Central 
Asia',652090.00,1919,22720000,45.9,5976.00,NULL,'Afganistan/Afqanestan','Islamic
 Emirate','Mohammad Omar',1,'AF');

SELECT *
FROM city,country USE INDEX(HASH_JOIN_IDX)
WHERE city.CountryCode = country.code;

see the doc:

[https://ignite.apache.org/docs/latest/SQL/distributed-joins#hash-joins]



--
This message was sent by Atlassian Jira
(v8.20.1#820001)