英文:
Create table in databricks
问题
我尝试使用以下代码在Databricks中创建表格:
USE CATALOG ${catalog};
CREATE SCHEMA IF NOT EXISTS ${personal.schema};
DROP TABLE IF EXISTS ${personal.schema}.${personal.source}_${personal.table};
CREATE TABLE IF NOT EXISTS ${personal.schema}.${personal.source}_${personal.table}
USING PARQUET
LOCATION 'abfss://${personal.schema}@${personal.storage_account_name}.dfs.core.windows.net/${personal.source}/${personal.table}/'
OPTIONS(recursiveFileLookup = true);
但我遇到了错误:输入路径URL与其他外部表格或卷重叠。
英文:
Im trying to create a table in databricks with this code:
USE CATALOG ${catalog};
CREATE SCHEMA IF NOT EXISTS ${personal.schema};
DROP TABLE IF EXISTS ${personal.schema}.${personal.source}_${personal.table};
CREATE TABLE IF NOT EXISTS ${personal.schema}.${personal.source}_${personal.table}
USING PARQUET
LOCATION 'abfss://${personal.schema}@${personal.storage_account_name}.dfs.core.windows.net/${personal.source}/${personal.table}/'
OPTIONS(recursiveFileLookup = true);
But i get the error: Input path url overlaps with other external tables or volumes
答案1
得分: 2
这个错误表示你可能已经有一个表或者Unity Catalog卷(处于预览状态),它们使用了相同的外部位置。您可以使用信息模式表(特别是tables
表)来检查哪些表可能与您的位置重叠。
英文:
This error says that you may already have table or Unity Catalog volume (in preview) that uses the same external location. You can use information schema tables (specifically the tables
table) to check what tables could be overlapping with your location.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论