Spark SQL for Data Engineering 6 : Difference between Managed table and External table

[@VinodKumar-lg3bu]

great content ,thanks for educating

[@TRRaveendra]

Thank you 🙏

[@priyankabaswani4614]

Great explanation

[@jaydeeppatidar4189]

Great content!

[@TRRaveendra]

Thank you

[@akashtripathi69]

Thank you for sharing the important concepts. I am also using the community edition but when a new cluster is created then I am not able to see any database in the "Data" tab. Rather it is throwing a message saying " Cluster is unavailable; select another cluster". What to do. Do you also faced this issue.

[@arshisiddique1612]

This episode could have been more better, i am still confused if we drop external table so we can create that table again, whatever table we drop we can create those table either it is managed or external, however my question is if we re create external table, so does it rollback dropped table data ?

[@prabhatgupta6415]

external table has the properties to read the data from the location. after the drop of external table if recreate it using the same location it will recreate it because data is still there. if u drop internal table u cant create it because data will also be lost.

[@joshuaodeyemi3098]

I am getting an error when I try to read the user/hive/warehouse/customers file with SQL. Here is the error I'm getting - Error in SQL statement: ParseException: no viable alternative at input 'delta.'/user/hive/warehouse/customers''(line 1, pos 20) == SQL == SELECT * FROM delta.'/user/hive/warehouse/customers' For perspective, I noticed in your video that the font colour of your path didn't turn blue when you added the single quotes. However, mine is. I can't move forward from here and I hate this.

[@TRRaveendra]

Dont use single quote Use acute acent symbol

[@furqanbaig2514]

can you share the dbc file link to practice

[@TRRaveendra]

Its available in video description

[@joyo2122]

pro