Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Wed, 17 Dec 2014 17:27:14 +0000 (UTC)
From: "Sergey Shelukhin (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12760904.1418261027000.46675.1418837234242@Atlassian.JIRA>
In-Reply-To: <JIRA.12760904.1418261027000@Atlassian.JIRA>
References: <JIRA.12760904.1418261027000@Atlassian.JIRA>
 <JIRA.12760904.1418261027286@arcas>
Subject: [jira] [Commented] (HIVE-9074) add ability to force direct sql
 usage for perf reasons
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/HIVE-9074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14250161#comment-14250161 ] 

Sergey Shelukhin commented on HIVE-9074:
----------------------------------------

[~ashutoshc] can you review? Thanks

> add ability to force direct sql usage for perf reasons
> ------------------------------------------------------
>
>                 Key: HIVE-9074
>                 URL: https://issues.apache.org/jira/browse/HIVE-9074
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Sergey Shelukhin
>         Attachments: HIVE-9074.patch
>
>
> 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.


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)