Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
semijoin
/
antiJoin13.sql
blob: a84c51b2e3781efcd0cac2081700f86a877f1f6e [
file
] [
log
] [
blame
]
set
`
planner
.
enable_semijoin
`
=
true
;
select
orders
.
o_totalprice
from
orders
where
orders
.
o_custkey
not
in
(
select
customer
.
c_custkey
from
customer
)
order
by
orders
.
o_totalprice limit
10
;
reset
`
planner
.
enable_semijoin
`;