Error Message | Explanation |
---|---|
at least one field or aggregation is required | Did not detect any selections or aggregations - make sure the query request contains at least one. |
invalid aggregation function for string type field ide: QUERY\_AGGREGATION\_SUM | One of the selections used an invalid aggregation function. In this case we tried to use SUM on the "ide" field, but it only supports COUNT and UNSPECIFIED |
invalid query table: QUERY\_DATA\_SOURCE\_UNSPECIFIED | There is likely a typo in the data\_source field, double check the spelling. |
all selection fields should have an aggregation function, or none of them should | If there are multiple selection fields, either all should contain an aggregation\_function, or none of them should. For example, this selection is invalid because num\_acceptances is summed, but num\_lines\_accepted is not: ```json "selections": [ { "field": "num_acceptances", "name": "total_acceptances", "aggregation_function": "QUERY_AGGREGATION_SUM" }, { "field": "num_lines_accepted", "name": "total_lines_accepted", "aggregation_function": "QUERY_AGGREGATION_UNSPECIFIED" } ] ``` Note: PCW is always considered aggregated. If no aggregation\_function is explicitly chosen, it is considered unspecified. If you would like information about both of these fields, use two seperate queries. |
invalid aggregation function for string type field ide: QUERY\_AGGREGATION\_SUM | Not every field supports every aggregation function; see the available fields section for the matches. In this case, the query used a QUERY\_AGGREGATION\_SUM aggregation function with the "ide" field, which is invalid. |
tried to aggregate on a distinct field: distinct\_developer\_days. Consider aggregating on the non-distinct fields instead: \[api\_key date] | Fields with the pattern "distinct\_\*" can not be in the aggregations section; the error suggests an alternative field(s) to aggregate on instead. So instead of: ```json "aggregations": [ { "field": "distinct_developer_days", "name": "distinct_developer_days" } ] ``` Try: ```json "aggregations": [ { "field": "api_key", "name": "api_key" }, { "field": "date", "name": "date" } ] ``` |
duplicate field alias for selection/aggregation: num\_acceptances | All selections and aggregations must have a different name. Keep in mind that if the name is not specified, by default it is set to \ |
invalid group name: GroupName | The group with the specified name was not found, double check the spelling. |
jupyter lab
.Error Message | Explanation |
---|---|
at least one field or aggregation is required | Did not detect any selections or aggregations - make sure the query request contains at least one. |
invalid aggregation function for string type field ide: QUERY\_AGGREGATION\_SUM | One of the selections used an invalid aggregation function. In this case we tried to use SUM on the "ide" field, but it only supports COUNT and UNSPECIFIED |
invalid query table: QUERY\_DATA\_SOURCE\_UNSPECIFIED | There is likely a typo in the data\_source field, double check the spelling. |
all selection fields should have an aggregation function, or none of them should | If there are multiple selection fields, either all should contain an aggregation\_function, or none of them should. For example, this selection is invalid because num\_acceptances is summed, but num\_lines\_accepted is not: ```json "selections": [ { "field": "num_acceptances", "name": "total_acceptances", "aggregation_function": "QUERY_AGGREGATION_SUM" }, { "field": "num_lines_accepted", "name": "total_lines_accepted", "aggregation_function": "QUERY_AGGREGATION_UNSPECIFIED" } ] ``` Note: PCW is always considered aggregated. If no aggregation\_function is explicitly chosen, it is considered unspecified. If you would like information about both of these fields, use two seperate queries. |
invalid aggregation function for string type field ide: QUERY\_AGGREGATION\_SUM | Not every field supports every aggregation function; see the available fields section for the matches. In this case, the query used a QUERY\_AGGREGATION\_SUM aggregation function with the "ide" field, which is invalid. |
tried to aggregate on a distinct field: distinct\_developer\_days. Consider aggregating on the non-distinct fields instead: \[api\_key date] | Fields with the pattern "distinct\_\*" can not be in the aggregations section; the error suggests an alternative field(s) to aggregate on instead. So instead of: ```json "aggregations": [ { "field": "distinct_developer_days", "name": "distinct_developer_days" } ] ``` Try: ```json "aggregations": [ { "field": "api_key", "name": "api_key" }, { "field": "date", "name": "date" } ] ``` |
duplicate field alias for selection/aggregation: num\_acceptances | All selections and aggregations must have a different name. Keep in mind that if the name is not specified, by default it is set to \ |
invalid group name: GroupName | The group with the specified name was not found, double check the spelling. |