spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Akhil Das <ak...@sigmoidanalytics.com>
Subject Re: hive timestamp column always returns null
Date Fri, 24 Oct 2014 07:01:50 GMT
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.samanta@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-unsubscribe@spark.apache.org
> For additional commands, e-mail: user-help@spark.apache.org
>
>

Mime
View raw message