zetasql | ZetaSQL - Analyzer Framework for SQL | Analytics library
kandi X-RAY | zetasql Summary
kandi X-RAY | zetasql Summary
ZetaSQL defines a language (grammar, types, data model, and semantics) as well as a parser and analyzer. It is not itself a database or query engine. Instead it is intended to be used by multiple engines wanting to provide consistent behavior for all semantic analysis, name resolution, type checking, implicit casting, etc. Specific query engines may not implement all features in the ZetaSQL language and may give errors if specific features are not supported. For example, engine A may not support any updates and engine B may not support analytic functions.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of zetasql
zetasql Key Features
zetasql Examples and Code Snippets
Community Discussions
Trending Discussions on zetasql
QUESTION
I want to have Row with nested Row from output of Beam SQL (SqlTransform), but failing.
Questions:
- What is the proper way to output Row with nested Row from SqlTransform? (Row type is described in the docs, so I believe it's supported)
- If this is a bug/missing feature, is the problem of Beam itself? Or runner-dependent? (I'm currently using on DirectRunner, but going to use DataflowRunner in future.)
Version info:
- OS: macOS 10.15.7 (Catalina)
- Java: 11.0.11 (AdoptOpenJDK)
- Beam SDK: 2.32.0
Here's what I've tried, with no luck.
With Calcite dialect ...ANSWER
Answered 2021-Sep-23 at 23:59Unfortunately Beam SQL does not yet support nested rows, mainly due to a lack of support in Calcite (and therefore a corresponding lack of support for the ZetaSQL implementation). See this similar question focused on Dataflow.
On the bright side, the Jira issue tracking this support seems to be resolved for 2.34.0, so proper support is likely upcoming.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install zetasql
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page