Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Expert Contributor

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

1 ACCEPTED SOLUTION

avatar
Super Collaborator

@subash sharma

DSL query : hive_table where db.name="default" lists down all the hive tables in "default" database.

V1 Query which can be used in Atlas 0.7 :

/api/atlas/discovery/search/dsl?query=hive_table+where+db.name%3D%22default%22

View solution in original post

13 REPLIES 13

avatar
Expert Contributor

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

avatar
Expert Contributor

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()

avatar
Expert Contributor

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.

avatar
Super Collaborator

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