You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@knox.apache.org by "Kevin Risden (JIRA)" <ji...@apache.org> on 2018/11/02 18:48:00 UTC

[jira] [Commented] (KNOX-1524) Hive "select *" performance evaluation

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

Kevin Risden commented on KNOX-1524:
------------------------------------

I refactored the performance tests to make them repeatable. Still needs some docs but basically "./setup.sh" and then "docker-compose run --rm test-hive" for manual tests. 

[https://github.com/risdenk/knox-performance-tests]

> Hive "select *" performance evaluation
> --------------------------------------
>
>                 Key: KNOX-1524
>                 URL: https://issues.apache.org/jira/browse/KNOX-1524
>             Project: Apache Knox
>          Issue Type: Task
>            Reporter: Kevin Risden
>            Assignee: Kevin Risden
>            Priority: Major
>             Fix For: 1.2.0
>
>
> While looking at WebHDFS performance in KNOX-1221, I decided to look a bit more into performance for common use cases. Hive performance is another area that could use some research.
> Use "select * ... limit" to get a comparison of raw return speed from HiveServer2. This should show how fast results can be streamed through HiveServer2 and Knox. Compare the results to "hdfs dfs -text" since this will render the data directly from HDFS. This should give comparisons for the difference in overhead between HDFS, HiveServer2 binary, HiveServer2 HTTP, and HiveServer2 HTTP with Knox.



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