Unmarshalling error when using NRQL with FACET clause

[sirianni]

Description

nrql query returns an unmarshalling error when used with FACET clause.

Current behavior

newrelic nrql query -q 'SELECT latest(k8s.pod.memory.usage) FROM Metric FACET `k8s.pod.name` SINCE 3 MINUTES AGO TIMESERIES 1 MINUTE'
cannot unmarshal array into Go struct field NRDBResultContainer.data.Actor.Account.NRQL.otherResult of type nrdb.NRDBResult

Expected behavior

I expect the query to return data like it does in the browser.

[shashank-reddy-nr]

Hi @sirianni ,

This issue is similar to a known problem where the response from Nerd Graph (New Relic API gateway) varies based on the query used. Specifically, when using certain queries ex: when you use FACET and TIMESERIES in same query, the otherResult and totalResult values are returned as lists, while other queries return these values as objects.

To support both data types, we would need to restructure the datatype to an interface, which is a significant change given the fragility of the newrelic-client-go package, especially considering its use cases in the other repos. Therefore, we won't be able to support queries with FACET and TIMESERIES at once from CLI, this can be only queried from UI.

When we use FACET and TIMESERIES the nerdgraph response:

When we use just FACET the nerdgraph response: