Re: Spark SQL 1.6.1 issue

2016-08-18 Thread Teik Hooi Beh
Hi, does the version have to be the same down to the minor version, e.g.
1.6.1 and 1.6.2 will give this issue

On Thu, Aug 18, 2016 at 6:27 PM, Olivier Girardot <
o.girar...@lateral-thoughts.com> wrote:

> your executors/driver must not have the multiple versions of spark in
> classpath, it may come from the cassandra connector check the pom
> dependencies of the version you fetched and if it's compatible with your
> spark version.
>
>
>
> On Thu, Aug 18, 2016 6:05 AM, thbeh th...@thbeh.com wrote:
>
>> Running the query below I have been hitting - local class incompatible
>>
>> exception, anyone know the cause?
>>
>>
>> val rdd = csc.cassandraSql("""select *, concat('Q', d_qoy) as qoy from
>>
>> store_sales join date_dim on ss_sold_date_sk = d_date_sk join item on
>>
>> ss_item_sk =
>>
>> i_item_sk""").groupBy("i_category").pivot("qoy").agg(
>> round(sum("ss_sales_price")/100,2))
>>
>>
>> The source data is from TPCDS test data and I am running in Zeppelin.
>>
>>
>>
>> /INFO [2016-08-18 03:15:58,429] ({task-result-getter-2}
>>
>> Logging.scala[logInfo]:58) - Lost task 3.0 in stage 3.0 (TID 52) on
>> executor
>>
>> ceph5.example.my: java.io.InvalidClassException
>>
>> (org.apache.spark.sql.catalyst.expressions.Literal; local class
>>
>> incompatible: stream classdesc serialVersionUID = 3305180847846277455,
>> local
>>
>> class serialVersionUID = -4259705229845269663) [duplicate 1]
>>
>> INFO [2016-08-18 03:15:58,429] ({task-result-getter-3}
>>
>> Logging.scala[logInfo]:58) - Lost task 2.0 in stage 3.0 (TID 51) on
>> executor
>>
>> ceph5.example.my: java.io.InvalidClassException
>>
>> (org.apache.spark.sql.catalyst.expressions.Literal; local class
>>
>> incompatible: stream classdesc serialVersionUID = 3305180847846277455,
>> local
>>
>> class serialVersionUID = -4259705229845269663) [duplicate 2]
>>
>> INFO [2016-08-18 03:15:58,430] ({task-result-getter-3}
>>
>> Logging.scala[logInfo]:58) - Lost task 6.0 in stage 3.0 (TID 55) on
>> executor
>>
>> ceph5.example.my: java.io.InvalidClassException
>>
>> (org.apache.spark.sql.catalyst.expressions.Literal; local class
>>
>> incompatible: stream classdesc serialVersionUID = 3305180847846277455,
>> local
>>
>> class serialVersionUID = -4259705229845269663) [duplicate 3]/
>>
>>
>> Thanks
>>
>>
>>
>>
>> --
>>
>> View this message in context: http://apache-spark-user-list.
>> 1001560.n3.nabble.com/Spark-SQL-1-6-1-issue-tp27554.html
>>
>> Sent from the Apache Spark User List mailing list archive at Nabble.com.
>>
>>
>> -
>>
>> To unsubscribe e-mail: user-unsubscr...@spark.apache.org
>>
>>
>>
>>
>
> *Olivier Girardot* | AssociƩ
> o.girar...@lateral-thoughts.com
> +33 6 24 09 17 94
>


Re: Spark SQL 1.6.1 issue

2016-08-18 Thread Olivier Girardot
your executors/driver must not have the multiple versions of spark in classpath,
it may come from the cassandra connector check the pom dependencies of the
version you fetched and if it's compatible with your spark version.





On Thu, Aug 18, 2016 6:05 AM, thbeh th...@thbeh.com wrote:
Running the query below I have been hitting - local class incompatible

exception, anyone know the cause?




val rdd = csc.cassandraSql("""select *, concat('Q', d_qoy) as qoy from

store_sales join date_dim on ss_sold_date_sk = d_date_sk join item on

ss_item_sk =


i_item_sk""").groupBy("i_category").pivot("qoy").agg(round(sum("ss_sales_price")/100,2))




