spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cheng, Hao" <>
Subject RE: Extract hour from Timestamp in Spark SQL
Date Sun, 15 Feb 2015 02:42:43 GMT
Are you using the SQLContext? I think the HiveContext is recommended.

Cheng Hao

From: Wush Wu []
Sent: Thursday, February 12, 2015 2:24 PM
Subject: Extract hour from Timestamp in Spark SQL

Dear all,

I am new to Spark SQL and have no experience of Hive.
I tried to use the built-in Hive Function to extract the hour from timestamp in spark sql,
but got : "java.util.NoSuchElementException: key not found: hour"
How should I extract the hour from timestamp?
And I am very confusing about which functions I could use in Spark SQL. Is there any list
of available functions except

View raw message