Databricks Community

dulu · 12-15-2022

I have the following input: I am looking for a way to split the characters in the item_order_detail column into 2 columns itemID and itemName. As below output table uses SQL function in databricks with spark_sql version 3.2.1.Can someone suggest a so...

dulu · 12-09-2022

I am using spark_sql version 3.2.1. Is there a function that can replacesplit_part,json_extract_scalarare not?

dulu · 12-03-2022

I need to count the number of campaigns per day based on the start and end dates of the campaignsInput Table: Out needed (result):How do I need to write the SQL command in databricks to get the above result? thanks all

dulu · 12-16-2022

Hi @Wasim Inamdar I tried it and have error bellow:SELECT order_id, from_json(item_order_details, 'itemid STRING, itemname STRING') as items FROM ordersresult andSELECT order_id, items.itemid, items.itemname FROM orders LATERAL VIEW from_json(item_...

dulu · 12-15-2022

Thanks @Ankush Jadhao for answer, I tried but only returns the first result in the cell. They seem to only take the first character with the correct result. I need out put like the table below.I have the following input: I am looking for a way to s...

Databricks Community

User Stats

User Activity

split character string in cell with sql

Is there a function similar to split_part, json_extract_scalar?

How to count the number of campaigns per day based on the start and end dates of the campaigns in SQL Spark Databrick

Re: split character string in cell with sql

Re: Is there a function similar to split_part, json_extract_scalar?