The source data is from TPCDS test data and I am running in Zeppelin.







/INFO [2016-08-18 03:15:58,429] ({task-result-getter-2}

Logging.scala[logInfo]:58) - Lost task 3.0 in stage 3.0 (TID 52) on executor

ceph5.example.my: java.io.InvalidClassException

(org.apache.spark.sql.catalyst.expressions.Literal; local class

incompatible: stream classdesc serialVersionUID = 3305180847846277455, local

class serialVersionUID = -4259705229845269663) [duplicate 1]

INFO [2016-08-18 03:15:58,429] ({task-result-getter-3}

Logging.scala[logInfo]:58) - Lost task 2.0 in stage 3.0 (TID 51) on executor

ceph5.example.my: java.io.InvalidClassException

(org.apache.spark.sql.catalyst.expressions.Literal; local class

incompatible: stream classdesc serialVersionUID = 3305180847846277455, local

class serialVersionUID = -4259705229845269663) [duplicate 2]

INFO [2016-08-18 03:15:58,430] ({task-result-getter-3}

Logging.scala[logInfo]:58) - Lost task 6.0 in stage 3.0 (TID 55) on executor

ceph5.example.my: java.io.InvalidClassException

(org.apache.spark.sql.catalyst.expressions.Literal; local class

incompatible: stream classdesc serialVersionUID = 3305180847846277455, local

class serialVersionUID = -4259705229845269663) [duplicate 3]/




Thanks










--

View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/Spark-SQL-1-6-1-issue-tp27554.html

Sent from the Apache Spark User List mailing list archive at Nabble.com.




-

To unsubscribe e-mail: user-unsubscr...@spark.apache.org









Olivier Girardot | AssociƩ
o.girar...@lateral-thoughts.com
+33 6 24 09 17 94

Spark SQL 1.6.1 issue

2016-08-17 Thread thbeh
Running the query below I have been hitting - local class incompatible
exception, anyone know the cause?

val rdd = csc.cassandraSql("""select *, concat('Q', d_qoy) as qoy from
store_sales join date_dim on ss_sold_date_sk = d_date_sk join item on
ss_item_sk =
i_item_sk""").groupBy("i_category").pivot("qoy").agg(round(sum("ss_sales_price")/100,2))

The source data is from TPCDS test data and I am running in Zeppelin.


/INFO [2016-08-18 03:15:58,429] ({task-result-getter-2}
Logging.scala[logInfo]:58) - Lost task 3.0 in stage 3.0 (TID 52) on executor
ceph5.example.my: java.io.InvalidClassException
(org.apache.spark.sql.catalyst.expressions.Literal; local class
incompatible: stream classdesc serialVersionUID = 3305180847846277455, local
class serialVersionUID = -4259705229845269663) [duplicate 1]
 INFO [2016-08-18 03:15:58,429] ({task-result-getter-3}
Logging.scala[logInfo]:58) - Lost task 2.0 in stage 3.0 (TID 51) on executor
ceph5.example.my: java.io.InvalidClassException
(org.apache.spark.sql.catalyst.expressions.Literal; local class
incompatible: stream classdesc serialVersionUID = 3305180847846277455, local
class serialVersionUID = -4259705229845269663) [duplicate 2]
 INFO [2016-08-18 03:15:58,430] ({task-result-getter-3}
Logging.scala[logInfo]:58) - Lost task 6.0 in stage 3.0 (TID 55) on executor
ceph5.example.my: java.io.InvalidClassException
(org.apache.spark.sql.catalyst.expressions.Literal; local class
incompatible: stream classdesc serialVersionUID = 3305180847846277455, local
class serialVersionUID = -4259705229845269663) [duplicate 3]/

Thanks



--
View this message in context: 
http://apache-spark-user-list.1001560.n3.nabble.com/Spark-SQL-1-6-1-issue-tp27554.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.

-
To unsubscribe e-mail: user-unsubscr...@spark.apache.org