在Databricks中创建表格。

huangapple go评论56阅读模式
英文:

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.

huangapple
  • 本文由 发表于 2023年6月22日 01:02:34
  • 转载请务必保留本文链接:https://go.coder-hub.com/76525615.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定