Skip to content

Instantly share code, notes, and snippets.

@myui

myui/test.sql

Created March 14, 2019 01:39
Show Gist options
  • Save myui/16d2968427bd6f355b1b73ff91e609d7 to your computer and use it in GitHub Desktop.
Save myui/16d2968427bd6f355b1b73ff91e609d7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
test.sql
SELECT
from_json(to_json(
ARRAY(
NAMED_STRUCT("country", "japan", "city", "tokyo"),
NAMED_STRUCT("country", "japan", "city", "osaka")
)
),'array<struct<city:string>>');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment