New Relic Query Language limits results when selecting columns

Build on New Relic Data Queries & Synthetic Scripts
#1

When I create a query for events from a flex integration I can see all the events when I do a query like
FROM eventSample SELECT * Since 30 minutes ago
but when I limit the columns like
FROM eventSample SELECT EventName, EventValue Since 30 minutes ago
It limits the results to 10. Why is it limiting the results? It even limits it if I explicitly select every column, but it shows me all the results as I expect with a “*”

#2

Hi, @jgraham4: You may increase the number of rows returned by adding a LIMIT clause to your query:

FROM eventSample 
SELECT EventName, EventValue 
SINCE 30 minutes ago
LIMIT MAX
2 Likes
#3

Thank you this works. I guess it was just a weird behavior I wasn’t expecting. Thanks!