##
Hi there,

I hope some of you can help with an issue I an having .

I want to select a random starting node with maps to a random target node through a single specific relationship. I tried the following query but the target node is not random and when I add a distinct function to the target node it return and error.

MATCH (a)-[r:causes_f5plus]->(t:dsyn)

RETURN distinct(a.name), type(r), t.name, round(rand(), 10) as score

order by score

limit 50

/// this return random starting nodes but non-random target nodes.

##
I tried this and it return an error.

MATCH (n)-[r:causes_f5plus]->(m:dsyn)

RETURN distinct(n.name), type(r), distinct(m.name), round(rand(), 10) as score

order by score

limit 5

// but it return ..

*Unknown function 'distinct' (line 2, column 35 (offset: 73))*

*"RETURN DISTINCT (*`n`

).`name`

AS `(n.name)`

, `type`

((`r`

)) AS `type(r)`

, `distinct`

(((`m`

).`name`

)) AS `distinct(m.name)`

, `round`

((`rand`

()), (10)) AS `score`

`n`

).`name`

AS `(n.name)`

, `type`

((`r`

)) AS `type(r)`

, `distinct`

(((`m`

).`name`

)) AS `distinct(m.name)`

, `round`

((`rand`

()), (10)) AS `score`

I also tried collect(distinct(m.name)) and it is not random.

I wish some of you can lend some help.

by the way when I say non-random results I mean something like this

A-->j

J-->j

q-->j

x-->j

k-->j

I am looking from something like this where both the starting nodes and the target nodes are completely random.

J-->c

q-->u

x-->t

k-->a

your help is greatly appreciated.