DROP TABLE IF EXISTS spark_21646_2;
CREATE TABLE spark_21646_2(c1 DATE) STORED AS TEXTFILE;
insert into table spark_21646_2 values('2017-07-21');
insert into table spark_21646_2 values('2017-09-14');
SELECT * FROM spark_21646_2 WHERE c1 > '2017-8-1';
DROP TABLE spark_21646_2;