Rahul Kurup created ATLAS-4825:
----------------------------------

             Summary: Some DSL/advanced queries using business metadata 
attribute don't work as expected
                 Key: ATLAS-4825
                 URL: https://issues.apache.org/jira/browse/ATLAS-4825
             Project: Atlas
          Issue Type: Bug
            Reporter: Rahul Kurup
         Attachments: dataset_3_dsl_screenshot.png, 
dataset_no_underscore_screenshot.png, dataset_underscore_dsl_screenshot.png

If we fire these queries(assuming data exists for valid results):

hive_table where qualifiedName like '*{*}dataset_3{*}*' and bm1.attr1 like '*' 
select bm1.attr1
hive_table where qualifiedName like '*{*}dataset_{*}*' and bm1.attr1 like '*' 
select bm1.attr1
hive_table where qualifiedName like '*{*}dataset{*}*' and bm1.attr1 like '*' 
select bm1.attr1

And if we compare the results of each query above, each query fetches more 
results than the previous query, which is expected behaviour.

However if we consider these queries:

hive_table where qualifiedName like '*{*}dataset_3{*}*' select bm1.attr1
hive_table where qualifiedName like '*{*}dataset_{*}*' select bm1.attr1
hive_table where qualifiedName like '*{*}dataset{*}*' select bm1.attr1

The results are unexpected. The last two queries should have fetched results, 
but only shows blank. Screenshots for the same have been attached below..

The difference noted between the first three and the last three queries was 
that the Business metadata attribute is not used in the last 3 queries in the 
where clause.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to