Try doing a *cat -v your_data | head -n3 *and make sure you are not having any ^M at the end of the lines. Also your 2,3 rows doens't contain any space in the data.
Thanks Best Regards On Thu, Oct 23, 2014 at 9:23 AM, tridib <tridib.sama...@live.com> wrote: > 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 > >
