5

How to find RECORD_COUNT of collection table . TABLE_TYPE = 'COLLECTION' in Hana...

 1 year ago
source link: https://answers.sap.com/questions/13742242/how-to-find-record-count-of-collection-table-table.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client
5 minutes ago

How to find RECORD_COUNT of collection table . TABLE_TYPE = 'COLLECTION' in Hana DB?

4 Views

Hi Team,

SELECT RECORD_COUNT FROM M_TABLES WHERE TABLE_TYPE = 'COLLECTION';

This always gives NULL.

we have many collection tables in a schema , where we store json objects in collection tables. we need to find the count of all json objects stored in a schema. is there any way.

At collection table level i get count by

SELECT count(*) FROM "my_Collecttion_table_name_1";--2 ROWS

SELECT count(*) FROM "my_Collecttion_table_name_2";--10 ROWS

SELECT count(*) FROM "my_Collecttion_table_name_3";--20 ROWS

I need to get 32 row count info at schema level. how can I get this ?

SELECT sum(RECORD_COUNT) FROM M_TABLES WHERE TABLE_TYPE = 'COLLECTION' and TABLE_NAME LIKE '%_name_%';

This always gives NULL.


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK