How to get distinct nodes

siva · December 26, 2018, 3:06am

Hi
How to get distinct nodes

i have a flow like this

uid A B C D
orangegroup → Country -state-> State -district-> District -city-> City
uid C D
greengroup → District -city-> City

from above two groups when we combined need only distinct nodes

        uid              A ->B ->C ->D
 (orangegroup,greengroup)  -> Country  -state->  State -district-> District     -city->       City

I have tried using variable ,but duplicate results comming

MichelDiz · December 26, 2018, 2:38pm

Through your example I can not get a sense of the problem. I can imagine several things,
but not something concrete. Could you generate a small example in JSON obj?
and tell which Queries you are using.

Just a little bit of context to help us to help you.

Cheers.

siva · December 26, 2018, 4:42pm

Hi

Following is the mutation set

 #Group Meta Data
    _:orangegroup <Name> "Orange" .
	_:orangegroup <Type> "Group" .
	
    _:greengroup <Name> "Green" .
	_:greengroup <Type> "Group" .
	
	_:District <Name> "Ind" .
	_:District <Type> "District" .
	
  _:Area <Name> "TS" .
	_:Area <Type> "Area" .
	
	_:Field <Name> "Hyd" .
    _:Field <Type> "Field" .
	
	_:Location <Name> "gachibowli" .
    _:Location <Type> "Location" .
	
	
	#RelationShip
	
	_:District <area> _:Area .
	_:Area  <field> _:Field .
	_:Field <location> _:Location .
	
	
	_:orangegroup <entityLink> _:District .
	_:greengroup <entityLink> _:Field .

From The Above,If i combine (:orangegroup,:greengroup) result should be

{
_:District :{
_:area{
_:field{
_:location{
}
}
}
}
}

I am usisng this query to get the result


{
  
  var(func:eq(Type,Group)){
    entitiesorange As entityLink{
      Name
    }
  }
   var(func:eq(Type,Group)){
    entitiesgreen As entityLink{
      Name
    }
  }
    
  entities(func:uid(entitiesorange,entitiesgreen))@recurse(depth:4){
    Name
    Type
    area{
      Name  
      Type
    }
    field{
      Name
      Type
    }
    location{
      Name
      Type
    }
  }
}

and out put comming as like this

{
    "entities": [
      {
        "Name": "Ind",
        "Type": "District",
        "area": [
          {
            "Name": "TS",
            "Type": "Area",
            "field": [
              {
                "Name": "Hyd",
                "Type": "Field",
                "uid": "0x29830"
              }
            ],
            "uid": "0x2982f"
          }
        ],
        "uid": "0x2982e"
      },
      {
        "Name": "Hyd",
        "Type": "Field",
        "location": [
          {
            "Name": "gachibowli",
            "Type": "Location",
            "uid": "0x29831"
          }
        ],
        "uid": "0x29830"
      }
    ]
  }

MichelDiz · December 27, 2018, 1:43pm

I still don’t get what you wanna to do exac.

Your example seems incompatible with the idea.
The Orange don’t have “location”. And your query is doing nothing, has no effect.
In fact the variables are collecting the same graph objects/nodes. You don’t have any
filter there.

There’s no way in Dgraph to combine something by no similarity, via values.
something possible would be something like this A Tour of Dgraph
or work with nodes relations by edges and reverse edges.

your data:

