Re: Supported SQL syntax in Spark SQL

2014-07-17 Thread Nicholas Chammas
FYI: I've created SPARK-2560 to track creating SQL reference docs for Spark SQL. On Mon, Jul 14, 2014 at 2:06 PM, Michael Armbrust wrote: > You can find the parser here: > https://github.com/apache/spark/blob/master/sql/catalyst/src/main/scala/

Re: Supported SQL syntax in Spark SQL

2014-07-14 Thread Michael Armbrust
You can find the parser here: https://github.com/apache/spark/blob/master/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/SqlParser.scala In general the hive parser provided by HQL is much more complete at the moment. Long term we will likely stop using parser combinators and either wri

Re: Supported SQL syntax in Spark SQL

2014-07-14 Thread Martin Gammelsæter
I am very interested in the original question as well, is there any list (even if it is simply in the code) of all supported syntax for Spark SQL? On Mon, Jul 14, 2014 at 6:41 AM, Nicholas Chammas wrote: >> Are you sure the code running on the cluster has been updated? > > I launched the cluster

Re: Supported SQL syntax in Spark SQL

2014-07-13 Thread Nicholas Chammas
Are you sure the code running on the cluster has been updated? I launched the cluster using spark-ec2 from the 1.0.1 release, so I’m assuming that’s taken care of, at least in theory. I just spun down the clusters I had up, but I will revisit this tomorrow and provide the information you requeste

Re: Supported SQL syntax in Spark SQL

2014-07-13 Thread Michael Armbrust
Are you sure the code running on the cluster has been updated? We recently optimized the execution of LIKE queries that can be evaluated without using full regular expressions. So it's possible this error is due to missing functionality on the executors. > How can I trace this down for a bug rep

Re: Supported SQL syntax in Spark SQL

2014-07-13 Thread Nicholas Chammas
here a place where we can find an up-to-date list of supported SQL >> syntax in Spark SQL? >> >> Nick >> >> >> ------ >> View this message in context: Supported SQL syntax in Spark SQL >> <http://apache-spark-user-list.1001560.n3.na

Re: Supported SQL syntax in Spark SQL

2014-07-13 Thread Nicholas Chammas
For example, are LIKE 'string%' queries supported? Trying one on 1.0.1 yields java.lang.ExceptionInInitializerError. Nick ​ On Sat, Jul 12, 2014 at 10:16 PM, Nick Chammas wrote: > Is there a place where we can find an up-to-date list of supported SQL > syntax in Spa

Supported SQL syntax in Spark SQL

2014-07-12 Thread Nick Chammas
Is there a place where we can find an up-to-date list of supported SQL syntax in Spark SQL? Nick -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Supported-SQL-syntax-in-Spark-SQL-tp9538.html Sent from the Apache Spark User List mailing list archive at