[
https://issues.apache.org/jira/browse/IGNITE-16243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
YuJue Li resolved IGNITE-16243.
-------------------------------
Fix Version/s: (was: 2.13)
Resolution: Not A Problem
> 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
> Priority: Critical
>
> 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)
