https://community.cloudera.com/t5/Support-Questions/how-to-access-hive-database-tables-through-spark-and-pyspark/m-p/91178#M3914 <P>from spark or pyspark shell use the below commands to access hive database objects.</P><P>&nbsp;</P><P>spark.sql("show databases;")</P><P>spark.sql("select * from databasename.tablename;")</P><P>or</P><P>spark.read.table("databasename.tablename")</P><P>&nbsp;</P><P>You can give any query inside spark.sql which will give you results.</P> Mon, 03 Jun 2019 20:46:19 GMT Yeseswini 2019-06-03T20:46:19Z