>
>
>
>
>
>
>
>
> On Nov 23, 2014, at 8:10 PM, Wang, Daoyuan <[hidden email]
> > wrote:
>
>
>
> Hi,
>
> I think you can try
> cast(l.timestamp as string)='2012-10-08 16:10:36.0'
>
> Thanks,
> Daoyuan
Thanks for your answer Akhil,
I have already tried that and the query actually doesn't fail but it doesn't
return anything either as it should.
Using single quotes I think it reads it as a string and not as a timestamp.
I don't know how to solve this. Any other hint by any chance?
Thanks,
Ale
Hi all,
I put some log files into sql tables through Spark and my schema looks like
this:
|-- timestamp: timestamp (nullable = true)
|-- c_ip: string (nullable = true)
|-- cs_username: string (nullable = true)
|-- s_ip: string (nullable = true)
|-- s_port: string (nullable = true)
|-- cs_me
