5 ms·
One big difference is native support for nested data that's built right into the syntax of the language. Most other SQL implementations allow support for neste
by dlurton 7y ago
One big difference is native support for nested data that's built right into the syntax of the language. Most other SQL implementations allow support for nested data through functions which have non-intuitive syntax.
- cmollis 7y agoWe generally build views to unnest the arrays, maps, and structs and query from them (or build other tables from the views in hive) but something like this is certainly a bit easier