[jira] [Comment Edited] (HIVE-19772) Streaming ingest V2 API can generate invalid orc file if interrupted

["Prasanth Jayachandran (JIRA)" <ji...@apache.org>]

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

Prasanth Jayachandran edited comment on HIVE-19772 at 6/5/18 5:08 PM:
----------------------------------------------------------------------

With this .2 patch, I am able to hit ~40-45 million rows/minute (64 threads writing to 64 static partitions each committing after 100000 rows) using the test app [https://github.com/prasanthj/culvert/]
{code:java}
./culvert -u thrift://localhost:9183 -db prasanth -table culvert -p 64 -n 100000
hive> select count(*) from culvert;
OK
44700000
Time taken: 0.26 seconds, Fetched: 1 row(s)
{code}
The destination table schema is (from [https://yahooeng.tumblr.com/post/135321837876/benchmarking-streaming-computation-engines-at])
{code:java}
create table if not exists culvert (
user_id string,
page_id string,
ad_id string,
ad_type string,
event_type string,
event_time string,
ip_address string)
partitioned by (year int, month int)
stored as orc
tblproperties("transactional"="true");
{code}


was (Author: prasanth_j):
With this .2 patch, I am able to hit ~40-45 million rows/sec (64 threads writing to 64 static partitions each committing after 100000 rows) using the test app [https://github.com/prasanthj/culvert/]
{code:java}
./culvert -u thrift://localhost:9183 -db prasanth -table culvert -p 64 -n 100000
hive> select count(*) from culvert;
OK
44700000
Time taken: 0.26 seconds, Fetched: 1 row(s)
{code}
The destination table schema is (from [https://yahooeng.tumblr.com/post/135321837876/benchmarking-streaming-computation-engines-at])
{code:java}
create table if not exists culvert (
user_id string,
page_id string,
ad_id string,
ad_type string,
event_type string,
event_time string,
ip_address string)
partitioned by (year int, month int)
stored as orc
tblproperties("transactional"="true");
{code}

> Streaming ingest V2 API can generate invalid orc file if interrupted
> --------------------------------------------------------------------
>
>                 Key: HIVE-19772
>                 URL: https://issues.apache.org/jira/browse/HIVE-19772
>             Project: Hive
>          Issue Type: Bug
>          Components: Transactions
>    Affects Versions: 3.1.0, 3.0.1, 4.0.0
>            Reporter: Gopal V
>            Assignee: Prasanth Jayachandran
>            Priority: Critical
>         Attachments: HIVE-19772.1.patch, HIVE-19772.2.patch
>
>
> Hive streaming ingest generated 0 length and 3 byte files which are invalid orc files. This will throw the following exception during compaction
> {code}
> Error: org.apache.orc.FileFormatException: Not a valid ORC file hdfs://cn105-10.l42scl.hortonworks.com:8020/apps/hive/warehouse/culvert/year=2018/month=7/delta_0000025_0000025/bucket_00005 (maxFileLength= 3) at org.apache.orc.impl.ReaderImpl.extractFileTail(ReaderImpl.java:546) at org.apache.orc.impl.ReaderImpl.<init>(ReaderImpl.java:370) at org.apache.hadoop.hive.ql.io.orc.ReaderImpl.<init>(ReaderImpl.java:60) at org.apache.hadoop.hive.ql.io.orc.OrcFile.createReader(OrcFile.java:90) at org.apache.hadoop.hive.ql.io.orc.OrcRawRecordMerger.<init>(OrcRawRecordMerger.java:1124) at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.getRawReader(OrcInputFormat.java:2373) at org.apache.hadoop.hive.ql.txn.compactor.CompactorMR$CompactorMap.map(CompactorMR.java:1000) at org.apache.hadoop.hive.ql.txn.compactor.CompactorMR$CompactorMap.map(CompactorMR.java:977) at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54) at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:460) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:344) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:174) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1965) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:168)
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)