Databricks

Wassim · 12-14-2022

I have my exam scheduled for next month ,but I am going to cancel it( i have regestered this exam using a voucher, In future i may schedule other exam ,would i be able to utilize that voucher that i used for the exam am gonna cancel? I mean could tha...

Wassim · 12-15-2022

and pyspark for the same- df = spark.table("orders") df = df.withColumn("items", from_json(df["item_order_details"], "itemid STRING, itemname STRING")) df = df.select("order_id", "items.itemid", "items.itemname")

Wassim · 12-15-2022

Hi, you got to extract itemID and itemName from single column item_order_detail - you can make use of from_json function for that. I hope following code helps, SELECT order_id, from_json(item_order_details, 'itemid STRING, itemname STRING') as items ...

Wassim · 12-15-2022

As you are talking about different schemas ,perhaps schemaevolutionmode, infercolumntypes, or schemahints may help?? Check out this- 32min onward - https://youtu.be/8a38Fv9cpd8 Hope it helps, do let know how you solve it if you can.

Wassim · 12-15-2022

Thanks :)

Databricks

User Stats

User Activity

Cancelling the exam- need to know whats policy if had scheduled the exam with voucher

Re: split character string in cell with sql

Re: split character string in cell with sql

Re: AutoLoader - process multiple files

Re: Cancelling the exam- need to know whats policy if had scheduled the exam with voucher