<p>I need to get a sample of random stars and the GAIA DR3 and Astrophysical parameters data, but I can't seem to figure it out. No matter what I do, they are always ordered one way or another (by either temperature, or coordinates now?!). I know ADQL doesn't support random functions.
What should I do? Thank you very much!</p>

CC BY-SA 4.0
2024-12-09T18:20:29.347Z
Why don't you use a different method to make the random selection (after getting the ordered data from ADQL)? For example, write a program to select lines randomly. For example, print out 24 pages and throw darts at them. For example ....
JohnHoltz
CC BY-SA 4.0
2024-12-09T21:11:54.123Z
This was also the recommended approach for the Rubin Data Preview 0 in a [Community thread](https://community.lsst.org/t/adql-question-selecting-a-random-subset-of-objects-in-dp0/8022) (should be readable to everyone). Download all the object (GaiaDR3) id's into a CSV file using an asynchronous query (so it doesn't timeout) and then make a random sampling of the object Id's and query for those specifically
astrosnapper
<galaxy><astrophysics><data-analysis><gaia>
Need help on random sample of stars, GAIA ADQL code
astrid lovespie
# Need help on random sample of stars, GAIA ADQL code

(Asked by: username_0 on 2024-12-07)

I need to get a sample of random stars and the GAIA DR3 and Astrophysical parameters data, but I can't seem to figure it out. No matter what I do, they are always ordered one way or another (by either temperature, or coordinates now?!). I know ADQL doesn't support random functions.
What should I do? Thank you very much!

**Tags:** galaxy, astrophysics, data-analysis, gaia
> **Comments:**
> **username_1**: Why don't you use a different method to make the random selection (after getting the ordered data from ADQL)? For example, write a program to select lines randomly. For example, print out 24 pages and throw darts at them. For example ....  
> **username_2**: This was also the recommended approach for the Rubin Data Preview 0 in a [Community thread](https://community.lsst.org/t/adql-question-selecting-a-random-subset-of-objects-in-dp0/8022) (should be readable to everyone). Download all the object (GaiaDR3) id's into a CSV file using an asynchronous query (so it doesn't timeout) and then make a random sampling of the object Id's and query for those specifically  

---

## 0 answers

