[
https://issues.apache.org/jira/browse/ASTERIXDB-3513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Glenn Justo Galvizo updated ASTERIXDB-3513:
-------------------------------------------
Description:
The current grammar for Projection
([https://nightlies.apache.org/asterixdb/SQLPP.html#prod201]) doesn’t seem to
support the expression
{code:java}
v1.v2.*
{code}
, only a single variable “v1.*”.
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”
was:
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.*”.
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”
> SELECT v1.v2.*
> --------------
>
> Key: ASTERIXDB-3513
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3513
> Project: Apache AsterixDB
> Issue Type: New Feature
> Components: SQL - Translator SQL++
> Reporter: Glenn Justo Galvizo
> Assignee: Glenn Justo Galvizo
> Priority: Major
>
> The current grammar for Projection
> ([https://nightlies.apache.org/asterixdb/SQLPP.html#prod201]) doesn’t seem to
> support the expression
> {code:java}
> v1.v2.*
> {code}
> , only a single variable “v1.*”.
> 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”
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
