Hello Experts,
I created a table using spark-sql CLI. No Hive is installed. I am using
spark 1.1.0.

create table date_test(my_date timestamp)
row format delimited
fields terminated by ' '
lines terminated by '\n'
LOCATION '/user/hive/date_test';

The data file has following data:
2014-12-11 00:00:00
2013-11-11T00:00:00
2012-11-11T00:00:00Z

when I query using "select * from date_test" it returns:
NULL
NULL
NULL

Could you please help me to resolve this issue?

Thanks
Tridib



--
View this message in context: 
http://apache-spark-user-list.1001560.n3.nabble.com/hive-timestamp-column-always-returns-null-tp17079.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
For additional commands, e-mail: user-h...@spark.apache.org

Reply via email to