question Re: Where can we find the SQL syntax reference for Atlas Metadata search? in Archives of Support Questions (Read Only)

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

wfloyd — Wed, 07 Oct 2015 20:13:36 GMT

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_store_mgmt_with_atlas_ui.html

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

vzlatkin — Wed, 07 Oct 2015 20:52:48 GMT

These two links should help you get started. Docs: http://atlas.incubator.apache.org/Search.html

Query parser code: https://github.com/hortonworks/atlas/blob/2.3-maint/repository/src/main/scala/org/apache/atlas/query/QueryParser.scala

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

venkatesh1 — Fri, 23 Oct 2015 01:14:13 GMT

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?

ssainath — Thu, 10 Mar 2016 01:49:51 GMT

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?

andrew_sears — Wed, 16 Mar 2016 03:23:09 GMT

Updating link above.

https://github.com/apache/incubator-atlas/blob/master/repository/src/main/scala/org/apache/atlas/query/QueryParser.scala