Hi Alessandro
Could you specify which query were you able to run successfully?
1. sqlContext.sql(SELECT * FROM Logs as l where l.timestamp = '2012-10-08
16:10:36' ).collect
OR
2. sqlContext.sql(SELECT * FROM Logs as l where cast(l.timestamp as string)
= '2012-10-08 16:10:36.0').collect
I am
Thank you Alessandro :)
On Tue, Mar 3, 2015 at 10:03 AM, whitebread [via Apache Spark User List]
ml-node+s1001560n2188...@n3.nabble.com wrote:
Anu,
1) I defined my class Header as it follows:
case class Header(timestamp: java.sql.Timestamp, c_ip: String,
cs_username: String, s_ip: String,
Can you please post how did you overcome this issue.
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/SparkSQL-Timestamp-query-failure-tp19502p21868.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.
Hi,
I think you can try
cast(l.timestamp as string)='2012-10-08 16:10:36.0'
Thanks,
Daoyuan
-Original Message-
From: whitebread [mailto:ale.panebia...@me.com]
Sent: Sunday, November 23, 2014 12:11 AM
To: u...@spark.incubator.apache.org
Subject: Re: SparkSQL Timestamp query failure
: SparkSQL Timestamp query failure
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
” is the keyword of data type in
Hive/Spark SQL.)
From: Alessandro Panebianco [mailto:ale.panebia...@me.com]
Sent: Monday, November 24, 2014 11:12 AM
To: Wang, Daoyuan
Cc: u...@spark.incubator.apache.org
Subject: Re: SparkSQL Timestamp query failure
Hey Daoyuan,
following your suggestion I obtain
=19613i=1
Subject: Re: SparkSQL Timestamp query failure
Hey Daoyuan,
following your suggestion I obtain the same result as when I do:
where l.timestamp = '2012-10-08 16:10:36.0’
what happens using either your suggestion or simply using single quotes as I
just typed
What about
sqlContext.sql(SELECT * FROM Logs as l where l.timestamp=*'2012-10-08
16:10:36.0'*).collect
You might need to quote the timestamp it looks like.
Thanks
Best Regards
On Sat, Nov 22, 2014 at 12:09 AM, whitebread ale.panebia...@me.com wrote:
Hi all,
I put some log files into sql
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,