Created
December 26, 2021 23:54
-
-
Save 1ambda/5f6129197943993cbed78464ce7e7608 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
== Physical Plan == | |
* ColumnarToRow (2) | |
+- Scan parquet airbnb_db.listing_meta (1) | |
(1) Scan parquet airbnb_db.listing_meta | |
Output [9]: [listing_id#110445L, listing_name#110446, listing_url#110447, property_type#110448, country#110449, state#110450, city#110451, description#110452, dt#110453] | |
Batched: true | |
Location: InMemoryFileIndex [s3://airbnb-data-lake/db/listing_meta/dt=20211101] | |
PartitionFilters: [isnotnull(dt#110453), (dt#110453 = 20211101)] | |
ReadSchema: struct<listing_id:bigint,listing_name:string,listing_url:string,property_type:string,country:string,state:string,city:string,description:string> | |
(2) ColumnarToRow [codegen id : 1] | |
Input [9]: [listing_id#110445L, listing_name#110446, listing_url#110447, property_type#110448, country#110449, state#110450, city#110451, description#110452, dt#110453] | |
+----------+--------------------+--------------------+-------------+-------------+-----+---------+--------------------+--------+ | |
|listing_id| listing_name| listing_url|property_type| country|state| city| description| dt| | |
+----------+--------------------+--------------------+-------------+-------------+-----+---------+--------------------+--------+ | |
| 360|LoHi Secret garde...|https://www.airbn...| Guesthouse|United States| CO| Denver|Come enjoy our oa...|20211101| | |
| 590|Comfortable - an...|https://www.airbn...| House|United States| CO| Denver|Large guest room ...|20211101| | |
| 592| private|https://www.airbn...| House|United States| CO| Denver|This room is in t...|20211101| | |
| 1940|Baker Studio Clos...|https://www.airbn...| Guesthouse|United States| CO| Denver|Great place for a...|20211101| | |
| 2086| Garden Level Condo|https://www.airbn...| Apartment|United States| CO| Denver|A furnished, gard...|20211101| | |
| 31503|Highland Park Gue...|https://www.airbn...| Guest suite|United States| CO| Denver|Highland Park Gue...|20211101| | |
| 39405|LoHi Secret garde...|https://www.airbn...| Cottage|United States| CO| Denver|Come enjoy our oa...|20211101| | |
| 56185|charming home for...|https://www.airbn...| House|United States| CO| Denver|Spend time in Den...|20211101| | |
| 59631|VICTORIAN TOWNHOM...|https://www.airbn...| Townhouse|United States| CO| Denver|License #2017-BFN...|20211101| | |
| 74125|Spacious Cap Hill...|https://www.airbn...| Apartment|United States| CO| Denver|1000' entire-firs...|20211101| | |
| 81540|Affordable S. Den...|https://www.airbn...| Guesthouse|United States| CO|Englewood|Bright, sunny 1 b...|20211101| | |
| 90307|Comfy King Size R...|https://www.airbn...| House|United States| CO| Denver|This private bedr...|20211101| | |
| 98008|Beautiful sun fil...|https://www.airbn...| House|United States| CO| Denver|Locaton, location...|20211101| | |
| 98014|Beautiful single ...|https://www.airbn...| House|United States| CO| Denver|Hi Folks! Welcom...|20211101| | |
| 142683|Historic Denver C...|https://www.airbn...| House|United States| CO| Denver|One of three cond...|20211101| | |
| 172196|Luxury Wash Park ...|https://www.airbn...| House|United States| CO| Denver|Remodeled wash pa...|20211101| | |
| 184529|HIP SUITE IN WES...|https://www.airbn...| Guest suite|United States| CO| Denver|Private SUIITE ...|20211101| | |
| 192430|TREETOP VIEW ROOM...|https://www.airbn...| Condominium|United States| CO| Denver|Located in the de...|20211101| | |
| 217996| Highland Snug|https://www.airbn...| Condominium|United States| CO| Denver|Comfortable and c...|20211101| | |
| 236207|Denver Penthouse ...|https://www.airbn...| Loft|United States| CO| Denver|Important Note : ...|20211101| | |
+----------+--------------------+--------------------+-------------+-------------+-----+---------+--------------------+--------+ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment