Uploaded image for project: 'Apache Knox'
  1. Apache Knox
  2. KNOX-1524

Hive "select *" performance evaluation

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major
    • Resolution: Information Provided
    • Affects Version/s: None
    • Fix Version/s: 1.2.0
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                krisden Kevin Risden
                Reporter:
                krisden Kevin Risden
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: