![]() If you view the native explanation of a SQL UNNEST, you'll notice that Druid uses j0.unnest as a virtual column to perform the unnest.Specifically, it is not needed when you're unnesting an inline array since the array itself is the datasource. This is needed in most cases of the UNNEST function. Notice the comma between the datasource and the UNNEST function.You can unnest multiple source expressions in a single query.You must include the context parameter "enableUnnest": true.Keep the following things in mind when writing your query: ![]() If you don't provide this, Druid uses a nondescriptive name, such as EXPR$0. Replace table_alias_name and column_alias_name with a table and column name you want to alias the unnested results to. Use it to specify the output, which can be an existing column or a new one.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |