How to fetch total numbers of tables available in a Schema using Rest API search techniques ?

[#1]

How to get the list pf all the tables available in a particular schema. This Rest API command generally gives the GUID and total count of all tables available in Atlas.

http://hostname:port/api/atlas/entities?type=hive_table

Can we apply some sort of filter on database or schema ?

Thank you,

Subash

[#2]

Hey @Sharmadha Sainath,

I was not able to add comment so adding my reply here, actually i was using space instead of "=" in limit. It is working now. Thanks

[#3]

The following gremlin query can also be used the get the count of entity type:

• http://localhost:21000/api/atlas/discovery/search/gremlin?query=g.V("__typeName", "hive_db").count()
• http://localhost:21000/api/atlas/discovery/search/gremlin?query=g.V("__typeName", "hive_table").count()

[#4]

Thank you @Sarath Subramanian. Right now i am using DSL for searching the tables in a schema. Let me know which one should be good in terms of performance. Gremlin or DSL.

[#5]

@subash sharma , DSL query makes GREMLIN call internally to fetch results.