Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Thu, 12 Mar 2015 04:28:39 +0000 (UTC)
From: "Fanhong Li (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.12669392.1379566626000.71663.1426134519419@Atlassian.JIRA>
In-Reply-To: <JIRA.12669392.1379566626000@Atlassian.JIRA>
References: <JIRA.12669392.1379566626000@Atlassian.JIRA>
 <JIRA.12669392.1379566626172@arcas>
Subject: [jira] [Commented] (HIVE-5317) Implement insert, update, and delete
 in Hive with full ACID support
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/HIVE-5317?page=3Dcom.atlassian.=
jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D14358=
084#comment-14358084 ]=20

Fanhong Li commented on HIVE-5317:
----------------------------------

insert into table values() when UTF-8 character is not correct


insert into table test_acid partition(pt=3D'pt_2')
 values( 2, '=E4=B8=AD=E6=96=87_2' , 'city_2' )
 ;

hive> select *
 > from test_acid=20
 > ;
 OK
 2 -=EF=BF=BD_2 city_2 pt_2
 Time taken: 0.237 seconds, Fetched: 1 row(s)
 hive>=20

CREATE TABLE test_acid(id INT,=20
 name STRING,=20
 city STRING)=20
 PARTITIONED BY (pt STRING)
 clustered by (id) into 1 buckets
 stored as ORCFILE
 TBLPROPERTIES('transactional'=3D'true')
 ;


> Implement insert, update, and delete in Hive with full ACID support
> -------------------------------------------------------------------
>
>                 Key: HIVE-5317
>                 URL: https://issues.apache.org/jira/browse/HIVE-5317
>             Project: Hive
>          Issue Type: New Feature
>            Reporter: Owen O'Malley
>            Assignee: Owen O'Malley
>             Fix For: 0.14.0
>
>         Attachments: InsertUpdatesinHive.pdf
>
>
> Many customers want to be able to insert, update and delete rows from Hiv=
e tables with full ACID support. The use cases are varied, but the form of =
the queries that should be supported are:
> * INSERT INTO tbl SELECT =E2=80=A6
> * INSERT INTO tbl VALUES ...
> * UPDATE tbl SET =E2=80=A6 WHERE =E2=80=A6
> * DELETE FROM tbl WHERE =E2=80=A6
> * MERGE INTO tbl USING src ON =E2=80=A6 WHEN MATCHED THEN ... WHEN NOT MA=
TCHED THEN ...
> * SET TRANSACTION LEVEL =E2=80=A6
> * BEGIN/END TRANSACTION
> Use Cases
> * Once an hour, a set of inserts and updates (up to 500k rows) for variou=
s dimension tables (eg. customer, inventory, stores) needs to be processed.=
 The dimension tables have primary keys and are typically bucketed and sort=
ed on those keys.
> * Once a day a small set (up to 100k rows) of records need to be deleted =
for regulatory compliance.
> * Once an hour a log of transactions is exported from a RDBS and the fact=
 tables need to be updated (up to 1m rows)  to reflect the new data. The tr=
ansactions are a combination of inserts, updates, and deletes. The table is=
 partitioned and bucketed.


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