[
https://issues.apache.org/jira/browse/IGNITE-20255?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17780031#comment-17780031
]
Ignite TC Bot commented on IGNITE-20255:
----------------------------------------
{panel:title=Branch: [pull/10910/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/10910/head] Base: [master] : New Tests
(10)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests
10|https://ci2.ignite.apache.org/viewLog.html?buildId=7577623]]
* {color:#013220}IgniteCalciteTestSuite: JoinOrderHintsPlannerTest.testUnions -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinOrderHintsPlannerTest.testDisabledCommutingOfJoinInputsInSubquery -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite: JdbcQueryTest.testEnforcedJoinOrder -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinOrderHintsPlannerTest.testWrongParams - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinOrderHintsPlannerTest.testDisabledCommutingOfJoinInputs - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinOrderHintsPlannerTest.testJoinPlanBuildingDuration - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinOrderHintsPlannerTest.testDisabledLeftJoinTypeCommuting - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinOrderHintsPlannerTest.testDisabledJoinPushThroughJoinLeft - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinOrderHintsPlannerTest.testDisabledRightJoinTypeCommuting - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinOrderHintsPlannerTest.testDisabledJoinPushThroughJoinRight - PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=7577700&buildTypeId=IgniteTests24Java8_RunAll]
> Query join order SQL hint.
> --------------------------
>
> Key: IGNITE-20255
> URL: https://issues.apache.org/jira/browse/IGNITE-20255
> Project: Ignite
> Issue Type: Task
> Reporter: Vladimir Steshin
> Assignee: Vladimir Steshin
> Priority: Major
> Labels: important, ise
> Time Spent: 1h 50m
> Remaining Estimate: 0h
>
> For the join operations, we should have several SQL hints. Like join order or
> join type. One of them is the query join order hint. Oracle DB's analogy is
> 'ORDERED'. Looks simple, allows to keep join order. Also, can prevent long
> joins planning by Calcite.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
