Re: SparkSQL Timestamp query failure

2014-11-23 Thread whitebread
)='2012-10-08 16:10:36.0' Thanks, Daoyuan -Original Message- From: whitebread [[hidden email] x-msg://2/user/SendEmail.jtp?type=nodenode=19613i=3] Sent: Sunday, November 23, 2014 12:11 AM To: [hidden email] x-msg://2/user/SendEmail.jtp?type=nodenode=19613i=4 Subject: Re

Re: SparkSQL Timestamp query failure

2014-11-22 Thread whitebread
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,

SparkSQL Timestamp query failure

2014-11-21 Thread whitebread
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) |--