This post was originally published on Pure Storage
<span style=”font-weight: 400;”>trino:</span><span style=”font-weight: 400;”>default</span><span style=”font-weight: 400;”>> </span><span style=”font-weight: 400;”>select</span> <span style=”font-weight: 400;”>count</span><span style=”font-weight: 400;”>(*) </span><span style=”font-weight: 400;”>from</span><span style=”font-weight: 400;”> nyctaxi;</span>
<span style=”font-weight: 400;”> _col0 </span>
<span style=”font-weight: 400;”>———–</span>
<span style=”font-weight: 400;”>899294289</span>
<span style=”font-weight: 400;”>(</span><span style=”font-weight: 400;”>1</span> <span style=”font-weight: 400;”>row</span><span style=”font-weight: 400;”>)</span>
<span style=”font-weight: 400;”>Query </span><span style=”font-weight: 400;”>20230815</span><span style=”font-weight: 400;”>_132013_00029_4suvq, FINISHED, </span><span style=”font-weight: 400;”>1</span><span style=”font-weight: 400;”> node</span>
<span style=”font-weight: 400;”>Splits: </span><span style=”font-weight: 400;”>343</span><span style=”font-weight: 400;”> total, </span><span style=”font-weight: 400;”>343</span><span style=”font-weight: 400;”> done (</span><span style=”font-weight: 400;”>100.00</span><span style=”font-weight: 400;”>%)</span>
<span style=”font-weight: 400;”>1.04</span><span style=”font-weight: 400;”> [</span><span style=”font-weight: 400;”>899</span><span style=”font-weight: 400;”>M </span><span style=”font-weight: 400;”>rows</span><span style=”font-weight: 400;”>, </span><span style=”font-weight: 400;”>3.56</span><span style=”font-weight: 400;”>MB] [</span><span style=”font-weight: 400;”>865</span><span style=”font-weight: 400;”>M </span><span style=”font-weight: 400;”>rows</span><span style=”font-weight: 400;”>/s, </span><span style=”font-weight: 400;”>3.43</span><span style=”font-weight: 400;”>MB/s]</span>
<span style=”font-weight: 400;”>trino:</span><span style=”font-weight: 400;”>default</span><span style=”font-weight: 400;”>> </span><span style=”font-weight: 400;”>select</span><span style=”font-weight: 400;”> * </span><span style=”font-weight: 400;”>from</span><span style=”font-weight: 400;”> nyctaxi </span><span style=”font-weight: 400;”>WHERE</span><span style=”font-weight: 400;”> tolls_amount > </span><span style=”font-weight: 400;”>100</span> <span style=”font-weight: 400;”>order</span> <span style=”font-weight: 400;”>by</span><span style=”font-weight: 400;”> tolls_amount </span><span style=”font-weight: 400;”>desc</span><span style=”font-weight: 400;”> limit </span><span style=”font-weight: 400;”>10</span><span style=”font-weight: 400;”>;</span>
<span style=”font-weight: 400;”>vendorid | tpep_pickup_datetime | tpep_dropoff_datetime | passenger_count | trip_distance | ratecodeid | store_and_fwd_flag | pulocationid | dolocationid | payment_type | fare_amount | extra | mta</span>
<span style=”font-weight: 400;”>———-+————————-+————————-+—————–+—————+————+——————–+————–+————–+————–+————-+——-+—-</span>
<span style=”font-weight: 400;”> </span><span style=”font-weight: 400;”>2</span><span style=”font-weight: 400;”> | </span><span style=”font-weight: 400;”>2017-07-03</span> <span style=”font-weight: 400;”>17</span><span style=”font-weight: 400;”>:</span><span style=”font-weight: 400;”>15</span><span style=”font-weight: 400;”>:</span><span style=”font-weight:
— Read the rest of this post, which was originally published on Pure Storage.
