Question

Which creates DataFrame objects and executes SQL queries in Spark Sql

Answer 1

There are generally two types of data sets

The spark sql only supports these two data sets .

The first method uses the reflection of the RDD schema, which contains certain types of objects.

This approach which is of relection  works much more compressed code and better when the schema is already known by writing your compact code.

Answer 2

The SQL server service creates DataFrame objects and executes SQL queries in Spark Sql.

It is an executable method that works as a SQL server database engine.

It can work as a local user, domain user or a managed service account.

It keeps running in the background without the need of any interaction with the real users.

Some examples include your antivirus program, keyboard driver, mouse driver etc.