cancel
Showing results for 
Search instead for 
Did you mean: 

How to query partition tables

Former Member
0 Kudos

SAP-HANA have 3 partition schemes – Range, Hash and Roundrobin.

For range partition, I could use the Meta info for particular partition and can form multiple select queries to get data from particular partition.

Say, temp table have 2 partitions

1 – 1 <= VALUES < 10

2 – 10 <= VALUES < 20

Then select query could be

Select * from <table> where <col A> < 10 and <col A> >= 1;

Likewise, I tried to get the information for HASH and Round robin partition, but the meta data don’t give me any hash function information.

Here is what I got for HASH partition:

select table_name, IS_COLUMN_TABLE, PARTITION_SPEC from TABLES where TABLE_NAME='MYTABSB'

TABLE_NAME,IS_COLUMN_TABLE,PARTITION_SPEC

"MYTABSB","TRUE","HASH 4 A,B"

For Roundrobin partition:

select table_name, IS_COLUMN_TABLE, PARTITION_SPEC from TABLES where TABLE_NAME='MYTABSB1RR'

TABLE_NAME,IS_COLUMN_TABLE,PARTITION_SPEC

"MYTABSB1RR","TRUE","ROUNDROBIN 4"

Can you please let me know how could I get hash function and roundrobin information which I could use to select data from different partitions ?

Also, if there is any other way to get data from particular partition please let me know.


Accepted Solutions (0)

Answers (2)

Answers (2)

lbreddemann
Active Contributor
0 Kudos

Hi there,

requesting data from specific partitions is not supported.

What's the use case here?

When you choose HASH/ROUNDROBIN you decided upfront that you don't care how the data gets distributed.

Why would it be better for you to tell HANA what partition to look at, instead of having HANA do it automatically for you?

- Lars

former_member289103
Active Participant
0 Kudos

Hi Archana,

You can query on the table M_CS_PARTITIONS for more partition information.

Thanks and Regards,

Dharshan A