Hi Ashmath, Try refresh table
// spark is an existing SparkSession spark.catalog.refreshTable("my_table") http://spark.apache.org/docs/latest/sql-programming-guide.html#metadata-refreshing Regards, Vaquar khan On Sun, Feb 5, 2017 at 7:19 PM, KhajaAsmath Mohammed < mdkhajaasm...@gmail.com> wrote: > Hi, > > I have a hive view which is basically set of select statements on some > tables. I want to read the hive view and use hive builtin functions > available in spark sql. > > I am not able to read that hive view in spark sql but can retreive data in > hive shell. > > can't spark access hive views? > > Thanks, > Asmath > -- Regards, Vaquar Khan +1 -224-436-0783 IT Architect / Lead Consultant Greater Chicago