---
title: "Get selected segments timestamps"
method: GET
path: "/segments/{tableName}/select"
tags: ["Segment"]
deprecated: true
---

# Get selected segments timestamps

`GET /segments/{tableName}/select`

> **Deprecated.**

Get the selected segments given the (inclusive) start and (exclusive) end timestamps in milliseconds. These timestamps will be compared against  minmax values of the time column in each segment. If the table is a refresh use case, the value of start and end timestamp is voided, since there is no time column for refresh use case; instead, the whole qualified segments will be returned. If no timestamps are provided, all the qualified segments will be returned. For the segments that partially belong to the time range, the boolean flag 'excludeOverlapping' is introduced in order for user to determine whether to exclude this kind of segments in the response.

## Path parameters

- `tableName` string, required

## Query parameters

- `type` string
- `startTimestamp` string
- `endTimestamp` string
- `excludeOverlapping` boolean

## Response `200`

successful operation

- object[]

---

[API](https://skmtc.net/startree/apis/pinot-controller-api.md) · [All operations](https://skmtc.net/startree/apis/pinot-controller-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/startree/pinot-controller-api/versions/f1cc8a0ba2e0/schema)