Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
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
`;