Partitioning in SAP HANA , Partitioning

Partitioning in SAP HANA , Partitioning

[@andyp2924]

Lot of "incorrect" knowledge shared in this video. Firstly limit is 2 billion records, not 2 TB. Partitioning is only available for tables located in the column store. The row store doesn't support partitioning.

[@vivekanandpandey8002]

Some one asked in vedio for System Limitation: Refer Docu : help.sap.com/doc/PRODUCTION/9b40bf74f8644b898fb07dabdd2a36ad/2.0.00/en-US/SAP_HANA_SQL_and_System_Views_Reference_en.pdf Page 719 There are some limitations to take into consideration when administering an SAP HANA database. most system limits can be viewed by querying the M_SYSTEM_LIMITS system view (SELECT * FROM M_SYSTEM_LIMITS;). However, your values might differ depending on the hardware and software configuration your system uses.

[@justlikeit42]

Hi, I am facing one issue. I created range partition table (with specified column and data like 1 flag 2 flag 3 flag ) and I am using that table in calculation view and also have parameters in that view Issue : when I pass three values in parameter (1flag , 2 flag , 3 flag ) greeting data in Mili secs - No issue When I pass two values in parameter ( 1flag , 2 flag ) That also preety fast - No issue But When I pass one value in parameter ( 2flag ) that taking lot of time running, keep on running. - Issue While passing multiple values it's working fine but when pass one value it's taking lot of time. Any of you faced this kind of wierd issue ??

[@BVAswat]

Haven't faced this kind of issue may when u pass the only one flag try entering some null values for other parameters , if this doesnt work we can try to recreate the issue with some examples....

[@sakshijain8685]

content and explanation is superb. Keep up the good work Aswat.

[@spinebreaker7986]

Good Job explainin, your video helped a lot for me :)

[@VenkyP2450]

Good job for explaining in details. You show confidence and technical details how to teach strategically.

[@sagarndlknf9251]

Awesome explaination and demonstration👍🏻

[@cespurs]

I need to partition the TLOGF table, it already has many records. How can I do it ? and the TLOGF_X table, what is it for?

[@senthila7753]

Great!

[@amarnathchalla6509]

Good Job Sir

[@phani34suriya]

Hello aswat could u pls share the videos for money?

[@BVAswat]

Sorry u can download for free

[@shivaniinnegi]

Good explanation