Re: Extract hour from Timestamp in Spark SQL

2015-02-16 Thread Wush Wu
...@bridgewell.com] > *Sent:* Thursday, February 12, 2015 2:24 PM > *To:* u...@spark.incubator.apache.org > *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 Hiv

RE: Extract hour from Timestamp in Spark SQL

2015-02-15 Thread Cheng, Hao
Are you using the SQLContext? I think the HiveContext is recommended. Cheng Hao From: Wush Wu [mailto:w...@bridgewell.com] Sent: Thursday, February 12, 2015 2:24 PM To: u...@spark.incubator.apache.org Subject: Extract hour from Timestamp in Spark SQL Dear all, I am new to Spark SQL and have no

Re: Extract hour from Timestamp in Spark SQL

2015-02-12 Thread Michael Armbrust
This looks like your executors aren't running a version of spark with hive support compiled in. On Feb 12, 2015 7:31 PM, "Wush Wu" wrote: > Dear Michael, > > After use the org.apache.spark.sql.hive.HiveContext, the Exception: > "java.util. > NoSuchElementException: key not found: hour" is gone du

Extract hour from Timestamp in Spark SQL

2015-02-11 Thread Wush Wu
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 abou