Skip to content

Instantly share code, notes, and snippets.

@1ambda
Created December 26, 2021 23:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 1ambda/5f6129197943993cbed78464ce7e7608 to your computer and use it in GitHub Desktop.
Save 1ambda/5f6129197943993cbed78464ce7e7608 to your computer and use it in GitHub Desktop.
== 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