Prasanth Jayachandran created HIVE-20165:
--------------------------------------------

             Summary: Enable ZLIB for streaming ingest
                 Key: HIVE-20165
                 URL: https://issues.apache.org/jira/browse/HIVE-20165
             Project: Hive
          Issue Type: Bug
          Components: Streaming, Transactions
    Affects Versions: 4.0.0, 3.2.0
            Reporter: Prasanth Jayachandran
            Assignee: Prasanth Jayachandran


Per [~gopalv]'s recommendation tried running streaming ingest with and without 
zlib. Following are the numbers

 
*Compression: NONE*
Total rows committed: 93800000
Throughput: *1563333* rows/second
[prasanth@cn105-10 culvert]$ hdfs dfs -du -s -h 
/apps/hive/warehouse/prasanth.db/culvert
*14.1 G*  /apps/hive/warehouse/prasanth.db/culvert
 
*Compression: ZLIB*
Total rows committed: 92100000
Throughput: *1535000* rows/second
[prasanth@cn105-10 culvert]$ hdfs dfs -du -s -h 
/apps/hive/warehouse/prasanth.db/culvert
*7.4 G*  /apps/hive/warehouse/prasanth.db/culvert
 
ZLIB is getting us 2x compression and only 2% lesser throughput. We should 
enable ZLIB by default for streaming ingest. 



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

Reply via email to