- 1106 Views
- 2 replies
- 0 kudos
Is there anything on Databricks to help read PDF (payment invoices and receipts for example) and convert it to structured data?
- 1106 Views
- 2 replies
- 0 kudos
Latest Reply
Thanks! Converting PDF format is sometimes a difficult task as not all converters provide accuracy. I want to share with you one interesting tool I recently discovered that can make your work even more efficient. I recently came across an amazing onl...
1 More Replies
by
elgeo
• Valued Contributor II
- 3888 Views
- 2 replies
- 0 kudos
Hello. Is there a way in Databricks sql to convert a date to integer? In Db2, there is days function DAYS - IBM Documentation .For example '2023-03-01' is converted to 738580 value.Thank you in advance
- 3888 Views
- 2 replies
- 0 kudos
Latest Reply
TRy this:CREATE OR REPLACE FUNCTION days(dt DATE) RETURN unix_date(dt) - unix_date(DATE'0001-01-01') + 1;SELECT current_date, days(current_date); 2023-03-09 738588I verified on Db2 for LUW and it matches up.
1 More Replies
by
Kavin
• New Contributor II
- 957 Views
- 2 replies
- 2 kudos
Im a newbie to Databricks, I need to convert the data sets into JSON. i tried bth FOR JSON AUTO AND FOR JSON PATH, However im getting an issue - [PARSE_SYNTAX_ERROR] Syntax error at or near 'json'line My Query works fine without FOR JSON AUTO AND FOR...
- 957 Views
- 2 replies
- 2 kudos
Latest Reply
Hi @Kavin Natarajan​, We haven’t heard from you since the last response from @Debayan Mukherjee​​, and I was checking back to see if their suggestions helped you. Or else, If you have any solution, please share it with the community, as it can be hel...
1 More Replies
by
Jeff1
• Contributor II
- 2375 Views
- 4 replies
- 4 kudos
I continues to receive a parsing error when attempting to convert lat/long data to a geohash in data bricks . I've tried two coding methods in R and get the same error.library(geohashTools)Method #1my_tbl$geo_hash <- gh_encode(my_tbl$Latitude, my_tbl...
- 2375 Views
- 4 replies
- 4 kudos
Latest Reply
The problem was I was trying to run the gh_encode function on a Spark dataframe. I needed to collect the date into a R dataframe then run the function.
3 More Replies
by
spaz
• New Contributor II
- 1686 Views
- 5 replies
- 1 kudos
What is the easiest way to convert a table to a nested JSON?
- 1686 Views
- 5 replies
- 1 kudos
Latest Reply
@Sergio Paz​ - How's it going? Are you able to give us more information?
4 More Replies