Sign in
apache
/
hive
/
6b095edc31a9baa0ae805e2b5aea88101284d84b
/
.
/
ql
/
src
/
test
/
queries
/
clientpositive
/
cbo_join_transitive_pred_loop.q
blob: ce70a9d472c5ab19d5272b53548a75b0dddf2bea [
file
] [
log
] [
blame
]
CREATE TABLE A
(
`value_date`
date
)
STORED AS ORC
;
CREATE TABLE B
(
`business_date`
date
)
STORED AS ORC
;
EXPLAIN SELECT A
.
VALUE_DATE
FROM A
,
B
WHERE A
.
VALUE_DATE
=
BUSINESS_DATE
AND A
.
VALUE_DATE
=
TRUNC
(
BUSINESS_DATE
,
'MONTH'
);