[
https://issues.apache.org/jira/browse/IGNITE-16243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17472664#comment-17472664
]
Ilya Korol commented on IGNITE-16243:
-------------------------------------
[~zstan] Looks like Ignite (at least master branch) doesn't have any code
related to hash join index implementation, do you know was this feature
implemented (is it possible that it was removed for some reason)?
> 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)
