hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <>
Subject [jira] [Commented] (HIVE-5626) enable metastore direct SQL for drop/similar queries
Date Fri, 08 Nov 2013 18:48:17 GMT


Sergey Shelukhin commented on HIVE-5626:

all the .q tests are ran with verifying object store which runs SQL and JDO and compares.
Separate test - what do you mean?

> enable metastore direct SQL for drop/similar queries
> ----------------------------------------------------
>                 Key: HIVE-5626
>                 URL:
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Sergey Shelukhin
>            Assignee: Sergey Shelukhin
>            Priority: Minor
>         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

View raw message