on 03-20-2013 8:49 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Archana,
You can query on the table M_CS_PARTITIONS for more partition information.
Thanks and Regards,
Dharshan A
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.