Forum Discussion
Helper ICopy Data Lakehouse
I need to modify the field of a table in my lakehouse (I have it in text and I want to change it to FLOAT).
To do so, I thought of creating a new table inserting the values in the table:
thank you very much! in the end I solved it in another way, I had in one of the fields text and I had a problem with the null to convert them in Float. In the end I put in the query a try cast and it was solved.
3 Replies
- AndyDDC
Most Valuable Professional
Hi jesuslogmein you could use CTAS in a single statement and add/modify columns as appropriate.
eg in the query below, in the SELECT, select the relevant columns, and cast to other types
%%sql
CREATE TABLE IF NOT EXISTS new_table
USING DELTA AS
SELECT <columns>
FROM source_table 
jesuslogmeinthank you very much! in the end I solved it in another way, I had in one of the fields text and I had a problem with the null to convert them in Float. In the end I put in the query a try cast and it was solved.
