blob: 1629efa144b6410482e08ef5d5b6d555791b3991 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
/* ytfile can not */
USE plato;
pragma warning("disable", "8001"); -- CBO_MISSING_TABLE_STATS
pragma CostBasedOptimizer="native";
pragma yt.MapJoinLimit="1000";
pragma yt.LookupJoinLimit="1000";
pragma yt.LookupJoinMaxRows="100";
pragma yt.ExtendedStatsMaxChunkCount="0";
pragma yt.JoinMergeTablesLimit="100";
SELECT
InputA.Key1, InputA.Key2, InputA.Value, InputB.val, InputC.v, InputD.value as vald
FROM
InputA
INNER JOIN InputD ON InputA.Key2 = InputD.k
INNER JOIN InputB ON InputA.Fk1 = InputB.k
INNER JOIN InputC ON InputA.Key1 = InputC.k
|
