4

managed table vs external table

in above link they mentioned

"Only the RELY constraint is allowed on external tables."

But no info that what is RELY constraint. Can somebody help me to understand what is Only the "RELY constraint". thanks in advance.

Community
  • 1
  • 1
Pala
  • 2,011
  • 3
  • 15
  • 17

1 Answers1

2

CBO is expected to take into account constraint, trust it if it is defined with RELY option. CBO may produce better plan and eliminate unnecessary joins.
See also Jira HIVE-13350

leftjoin
  • 36,950
  • 8
  • 57
  • 116