Re: TimeStamp selection with SparkSQL

2014-09-05 Thread Brad Miller
, neither of those SQL dialect supports Date, but Timestamp. Cheng Hao *From:* Benjamin Zaitlen [mailto:quasi...@gmail.com] *Sent:* Friday, September 05, 2014 5:37 AM *To:* user@spark.apache.org *Subject:* TimeStamp selection with SparkSQL I may have missed this but is it possible to select

Re: TimeStamp selection with SparkSQL

2014-09-05 Thread Brad Miller
Date, unfortunately, neither of those SQL dialect supports Date, but Timestamp. Cheng Hao *From:* Benjamin Zaitlen [mailto:quasi...@gmail.com] *Sent:* Friday, September 05, 2014 5:37 AM *To:* user@spark.apache.org *Subject:* TimeStamp selection with SparkSQL I may have missed

TimeStamp selection with SparkSQL

2014-09-04 Thread Benjamin Zaitlen
I may have missed this but is it possible to select on datetime in a SparkSQL query jan1 = sqlContext.sql(SELECT * FROM Stocks WHERE datetime = '2014-01-01') Additionally, is there a guide as to what SQL is valid? The guide says, Note that Spark SQL currently uses a very basic SQL parser It