You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2021/04/26 13:23:21 UTC
[GitHub] [arrow-datafusion] alamb opened a new issue #119: Add SQL support for referencing fields in structs
alamb opened a new issue #119:
URL: https://github.com/apache/arrow-datafusion/issues/119
*Note*: migrated from original JIRA: https://issues.apache.org/jira/browse/ARROW-10761
I would like to be able to use SQL to query data sources such as Parquet and JSON that support nested types.
Example:
{code:java}
SELECT id, first_name, address.zip AS zip_code FROM customer{code}
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] alamb closed issue #119: Add SQL support for referencing fields in structs
Posted by GitBox <gi...@apache.org>.
alamb closed issue #119:
URL: https://github.com/apache/arrow-datafusion/issues/119
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] Igosuki commented on issue #119: Add SQL support for referencing fields in structs
Posted by GitBox <gi...@apache.org>.
Igosuki commented on issue #119:
URL: https://github.com/apache/arrow-datafusion/issues/119#issuecomment-955178131
#1204
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] alamb closed issue #119: Add SQL support for referencing fields in structs
Posted by GitBox <gi...@apache.org>.
alamb closed issue #119:
URL: https://github.com/apache/arrow-datafusion/issues/119
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] Igosuki commented on issue #119: Add SQL support for referencing fields in structs
Posted by GitBox <gi...@apache.org>.
Igosuki commented on issue #119:
URL: https://github.com/apache/arrow-datafusion/issues/119#issuecomment-945892250
Sorry I haven't had time to finish the PR as I'm traveling. But indeed the
patch provides unified access for nested bracket notations. Using a '.' is
more a JSON path expression (see hive and postures dialects for instance)
Le lun. 18 oct. 2021 à 05:07, QP Hou ***@***.***> a écrit :
> I think we are almost there with this feature, see my comment in #1006
> (comment)
> <https://github.com/apache/arrow-datafusion/pull/1006#issuecomment-941938893>
> .
>
> —
> You are receiving this because you were mentioned.
> Reply to this email directly, view it on GitHub
> <https://github.com/apache/arrow-datafusion/issues/119#issuecomment-945323640>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AADDFBVLJB4PHXDJF7KFIMTUHOFQFANCNFSM43S4FFWA>
> .
> Triage notifications on the go with GitHub Mobile for iOS
> <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675>
> or Android
> <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
>
>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] houqp commented on issue #119: Add SQL support for referencing fields in structs
Posted by GitBox <gi...@apache.org>.
houqp commented on issue #119:
URL: https://github.com/apache/arrow-datafusion/issues/119#issuecomment-945323458
In @Igosuki 's recent PR (https://github.com/apache/arrow-datafusion/pull/1006) for adding list indexing support, he proposed using `field["key"]` to access nested struct field, which I think makes the query more readable. For example, `foo.id` could mean accessing the `id` attribute from an unqualified `foo` column or accessing the `id` column from the table `foo`. `foo["id"]` makes it clear that `id` is for accessing of struct field.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] houqp commented on issue #119: Add SQL support for referencing fields in structs
Posted by GitBox <gi...@apache.org>.
houqp commented on issue #119:
URL: https://github.com/apache/arrow-datafusion/issues/119#issuecomment-945323640
I think we are almost there with this feature, see my comment in https://github.com/apache/arrow-datafusion/pull/1006#issuecomment-941938893.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org