Performing scan queries

    You can run a query using Scan Queries via the YDB CLI by adding the -t scan flag to the ydb table query execute command.

    Run the data query:

    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"        |
    └───────────┴────────────┴──────────────────────────────┘