Re: Re: spark table to hive table

2014-07-01 Thread Michael Armbrust
We do support LIKE and RLIKE, though up until recently the keywords were incorrectly case sensitive. On Tue, Jul 1, 2014 at 11:16 AM, John Omernik wrote: > Michael - > > Does Spark SQL support rlike and like yet

Re: Re: spark table to hive table

2014-07-01 Thread John Omernik
Michael - Does Spark SQL support rlike and like yet? I am running into that same error with a basic select * from table where field like '%foo%' using the hql() funciton. Thanks On Wed, May 28, 2014 at 2:22 PM, Michael Armbrust wrote: > On Tue, May 27, 2014 at 6:08 PM, JaeBoo Jung > wrote:

Re: Re: spark table to hive table

2014-05-28 Thread Michael Armbrust
On Tue, May 27, 2014 at 6:08 PM, JaeBoo Jung wrote: > I already tried HiveContext as well as SqlContext. > > But it seems that Spark's HiveContext is not completely same as Apache > Hive. > > For example, SQL like 'SELECT RANK() OVER(ORDER BY VAL1 ASC) FROM TEST > LIMIT 10' works fine in Apache

Re: Re: spark table to hive table

2014-05-27 Thread JaeBoo Jung
k.deploy.SparkSubmit.main(SparkSubmit.scala)     --- Original Message --- Sender : John Omernik Date : 2014-05-27 19:28 (GMT+09:00) Title : Re: spark table to hive table   Did you try the Hive Context? Look under Hi

Re: spark table to hive table

2014-05-27 Thread John Omernik
Did you try the Hive Context? Look under Hive Support here: http://people.apache.org/~pwendell/catalyst-docs/sql-programming-guide.html On Tue, May 27, 2014 at 2:09 AM, 정재부 wrote: > Hi all, > > > > I'm trying to compare functions available in Spark1.0 hql to original > HiveQL. > > But, when