You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@spark.apache.org by Gordon Benjamin <go...@gmail.com> on 2014/11/20 21:11:20 UTC

Debug Sql execution

hey,

Can anyone tell me how to debug a sql execution? Perhaps so it can show
what the query is doing and how long it takes at each point?

Re: Debug Sql execution

Posted by Cheng Lian <li...@gmail.com>.

You may try |EXPLIAN EXTENDED <sql>| to see the logical plan, analyzed 
logical plan, optimized logical plan and physical plan. Also 
|SchemaRDD.toDebugString| shows storage related debugging information.

On 11/21/14 4:11 AM, Gordon Benjamin wrote:

> hey,
>
> Can anyone tell me how to debug a sql execution? Perhaps so it can 
> show what the query is doing and how long it takes at each point?