That seems like a reasonable request! Can you file an issue for it in
AsterixDB issues land? Presumably it returns MISSING if v2 isn't an
object, right? (I.e., if v2 is MISSING, NULL, scalar, ARRAY, or
MULTISET-valued, it would return empty. Most notably, no path'ing
through ARRAYs or MULTI-SETs.)
Cheers,
Mike
PS - Feel free to maybe self-assign? :-) Or we could try to find a
volunteer somehow....
On 10/5/24 5:25 PM, Glenn Galvizo wrote:
Hi all,
The current grammar for Projection
(https://nightlies.apache.org/asterixdb/SQLPP.html#prod201) doesn’t seem to
support the expression “v1.v2.*”, only a single variable “v1.*”. Is there a
technical reason for this? (If not, can I make a feature request? :-))
My current workaround is to specify something like:
“FROM MyDataset d LET content = d.msg.content SELECT content.* EXCLUDE extra”
But ideally, I want to write the following query (which currently throws a
syntax error):
“FROM MyDataset d SELECT d.msg.content.* EXCLUDE extra”
Best,
Glenn
