Thanks Michael, That helps. So just to summarise that we should not make any assumption about Spark being fully compliant with any SQL Standards until announced by the community and maintain the same status quo as you have suggested.
Regards, Ravi. On Tue, Mar 10, 2015 at 11:14 PM Michael Armbrust <mich...@databricks.com> wrote: > 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 >>> >> >
