Query doesn't work when using a selector

[NBruel]

When i'm doing a simple request with a selector, the database return the time and sequence_number but doesn't return the metric asked. A simple request as 'select * from monitoring' works. If you need anything special, asks me.

[jvshahid]

Can you please provide a sample of the data you're writing in and the query that you're running along with the expected vs. actual result of running the query.

Cheers,

[NBruel]

I've send the data to pauldix since i don't have your email, i have explained that it was for you.

The queries i used are 'select from monitoring where time > now() -5m' which work fine but when i want that key with a 'select from monitoring where key = and time > now() -5m' it return the time and sequence_number but not the metric expected.

I hope it's clear, have a good day.

[jvshahid]

The two queries that you provided aren't valid for the following reasons:

1. You're not selecting any columns in both queries, i exepcted to see select * or select column1, column2
2. In your second query, you have key = in the where clause but you didn't provide a value after the equal sign. I expected to see key = 'some_value' for example.

Can you verify that these are the queries that you're using. It seems like a copy paste error.

Cheers,

[NBruel]

Woops, sorry, my bad.

The correct queries are select * from monitoring , select cmds.config.calls from monitoring , select cmds.config.calls from monitoring where time > now() -2d

And then when i'm trying to use an other key like select cmds.config.calls from monitoring where time > now() -2d and key = '52ea7a52337271db1a000005' it doesn't work, it returns the correct time and sequence_number but not cmds.config.calls values.

[FGRibreau]

@jvshahid Any news about that ? We started mirroring data to influxdb in production but we can't request it.

[jvshahid]

We opened another issue #240 for querying columns with dots in them. I believe this is the issue you're experiencing. I'll try to get a fix in master sometime today.