Freebase; choose a random entry?

1) Is there a way to select a random entry from Freebase? If I make a limit of 1, it returns the same record sequentially. I could grab a larger dataset and pick a random props from that, but that seems like overkill. Similar to MySQL:

select * from profiles order by rand() limit 1;

      

2) Is there a way to tell Freebase not to select certain items in the set?

Similar to MySQL:

select * from profiles  where id NOT IN (SELECT profile_id from approved_profiles)

      

Thanks in advance

+2


a source to share


1 answer


Sorry, right now MQL doesn't have a random operator. This thread on the Freebase discussion list suggests using a random as_of_time as a worker process.



+2


a source







All Articles