Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution

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

New 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

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

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

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

New 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.

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

Expert Contributor

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