Running scan queries
Warning
Using ScanQuery is not recommended for new scenarios. Use standard mechanisms to execute queries.
For more details, see the Executing queries section.
The exception is executing long-running (over 5 minutes) queries against row tables. In this case, we still recommend using ScanQuery, as standard query execution mechanisms do not yet fully support this scenario.
To run a query via Scan Queries using YDB CLI, add the -t scan flag to the ydb table query execute command.
Run a query against the data:
ydb table query execute -t scan \
--query "SELECT season_id, episode_id, title \
FROM episodes \
WHERE series_id = 1 AND season_id > 1 \
ORDER BY season_id, episode_id \
LIMIT 3"
Where:
--query— query text.
Result:
┌───────────┬────────────┬──────────────────────────────┐
| season_id | episode_id | title |
├───────────┼────────────┼──────────────────────────────┤
| 2 | 1 | "The Work Outing" |
├───────────┼────────────┼──────────────────────────────┤
| 2 | 2 | "Return of the Golden Child" |
├───────────┼────────────┼──────────────────────────────┤
| 2 | 3 | "Moss and the German" |
└───────────┴────────────┴──────────────────────────────┘