[HIVE-9074] add ability to force direct sql usage for perf reasons

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Sergey Shelukhin
• Created: 11/Dec/14 01:23
• Updated: 17/Dec/14 19:27

Description

Some people run direct SQL and hit failures (e.g. due to Oracle 1000-in-expressions stupidity, illegal cast "optimization" in Derby and Oracle, or some other Hive and DB bugs). Currently, it falls back to ORM for such cases, however that can have huge impact on perf, and some people would rather have it fail so they can see the problem.
In addition to "off" and "on+fallback" modes, "on or fail" mode needs to be added. The default will remain the same.