How to type cast an Array as empty String array

Question

I can type cast NULL as a string. How can I type cast an empty array as an empty array of strings? I need to solve it inside the SQL query. The following snippet throws a ValueError: Some of types cannot be determined after inferring

df = spark.sql("select Array()").collect()

display(df)

hecvd · Accepted Answer · 2022-12-12 16:22:47Z

1

I only found a somewhat roundabout way of doing this only with SQL:

select from_json("[]", "array<string>")

answered Dec 12, 2022 at 16:22

hecvd

6681 gold badge8 silver badges24 bronze badges

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

Comments

Anjaneya Tripathi · Accepted Answer · 2022-07-07 10:39:09Z

-1

I think just keeping quotes should have empty string array

df = spark.sql("select array('')").collect()

display(df)

answered Jul 7, 2022 at 10:39

Anjaneya Tripathi

1,5091 gold badge8 silver badges10 bronze badges

1 Comment

Ronnis Over a year ago

This gives an array with one element (an empty string). I want an empty array that is typed as an array of strings

Collectives™ on Stack Overflow

How to type cast an Array as empty String array

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