Skip to Content

How Hana Integrates large size partitioned table data?

I have this question in my mind and thought of asking it , so i searched but couldn't find if any one has answered it.

Here is scenario : I have scale out HANA system with 3 hosts , one is master and other is slave. I have one large size table which is partitioned across these 3 hosts (partioning method is irrelevant here), my question is : if i query onto this 3 partitions, assume here that required portion of data is spread across all hosts, does HANA use map reduce type functions to integrate the data , if yes where integration happens? is it in master node?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Oct 21, 2016 at 08:31 AM

    Depending on the statement routing setup, the query will be mainly executed on the node to which the session is connected or where the majority of the data is located.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 21, 2016 at 10:19 AM

    Thanks for reply Lars , what about consolidation of data, will the transfer will happen from other nodes to node where connection is connected.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 23, 2016 at 12:21 AM

    Well, obviously at least the result needs to be handed back to the client. How much of the stored base data actually gets transferred depends on the model, the query and the data.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.