Thanks also below code helped
df.select(concat_ws(",",$"result.accountID") as "accountID")
On Tue, Mar 14, 2017 at 5:35 AM, Felix Cheung <[email protected]>
wrote:
> Explode?
>
> https://spark.apache.org/docs/latest/api/python/pyspark.sql.
> html?highlight=explode#pyspark.sql.functions.explode
>
>
> For Spark questions like this, try stackoverflow
>
> spark.apache.org/community.html
>
>
>
>
> ------------------------------
> *From:* Suresh Ayyavoo <[email protected]>
> *Sent:* Sunday, March 12, 2017 8:53:52 PM
> *To:* [email protected]
> *Subject:* How can i convert below DataFrame array<string> to string
>
> Hi All,
>
> How can i convert below DataFrame [accountID: array<string>,
> completed_at: array<string>, created_at: array<string>] to
> [accountID: string, completed_at: string, created_at: string]
>
> root
>
> |-- accountID: array (nullable = true)
>
> | |-- element: string (containsNull = true)
>
> |-- completed_at: array (nullable = true)
>
> | |-- element: string (containsNull = true)
>
> |-- created_at: array (nullable = true)
>
> | |-- element: string (containsNull = true)
>
>
> root
> |-- accountID: string (containsNull =true)
> |-- completed_at: string (containsNull =true)
> |--create_at : string (containsNull =true)
>
>
> Thanks
>
>
>
--
Suresh Ayyavoo
Solution Architect / R&D Lead
iAPPS Pte. Ltd.
3 Fusionopolis Way, Symbiosis #13-25 S(138633)
[O] 64631795 [F] 6778 5300 [M] 91540224
Website: www.iappsasia.com
Facebook: www.facebook.com/iappsasia
Youtube: www.youtube.com/user/iAPPSasia
