influxdata / influxdata/docs-v2

Table names are case-sensitive when querying

Open
#6,637 3 comments 0 reactions 0 assignees View on GitHub
good-first-issue InfluxDB 3 Core and Enterprise product:v3-monolith queries
Dominant language
JavaScript
Stars
82
Forks
326
Avg merge
1d 1h
Merged PRs (30d)
82

Description

Uppercase table names are allowed, but you must preserve the case when querying them:

`"CPU"` is needed to make table name in query to preserve the case.

```❯ ./influxdb3 query -d test1 'select count(*) from "CPU"'
+----------+
| count(*) |
+----------+
| 1 |
+----------+```
Without the `"`, you can see the same error

```❯ ./influxdb3 query -d test1 'select count(*) from CPU'
Query command failed: server responded with error [500 Internal Server Error]: query error: error while planning query: Error during planning: table 'public.iox.cpu' not found```
Note: I'm not on `3.7.0`, but I don't think version matters for this.

## Related links
- https://docs.influxdata.com/influxdb3/enterprise/admin/tables/create/#table-naming-restrictions

[Slack Message](https://influxdata.slack.com/archives/C084G9LR2HL/p1765975186314399?thread_ts=1765967953.967879&cid=C084G9LR2HL)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the linked InfluxDB Enterprise table-naming restrictions page and compare its guidance with the uppercase-table query examples in this issue. Update the relevant documentation to explain the case-sensitive behavior and quoting requirement, then verify that the examples and wording match the reported query results.

Written by the indexing model from the issue text.

Assessment

Domain
documentation
Issue type
Documentation
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.