Apache Atlas Advanced Search

[#1]

Hi All,

Requesting help in forming a query in Apache Atlas advanced search to select system attribute fields like __modificationTimestamp or __timestamp as datetime instead of bigint.

Thanks,

Midhun

[#2]

@MBKAU Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our Atlas experts @Scharan @BennyZ  who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

[#3]

@RolandoGarcia @mayank_gupta Any insights here? Thanks!

[#4]

you can create a query using the below doc - 

https://docs.cloudera.com/runtime/7.2.0/atlas-reference/topics/atlas-reference-search-language.html

[#5]

@mayank_gupta 
Thanks for the reference.

In the doc, there is syntax to use date literals in where condition and also, syntax to change output names using 'AS'

But, I could not find a query syntax to cast a column to a different datatype(e.g. bigint to date).

[#6]

@MBKAU Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks.