Sign in
◑
Theme
apache
/
hive
/
refs/heads/HiveAggregateReduceFunctionsRule
/
.
/
ql
/
src
/
test
/
queries
/
clientnegative
/
subquery_select_distinct2.q
blob: 060dd3a116110bbefc30f8b5b22705f2ad699d9a [
file
]
--!
qt
:
dataset
:
part
--
subqueries
in
UDFs
are
not
allowed
explain SELECT distinct p_size
,
(
SELECT max
(
p_size
)
FROM part p WHERE p
.
p_type
=
part
.
p_type
)
from
part
;