whereHavingExample sample throws error

[bhshkh]

java-firestore/samples/preview-snippets/src/main/java/com/example/firestore/PipelineSnippets.java

Lines 1823 to 1837 in be110ee

	void whereHavingExample() throws ExecutionException, InterruptedException {
	// [START where_having_example]
	Pipeline.Snapshot cities =
	firestore
	.pipeline()
	.collection("cities")
	.aggregate(
	Aggregate.withAccumulators(sum("population").as("totalPopulation"))
	.withGroups("location.state"))
	.where(field("totalPopulation").greaterThan(10000000))
	.execute()
	.get();
	// [END where_having_example]
	System.out.println(cities.getResults());
	}

throws error

Caused by: io.grpc.StatusRuntimeException: INVALID_ARGUMENT: The nested field reference 'location.state' is not supported in its current use case.

Certain stages like `aggregate(...)` or `unnest(...)` only support assigning to top-level fields. This means you cannot use an alias like 'foo.bar' to assign the result to a nested field. If you want to use an alias that has a dot in it, escape the path with backticks, like `foo.bar`.

Depending on the SDK, this can be done like so:`.distinct(field("address.city").as("`address.city`"))`
	at io.grpc.Status.asRuntimeException(Status.java:532)

[morganchen12]

TODO(me): rename the field to city (no subfield)