Created on 04-26-2019 02:13 AM - edited 09-16-2022 07:20 AM
Created 05-28-2019 03:56 AM
Created 06-03-2019 01:46 PM
from spark or pyspark shell use the below commands to access hive database objects.
spark.sql("show databases;")
spark.sql("select * from databasename.tablename;")
or
spark.read.table("databasename.tablename")
You can give any query inside spark.sql which will give you results.