I have a sql query to connect mongodb atlas using atlas sql interface. I am facing error as " Field released in the SELECT clause at the 0 scope level not found. "
But “released” field is a top level field.
Query - select year(released),COUNT(released) from movies group by year(released)
Also i have attached the screenshot of error.
Greetings @SUBHASH_V_K and welcome to the community!
This is hard to diagnose without more information (like the logs), but one thing I’d point out is that your sql syntax is not correct. Our dialect, is called mongosql and you can find more about it in our documentation. It is SQL-92 compatible. Here is how you would want to form your SQL Statement:
Select EXTRACT(YEAR FROM released) as Released_Year, COUNT(EXTRACT(YEAR FROM released))as Year_Count from Movies.movies
GROUP BY Released_Year
Let me know if you have further questions.
| Topic | Replies | Views | Activity |
|---|---|---|---|
| Fuzzy search count running very slow | 1 | 635 | May 2024 |
| An unexpected error occurred. Please try again later. How can solve this? | 0 | 229 | Jul 2024 |
| Export schema across collections | 1 | 65 | Jan 22 |
| Enabling Federated Auth in Database access | 0 | 19 | Jan 16 |
| Timeout when Azure App Service tries to connect | 1 | 49 | Feb 21 |
