Skip to Content
author's profile photo Former Member
Former Member

Table Partitioning in HANA

Hi

We have a big table that we are loading to Hana every month during system refresh. It is taking lot of time to load as the table is very big and its not partitioned. Wanted to know few basic things before I start working on the Table Partitioning.

1. How do we check which Partition Specification is suitable for my Table ( Hash, Round Robin or Range ). Do I need to check with Developer as which option is correct.

2. Do I need to create the table in HANA before I do the replication with Partitions. If yes, can I copy the same table structure from our ECC system and create the table.

3. If I use Hash, I need to specify columns as partitioning columns. How do we find which columns we need to specify.

I have already gone through the SAP documents and your personnel responses would be appreciated.

Mahesh Shetty

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 13, 2015 at 12:00 AM

    Partition based on your development requirements. A simple way to go ahead is using range partition based on date, this would suit simple scenarios. You should partition the table before loading data into it.

    you can refer to the following link for some details.

    http://scn.sap.com/community/hana-in-memory/blog/2013/08/04/various-table-partitioning-options-in-sap-hana

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 12, 2015 at 05:21 PM

    Mahesh,

    Can you provide details on the usage of SAP HANA in your case? Is it a Datamart or BW on HANA scenario?

    For later scenario, please look at 2019973 - BW on HANA - Handling BIG data tables OSS note once.

    Srinivas K

    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.