influxdata / influxdata/docs-v2
Table names are case-sensitive when querying
- 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