Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Sun, 10 Nov 2013 16:48:17 +0000 (UTC)
From: "Ashutosh Chauhan (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12675308.1382553390273.48617.1384102097165@arcas>
In-Reply-To: <JIRA.12675308.1382553390273@arcas>
References: <JIRA.12675308.1382553390273@arcas>
Subject: [jira] [Resolved] (HIVE-5626) enable metastore direct SQL for
 drop/similar queries
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/HIVE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashutosh Chauhan resolved HIVE-5626.
------------------------------------

       Resolution: Fixed
    Fix Version/s: 0.13.0

Committed to trunk. Thanks, Sergey!

> enable metastore direct SQL for drop/similar queries
> ----------------------------------------------------
>
>                 Key: HIVE-5626
>                 URL: https://issues.apache.org/jira/browse/HIVE-5626
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Sergey Shelukhin
>            Assignee: Sergey Shelukhin
>            Priority: Minor
>             Fix For: 0.13.0
>
>         Attachments: HIVE-5626.01.patch, HIVE-5626.02.patch, HIVE-5626.patch
>
>
> Metastore direct SQL is currently disabled for any queries running inside external transaction (i.e. all modification queries, like dropping stuff).
> This was done to keep the strictly performance-optimization behavior when using Postgres, which unlike other RDBMS-es fails the tx on any syntax error; so, if direct SQL is broken there's no way to fall back. So, it is disabled for these cases.
> It is not as important because drop commands are rare, but we might want to address that. Either by some config setting or by making it work on non-postgres DBs.


--
This message was sent by Atlassian JIRA
(v6.1#6144)