{
  "data": {
    "q": [
      {
        "uid": "0xfb771",
        "Type": "Group",
        "Name": "Orange",
        "entityLink": [
          {
            "uid": "0xfb773",
            "Type": "District",
            "Name": "Ind",
            "area": [
              {
                "uid": "0xfb774",
                "field": [
                  {
                    "uid": "0xfb775",
                    "Type": "Field",
                    "Name": "Hyd"
                  }
                ],
                "Type": "Area",
                "Name": "TS"
              }
            ]
          }
        ]
      }
    ],
    "q2": [
      {
        "uid": "0xfb772",
        "Type": "Group",
        "Name": "Green",
        "entityLink": [
          {
            "uid": "0xfb775",
            "Type": "Field",
            "Name": "Hyd",
            "location": [
              {
                "uid": "0xfb776",
                "Type": "Location",
                "Name": "gachibowli"
              }
            ]
          }
        ]
      }
    ]
  }

MichelDiz · December 27, 2018, 2:25pm

Check this if it helps.

PS. If “getTrueOne” block is empty, there are no relations in entities

{
  
  var(func:eq(Name, "Orange")){
    entitiesorange As entityLink
  }
   var(func:eq(Name, "Green")){
    entitiesgreen As entityLink
  }
    
  entities(func:uid(entitiesorange, entitiesgreen))@recurse(depth:5){
    uid
    Type
    Name
    area
    #This filter will return if one of those nodes with "field" were true
    #If a node doesn't have the predicate "field" this variable will be
    #empty. So between "Orange" and "Green" - one will be true.
    #So you will know that the "Hyd Field" exists in both
   gettheone as field @filter(uid(entitiesorange, entitiesgreen))
    location
  }
}
    
   {
  getTrueOne(func: uid(gettheone)){
    uid
    expand(_all_){uid expand(_all_)}
  } 
  }

Data


{
  "data": {
    "entities": [
      {
        "uid": "0xfb773",
        "Type": "District",
        "Name": "Ind",
        "area": [
          {
            "uid": "0xfb774",
            "Type": "Area",
            "Name": "TS",
            "field": [
              {
                "uid": "0xfb775",
                "Type": "Field",
                "Name": "Hyd"
              }
            ]
          }
        ]
      },
      {
        "uid": "0xfb775",
        "Type": "Field",
        "Name": "Hyd",
        "location": [
          {
            "uid": "0xfb776",
            "Type": "Location",
            "Name": "gachibowli"
          }
        ]
      }
    ],
    "getTrueOne": [
      {
        "uid": "0xfb775",
        "Type": "Field",
        "Name": "Hyd",
        "location": [
          {
            "uid": "0xfb776",
            "Type": "Location",
            "Name": "gachibowli"
          }
        ]
      }
    ]
  }

Example when false

{
  var(func:eq(Name, "Orange")){
    entitiesorange As entityLink
  }
   var(func:eq(Name, "Green")){
    entitiesgreen As entityLink
  }
    
  entities(func:uid(entitiesorange, entitiesgreen))@recurse(depth:5){
    uid
    Type
    Name
    area
   gettheone as field @filter(uid(entitiesorange))
    location
  }
}
    
   {
  getTrueOne(func: uid(gettheone)){
    uid
    expand(_all_){uid expand(_all_)}
  } 
  }

{
  "data": {
    "entities": [
      {
        "uid": "0xfb773",
        "Type": "District",
        "Name": "Ind",
        "area": [
          {
            "uid": "0xfb774",
            "Type": "Area",
            "Name": "TS"
          }
        ]
      },
      {
        "uid": "0xfb775",
        "Type": "Field",
        "Name": "Hyd",
        "location": [
          {
            "uid": "0xfb776",
            "Type": "Location",
            "Name": "gachibowli"
          }
        ]
      }
    ],
    "getTrueOne": [] #So it's false.
  }

siva · December 27, 2018, 5:38pm

Hi Thanks for your efforts

Actually what i need to do is

we have an application to show the nodes in an hairachy level(district-area-field-location) to the user based on his groups which are all connected to the nodes

Hairachy Nodes:

{
   "Name":"HydDist",
   "uid" : "01D"
   "areaLink":{
     Name:"HydArea",
	 "uid":"01A",
	 "fieldLink":{
	  "Name":"HydField",
	  "uid":"01F",
	  "locationLink":{
	    "Name":"HydLocation",
		"uid":"01L"
	  }
	   
	 }
    }
   }

so assume person have onegroup called orangegroup node which is connected to the top node district ,so final relationship will be

{
   "Name":"orangegroup",
   "uid" : "01OG",
   "entitylink":{
   "Name":"HydDist",
   "uid" : "01D"
   "areaLink":{
     Name:"HydArea",
	 "uid":"01A",
	 "fieldLink":{
	  "Name":"HydField",
	  "uid":"01F",
	  "locationLink":{
	    "Name":"HydLocation",
		"uid":"01L"
	  }
	   
	 }
    }
   }
}

so when i query i can get the same hirachy which i want district-area-field-location

{
   "Name":"HydDist",
   "uid" : "01D"
   "areaLink":{
     Name:"HydArea",
	 "uid":"01A",
	 "fieldLink":{
	  "Name":"HydField",
	  "uid":"01F",
	  "locationLink":{
	    "Name":"HydLocation",
		"uid":"01L"
	  }
	   
	 }
    }
   }

now assume same person have another group called greengroup and its connected as follows

{
   "Name":"greengroup",
   "uid" : "01GG",
   "entitylink":{
	  "Name":"HydField",
	  "uid":"01F",
	  "locationLink":{
	    "Name":"HydLocation",
		"uid":"01L"
	  }
	   
	}
}

so when i query again for the same person i need to get the same hairachy with out duplicate nodes
district - area - field - location

person ->(orangegroup,greengroup) :

{
   "Name":"HydDist",
   "uid" : "01D"
   "areaLink":{
     Name:"HydArea",
	 "uid":"01A",
	 "fieldLink":{
	  "Name":"HydField",
	  "uid":"01F",
	  "locationLink":{
	    "Name":"HydLocation",
		"uid":"01L"
	  }
	   
	 }
    }
   }

Is that possible ?

siva · December 27, 2018, 5:51pm

Hairachy Nodes

{
   "Name":"HydDist",
   "uid" : "01D"
   "areaLink":{
     Name:"HydArea",
	 "uid":"01A",
	 "fieldLink":{
	  "Name":"HydField",
	  "uid":"01F",
	  "locationLink":{
	    "Name":"HydLocation",
		"uid":"01L"
	  }
	   
	 }
    }
   }

and if another person contains only one group called green group which is directly connected to field

{
   "Name":"greengroup",
   "uid" : "01GG",
   "entitylink":{
	  "Name":"HydField",
	  "uid":"01F",
	  "locationLink":{
	    "Name":"HydLocation",
		"uid":"01L"
	  }
	   
	}
}

so if i query for this person to show hairachy i need to get for this parents parents of this field

so final result will be

{
   "Name":"HydDist",
   "uid" : "01D"
   "areaLink":{
     Name:"HydArea",
	 "uid":"01A",
	 "fieldLink":{
	  "Name":"HydField",
	  "uid":"01F",
	  "locationLink":{
	    "Name":"HydLocation",
		"uid":"01L"
	  }
	   
	 }
    }
   }

Thanks

MichelDiz · December 27, 2018, 6:52pm

Do you wanna smash two nodes in one result based on similarities?

If so, Dgraph can’t do that. You should do it in the application level.

Or If you wanna see both data with the same structure you should mutate all of your data with the same structure. The example you gave me has different structures. While one has “location” the other has “field” with the same node. They are distinct in structure. The nodes that they are pointing are the same, but the way you built this structure is incompatible. And Dgraph can’t smash them together to show as you want. They’re in diferente “levels”. Green data has 3 levels, and Orange has 4. And each level use a different hierarchies.

You need to do it via application level. Or maybe I’m wrong and I still do not understand what you want to do.

Your hierarchy is applicable perfectly. But you should keep it the same “format” forever. If you want to use hierarchy as a parameter.

Topic		Replies	Views
Query Nodes Uniquely Dgraph kind:question	2	28	November 6, 2024
Query To Get Nodes Dgraph mutation , example	3	683	March 6, 2019
How to get the distinct node property Dgraph	1	979	July 1, 2018
How to make the query results not duplicate Dgraph kind:question , dgraph	13	650	September 17, 2020
Select distinct values / deduplicate Dgraph kind:question , dql	2	1434	April 27, 2021

How to get distinct nodes

your data:

Data

Example when false

Related topics