Re: Issues with constants in Spark HiveQL queries

2015-05-22 Thread Skanda
matter(I run spark1.2 with Hive12 profile) but that would be >>> a good test. The last version I tried for you was a cdh4.2 spark1.2 >>> prebuilt without pointing to an external hive install(in fact I tried it on >>> a machine w/ no other hadoop/hive jars). So download, unzip an

Re: Issues with constants in Spark HiveQL queries

2015-05-22 Thread Skanda
ean >> there was indeed token Plus in your string? If you remove that token what >> stacktrace do you get? >> >> >> Sent on the new Sprint Network from my Samsung Galaxy S®4. >> >> >> Original message ---- >> From: Pala M Muthaia >&

Re: Issues with constants in Spark HiveQL queries

2015-01-28 Thread Pala M Muthaia
en what > stacktrace do you get? > > > Sent on the new Sprint Network from my Samsung Galaxy S®4. > > > Original message > From: Pala M Muthaia > Date:01/19/2015 8:26 PM (GMT-05:00) > To: Yana Kadiyska > Cc: "Cheng, Hao" ,user@spark.apache.o

Re: Issues with constants in Spark HiveQL queries

2015-01-20 Thread yana
y S®4. Original message From: Pala M Muthaia Date:01/19/2015 8:26 PM (GMT-05:00) To: Yana Kadiyska Cc: "Cheng, Hao" ,user@spark.apache.org Subject: Re: Issues with constants in Spark HiveQL queries Yes we tried the master branch (sometime last week) and there was

Re: Issues with constants in Spark HiveQL queries

2015-01-19 Thread Pala M Muthaia
ole >> >> scala> sql(“SELECT user_id FROM actions where >> conversion_aciton_id=20141210”) >> >> >> >> >> >> *From:* Yana Kadiyska [mailto:yana.kadiy...@gmail.com] >> *Sent:* Wednesday, January 14, 2015 11:12 PM >> *To:* Pala M Muthai

Re: Issues with constants in Spark HiveQL queries

2015-01-14 Thread Yana Kadiyska
p-2.3.0 –Phadoop-2.3 –Phive –Phive-0.12.0 hive/console > > scala> sql(“SELECT user_id FROM actions where > conversion_aciton_id=20141210”) > > > > > > *From:* Yana Kadiyska [mailto:yana.kadiy...@gmail.com] > *Sent:* Wednesday, January 14, 2015 11:12 PM > *To:* Pa

RE: Issues with constants in Spark HiveQL queries

2015-01-14 Thread Cheng, Hao
: user@spark.apache.org Subject: Re: Issues with constants in Spark HiveQL queries Just a guess but what is the type of conversion_aciton_id? I do queries over an epoch all the time with no issues(where epoch's type is bigint). You can see the source here https://github.com/apache/spark/blob/v1.2.0/s

Re: Issues with constants in Spark HiveQL queries

2015-01-14 Thread Pala M Muthaia
conversion_action_id is a int. We also tried a string column predicate with single quotes string value and hit the same error stack. On Wed, Jan 14, 2015 at 7:11 AM, Yana Kadiyska wrote: > Just a guess but what is the type of conversion_aciton_id? I do queries > over an epoch all the time with n

Re: Issues with constants in Spark HiveQL queries

2015-01-14 Thread Yana Kadiyska
Just a guess but what is the type of conversion_aciton_id? I do queries over an epoch all the time with no issues(where epoch's type is bigint). You can see the source here https://github.com/apache/spark/blob/v1.2.0/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveQl.scala -- not sure what AS

Issues with constants in Spark HiveQL queries

2015-01-13 Thread Pala M Muthaia
Hi, We are testing Spark SQL-Hive QL, on Spark 1.2.0. We have run some simple queries successfully, but we hit the following issue whenever we attempt to use a constant in the query predicate. It seems like an issue with parsing constant. Query: SELECT user_id FROM actions where conversion_acito