Skip to content

Instantly share code, notes, and snippets.

@yaooqinn
Created April 4, 2019 05:41
Show Gist options
  • Save yaooqinn/2496383a248f24d8d9fd22cc0ba388d6 to your computer and use it in GitHub Desktop.
Save yaooqinn/2496383a248f24d8d9fd22cc0ba388d6 to your computer and use it in GitHub Desktop.
spark-sql> select * from default.src;
15	val_15
17	val_17
0	val_0
4	val_4
12	val_12
8	val_8
0	val_0
0	val_0
15	val_15
19	val_19
10	val_10
5	val_5
11	val_11
5	val_5
2	val_2
12	val_12
5	val_5
18	val_18
9	val_9
18	val_18
Time taken: 6.419 seconds, Fetched 20 row(s)
spark-sql> explain select * from default.src;

== Physical Plan ==
*(1) Filter (isnotnull(key#10) && (key#10 < 20))
+- HiveTableScan [key#10, value#11], HiveTableRelation `default`.`src`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [key#10, value#11]
Time taken: 0.466 seconds, Fetched 1 row(s)
spark-sql>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment