You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@atlas.apache.org by "Abhishek Pal (Jira)" <ji...@apache.org> on 2023/05/12 13:27:00 UTC
[jira] [Updated] (ATLAS-4750) [Relationship Search] Relationship search isNull case doesn't consider null strings
[ https://issues.apache.org/jira/browse/ATLAS-4750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhishek Pal updated ATLAS-4750:
--------------------------------
Description:
Currently Atlas supports relationship search where we can search entities by their relationships.
We can use various filters to search for the relationship, where one such filter is a condition of "isNull".
If there are relationships where a string type attribute is set to *""* (null string), it considers this as non-null.
For example if there is are two relationships with attributes:
* relation_X
** "type_str": ""
* relation_Y
** "type_str": null
and we search by condition:
{code:java}
{
"attributeName": "type_str",
"operator": "isNull",
"attributeValue": ""
}
{code}
we get only *relation_Y*
Whereas since *relation_X* has
{panel}
"type_str":""
{panel}
it is not treated as a null value and hence not returned.
This is also the case forĀ {panel} "operator": "notNull" {panel} where we get the *relation_X*
Ideally this should also be considered a null type
was:
Currently Atlas supports relationship search where we can search entities by their relationships.
We can use various filters to search for the relationship, where one such filter is a condition of "isNull".
If there are relationships where a string type attribute is set to *""* (null string), it considers this as non-null.
For example if there is are two relationships with attributes:
* relation_X
** "type_str": ""
* relation_Y
** "type_str": null
and we search by condition:
{code}
{
"attributeName": "type_str",
"operator": "isNull",
"attributeValue": ""
}
{code}
we get only *relation_Y*
Whereas since *relation_X* has
{panel} "type_str":"" {panel}
it is not treated as a null value and hence not returned.
Ideally this should also be considered a null type
> [Relationship Search] Relationship search isNull case doesn't consider null strings
> -----------------------------------------------------------------------------------
>
> Key: ATLAS-4750
> URL: https://issues.apache.org/jira/browse/ATLAS-4750
> Project: Atlas
> Issue Type: Bug
> Components: atlas-core
> Reporter: Abhishek Pal
> Priority: Major
>
> Currently Atlas supports relationship search where we can search entities by their relationships.
> We can use various filters to search for the relationship, where one such filter is a condition of "isNull".
> If there are relationships where a string type attribute is set to *""* (null string), it considers this as non-null.
> For example if there is are two relationships with attributes:
> * relation_X
> ** "type_str": ""
> * relation_Y
> ** "type_str": null
> and we search by condition:
> {code:java}
> {
> "attributeName": "type_str",
> "operator": "isNull",
> "attributeValue": ""
> }
> {code}
> we get only *relation_Y*
> Whereas since *relation_X* has
> {panel}
> "type_str":""
> {panel}
> it is not treated as a null value and hence not returned.
> This is also the case forĀ {panel} "operator": "notNull" {panel} where we get the *relation_X*
> Ideally this should also be considered a null type
--
This message was sent by Atlassian Jira
(v8.20.10#820010)