Spark SQL supports a subset of HiveQL: http://spark.apache.org/docs/latest/sql-programming-guide.html#compatibility-with-apache-hive
On Mon, Mar 9, 2015 at 11:32 PM, Ravindra <ravindra.baj...@gmail.com> wrote: > From the archives in this user list, It seems that Spark-SQL is yet to > achieve SQL 92 level. But there are few things still not clear. > 1. This is from an old post dated : Aug 09, 2014. > 2. It clearly says that it doesn't support DDL and DML operations. Does > that means, all reads (select) are sql 92 compliant? > > Please clarify. > > Regards, > Ravi > > On Tue, Mar 10, 2015 at 11:46 AM Ravindra <ravindra.baj...@gmail.com> > wrote: > >> Hi All, >> >> I am new to spark and trying to understand what SQL Standard is supported >> by the Spark. I googled around a lot but didn't get clear answer. >> >> Some where I saw that Spark supports sql-92 and at other location I found >> that spark is not fully compliant with sql-92. >> >> I also noticed that using Hive Context I can execute almost all the >> queries supported by the Hive, so does that means that Spark is equivalent >> to Hive in terms of sql standards, given that HiveContext is used for >> querying. >> >> Please suggest. >> >> Regards, >> Ravi >> >
