When SQL run from the other programming language the result will be-1. Neither DataFrame nor Dataset2. DataFrame3. DataSet4. Either DataFrame or Dataset
Answer is:- 4. Either DataFrame or Dataset
🔗Reference : W3school.com
🔗Source: Interview Questions and Answers
One use of Spark SQL is to execute SQL queries. Spark SQL can also be used to read data from an existing Hive installation. For more on how to configure this feature, please refer to the Hive Tables section. When running SQL from within another programming language the results will be returned as a Dataset/DataFrame. You can also interact with the SQL interface using the command-line or over JDBC/ODBC.