, 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
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
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