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

Zheng Shao commented on HIVE-352:
---------------------------------

Nice work Yongqiang!

I totally agree with your analysis of the NONBULK mode - I was thinking of 
caching all compressed data in memory.

The good thing about NONBULK is that we might be able to bypass the column 
hinting - because we might be able to omit the disk read cost since the 
decompression cost usually takes much more time.

Can you add a simple option to your code so that I can easily test out whether 
that's true? Basically, I want to compare the difference of reading and 
decompressing 1 column (while skipping all other columns), and reading all 
columns (while decompressing only 1 column). If the difference is small, then 
we can implement NONBULK, and skip the column hinting implementation for now.

What do you think?


> Make Hive support column based storage
> --------------------------------------
>
>                 Key: HIVE-352
>                 URL: https://issues.apache.org/jira/browse/HIVE-352
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>            Assignee: He Yongqiang
>         Attachments: 4-22 performace2.txt, 4-22 performance.txt, 4-22 
> progress.txt, hive-352-2009-4-15.patch, hive-352-2009-4-16.patch, 
> hive-352-2009-4-17.patch, hive-352-2009-4-19.patch, 
> hive-352-2009-4-22-2.patch, hive-352-2009-4-22.patch, 
> hive-352-2009-4-23.patch, hive-352-2009-4-27.patch, 
> HIve-352-draft-2009-03-28.patch, Hive-352-draft-2009-03-30.patch
>
>
> column based storage has been proven a better storage layout for OLAP. 
> Hive does a great job on raw row oriented storage. In this issue, we will 
> enhance hive to support column based storage. 
> Acctually we have done some work on column based storage on top of hdfs, i 
> think it will need some review and refactoring to port it to Hive.
> Any thoughts?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to