You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@spark.apache.org by Fatma Ozcan <fa...@gmail.com> on 2015/03/16 21:47:37 UTC

Querying JSON in Spark SQL

Is there any documentation that explains how to query JSON documents using
SparkSQL?

Thanks,
Fatma

Re: Querying JSON in Spark SQL

Posted by Matei Zaharia <ma...@gmail.com>.
The programming guide has a short example: http://spark.apache.org/docs/latest/sql-programming-guide.html#json-datasets <http://spark.apache.org/docs/latest/sql-programming-guide.html#json-datasets>. Note that once you infer a schema for a JSON dataset, you can also use nested path notation (e.g. select user.name from users) in the same way as in Hive.

Matei

> On Mar 16, 2015, at 4:47 PM, Fatma Ozcan <fa...@gmail.com> wrote:
> 
> Is there any documentation that explains how to query JSON documents using SparkSQL? 
> 
> Thanks,
> Fatma