Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-09-2024 09:35 AM
Hi @Retired_mod , thank you for your reply!
I realized that another main difference between nyc_taxi and nyc_taxi2 is that nyc_taxi created using the UI, is a managed table, whereas nyc_taxi2 created using the SQL command is an external table. The locations are also different, nyc_taxi is stored under "dbfs:/user/hive/warehouse/myschema.db/nyc_taxi"; nyc_taxi2 is stored under "
dbfs:/users/feirxu/nyc_taxi.csv". Could this be the reason for the error? If so, could you advise how to resolve this issue?
I checked the documentation, and it says "With the UI, you can only create external tables. (https://learn.microsoft.com/en-us/azure/databricks/archive/legacy/data-tab#--create-a-table)", why the table I created using the UI is a managed table, while the table created using the SQL commands is an external table?
Did I miss any part?
Thank you!
