Why is this simple influx select query returning an empty result?

Question

Following from: https://stackoverflow.com/a/47459151/1663462

> use abcxyz;
Using database abcxyz
> INSERT cpu,host=serverA,region=us_west value=0.64
> SELECT * from abcxyz;
> SELECT cpu from abcxyz;

Why are the SELECT queries returning no results?

I've found a query that works:

select * from cpu;
name: cpu
time                host    region  value
----                ----    ------  -----
1555173896021474852 serverA us_west 0.64
1555173957479404100 serverA us_west 0.64
1555173967231619401 serverA us_west 0.64

score 3 · Accepted Answer · answered Apr 14 '19 at 22:34

3

SELECT works against measurements, which exist within a database. You can think of a measurement as a table in standard RDBMS software.

So SELECT fields_or_tags FROM measurement is the correct syntax

answered Apr 14 '19 at 22:34

Rawkode

21,990
5
38
45

Should it not have shown an error then, when selecting from a measurement that doesn't exit? – Chris Stryczynski Apr 15 '19 at 10:41

Why is this simple influx select query returning an empty result?

1 Answers1