Databricks Community

pepevo · 02-10-2020

I need to convert column type from decimal to date in sparksql when the format is not yyyy-mm-dd? A table contains column data declared as decimal (38,0) and data is in yyyymmdd format and I am unable to run sql queries on it in databrick notebook. ...

pepevo · 06-10-2020

Cobly, I know how to download a csv from a notebook via using a down arrow indicator on the bottom of the query. But I want to know how to create a script to pull the csv directly send out email and/or store directly in the indicate folder like orac...

pepevo · 06-03-2020

I have asked this question before since the link is broken. How do I export sql query into csv and send email out. Also, how can I select a billion records in csv. Databrick allows to export only max a million record but we have 1.5 billion

pepevo · 02-18-2020

yes, would you please provide more in detail on this? the link is not working (HTTP ERROR: 404" thank you

pepevo · 02-13-2020

thank you Tom. I made it work already.

pepevo · 02-12-2020

I have been tried many data functions to compare with sysdate and no luck even with 10 records in a table. Is there a way I can compare sysdate as decimal? even using, unix_timestamp, from_unixtime and none of them work. Why scala sql is not friendl...

Databricks Community

User Stats

User Activity

How to convert column type from decimal to date in sparksql

Re: How can I export a result of a SQL query from a databricks notebook?

Re: How can I export a result of a SQL query from a databricks notebook?

Re: How can I export a result of a SQL query from a databricks notebook?

Re: How to convert column type from decimal to date in sparksql

Re: How to convert column type from decimal to date in sparksql