Spark getnewargs error ... Method or([class java.lang.String]) does not exist

Question

I am trying to add a column to DataFrame depending on whether column value is in another column as follow:

df = df.withColumn('new_column', when(df['color']=='blue' | df['color']=='green', 'A').otherwise('WD'))

after running the code I obtain the following error:

Py4JError: An error occurred while calling o59.or. Trace:
py4j.Py4JException: Method or([class java.lang.String]) does not exist
    at py4j.reflection.ReflectionEngine.getMethod(ReflectionEngine.java:318)
    at py4j.reflection.ReflectionEngine.getMethod(ReflectionEngine.java:326)
    at py4j.Gateway.invoke(Gateway.java:274)
    at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)
    at py4j.commands.CallCommand.execute(CallCommand.java:79)
    at py4j.GatewayConnection.run(GatewayConnection.java:214)
    at java.lang.Thread.run(Thread.java:748)

what shall I do to overcome this issue? I am using PySpark 2.3.0

Suresh · Accepted Answer · 2018-03-09 10:40:58Z

24

While using multiple conditions, each condition needs to be separated because of operator precedence.

df=df.withColumn('new_column',when((df['color']=='blue')|(df['color']=='green'),'A').otherwise('WD'))

answered Mar 9, 2018 at 10:40

Suresh

5,8802 gold badges27 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user13951299 · Accepted Answer · 2021-10-12 21:38:26Z

3

I discovered a similar problem with Py4JError: An error occurred while calling o166.and. Trace: and the logs pointed to this line of my code:

.when(df.line_item_line_item_type == 'Fee' & df.reservation_reservation_a_r_n != '', 0)

adding sets of parenthesis around the statements to each side of the "&" solved the problem, like so:

.when((df.line_item_line_item_type == 'Fee') & (df.reservation_reservation_a_r_n != ''), 0)

answered Oct 12, 2021 at 21:38

user13951299

1 Comment

Krzysztof Madejski Mar 4 at 10:46

A duplicate of Suresh's answer

Collectives™ on Stack Overflow

Spark getnewargs error ... Method or([class java.lang.String]) does not exist

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related