If your intention is to just view the logical plan in spark shell  then I
think you can follow the query which I mentioned in previous mail.  In
spark 2.1.0 sessionState is a private member which you cannot access.

Thanks.


On Thu, 7 Sep 2017 at 11:39 AM, ChenJun Zou <stephen....@gmail.com> wrote:

> spark-2.1.1 I use
>
>
>
> 2017-09-07 14:00 GMT+08:00 sujith chacko <sujithchacko.2...@gmail.com>:
>
>> Hi,
>>     may I know which version of spark you are using, in 2.2 I tried with
>> below query in spark-shell for viewing the logical plan and it's working
>> fine
>>
>> spark.sql("explain extended select * from table1")
>>
>> The above query you can use for seeing logical plan.
>>
>> Thanks,
>> Sujith
>>
>> On Thu, 7 Sep 2017 at 11:03 AM, ChenJun Zou <stephen....@gmail.com>
>> wrote:
>>
>>> Hi,
>>>
>>> when I use spark-shell to get the logical plan of  sql, an error occurs
>>>
>>> scala> spark.sessionState
>>> <console>:30: error: lazy value sessionState in class SparkSession
>>> cannot be accessed in org.apache.spark.sql.SparkSession
>>>        spark.sessionState
>>>              ^
>>>
>>> But if I use spark-submit to access the "sessionState" variable, It's
>>> OK.
>>>
>>> Is there a way to access it in spark-shell?
>>>
>>
>

Reply via email to