EXPLAIN¶
Syntax¶
snappy> explain select <query>
Description¶
Provides information about how your query is executed.
Example¶
snappy> explain select avg(arrdelay) from airline;
plan
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
== Physical Plan ==
CollectAggregate
+- *SnappyHashAggregate(ByteBufferHashMap used = false; keys=[], modes=Partial, functions=[partial_avg(cast(arrdelay#750 as bigint))])
+- *Partitioned Scan ColumnFormatRelation[app.airline], Requested Columns = [arrdelay#750] partitionColumns = [] numBuckets = 8 numPartitions = 2