Simple Query fails

Welcome & Getting Started
1

Hi there,

I need a little help with my Query and I’m new to influx.

My first query has no result, but nearly the same query has results and is working. What am I missing?

> SELECT "vmid" FROM "system" WHERE ("object" = 'qemu' AND "status" = 'stopped') GROUP BY "host" LIMIT 1
{
    "results": [
        {}
    ]
}
> SELECT "status","vmid" FROM "system" WHERE ("object" = 'qemu' AND "status" = 'stopped') GROUP BY "host" LIMIT 1
{
    "results": [
        {
            "series": [
                {
                    "name": "system",
                    "tags": {
                        "host": "Debian10Template"
                    },
                    "columns": [
                        "time",
                        "status",
                        "vmid"
                    ],
                    "values": [
                        [
                            "2021-06-25T13:33:35Z",
                            "stopped",
                            "202999"
                        ]
                    ]
                }
            ]
        },
2

Hi @MTHAW,

You probably missed this…

SELECT clause must specify at least one field when it includes a tag.

Have a nice weekend!
Marc