== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- Scan json (1)
(1) Scan json
Output [2]: [meta#109, results#110]
Batched: false
Location: InMemoryFileIndex [file:/home/jovyan/data/openaq-api-data]
ReadSchema: struct<meta:struct<found:bigint,limit:bigint,name:string,page:bigint,website:string>,results:array<struct<bounds:array<double>,coordinates:struct<latitude:double,longitude:double>,country:struct<code:string,id:bigint,name:string>,datetimeFirst:struct<local:string,utc:string>,datetimeLast:struct<local:string,utc:string>,distance:string,id:bigint,instruments:array<struct<id:bigint,name:string>>,isMobile:boolean,isMonitor:boolean,licenses:string,locality:string,name:string,owner:struct<id:bigint,name:string>,provider:struct<id:bigint,name:string>,sensors:array<struct<id:bigint,name:string,parameter:struct<displayName:string,id:bigint,name:string,units:string>>>,timezone:string>>>
(2) Project [codegen id : 1]
Output [2]: [meta#109.name AS src#126, results#110[0].name AS location_name#127]
Input [2]: [meta#109, results#110]
(3) CollectLimit
Input [2]: [src#126, location_name#127]
Arguments: 1000