When I enter the following query:
SELECT mean("close") AS "mean_close" FROM "StockData"."autogen"."intraday_data" GROUP BY symbol FILL(null)
time intraday_data.mean_close symbol 1969-12-31T18:00:00.000-06:00 285.253120586821 QQQ 1969-12-31T18:00:00.000-06:00 331.414171115378 SPY
But when I try to list the symbol tag values as a query:
SHOW TAG VALUES ON "StockData" FROM "intraday_data" WITH KEY = "symbol"
“Your query or command is syntactically correct but returned no results.”
How does the select know about the symbol tag but as soon as I ask it for a list of known symbol values it comes up empty?