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.

Where can we find the SQL syntax reference for Atlas Metadata search?

Solved Go to solution

Where can we find the SQL syntax reference for Atlas Metadata search?

Contributor

Atlas UI allows us to search for entities with SQL like syntax, for example 'table where name = "sales_fact"'. Is this SQL framework based on any existing libraries within Gremlin? Or was this custom built for Atlas?

Trying to understand if there is documentation on the proper SQL syntax for these searches?

Doc Reference: http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_data_governance/content/section_metadata_...

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Where can we find the SQL syntax reference for Atlas Metadata search?

4 REPLIES 4

Re: Where can we find the SQL syntax reference for Atlas Metadata search?

Re: Where can we find the SQL syntax reference for Atlas Metadata search?

New Contributor
Is this SQL framework based on any existing libraries within Gremlin? Or was this custom built for Atlas?

This is a custom syntax that translates to gremlin behind the scenes.

Trying to understand if there is documentation on the proper SQL syntax for these searches?

Search Syntax

Re: Where can we find the SQL syntax reference for Atlas Metadata search?

Expert Contributor

Instead of calling it SQL, we can put it as DSL (Domain Specific Language) of Atlas.When the DSL query has any syntax error and is not properly formed, Atlas considers it as a Full text search.

Most commonly used DSL examples are :

1) hive_db where name = 'default' (Selecting the database knowing the name of the database)

2) hive_table where name='default.table_1@cluster1' (Selecting the table knowing the name of the table)

3) hive_table where name='db2.tab4@cluster1' select owner,name,createTime,comment,tableType (selecting attributes of a table)

4) from hive_table where name='default.table_1@cluster1',columns (listing all the columns of the table)

5) hive_table where db.name = 'default' (listing all tables in the database )

Re: Where can we find the SQL syntax reference for Atlas Metadata search?

New Contributor