User Profile
AdilH
Helper I
Joined 2 years ago
User Widgets
Contributions
Re: Cannot create delta table in lakehouse
Error message : "Py4JJavaError: An error occurred while calling o299.sql. : org.apache.spark.sql.AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Create database for "Lakehouse" is not permitted using Apache Spark in Microsoft Fabric.)"3.2KViews0likes0CommentsRe: Cannot create delta table in lakehouse
Script : from pyspark.sql.types import * from delta.tables import * DeltaTable.createIfNotExists(spark).tableName("test_2") \ .addColumn("start_ts",TimestampType()) \ .addColumn("end_ts",TimestampType()) \ .addColumn("last_update_ts",TimestampType()) \ .addColumn("column1",IntegerType()) \ .addColumn("column2",IntegerType()) \ .addColumn("column3",IntegerType()) \ .addColumn("column4",IntegerType()) \ .addColumn("column5",DateType()) \ .addColumn("column6",DateType()) \ .addColumn("column7",IntegerType()) \ .addColumn("column8",IntegerType()) \ .addColumn("column9",IntegerType()) \ .addColumn("column10",IntegerType()) \ .addColumn("column11",IntegerType()) \ .addColumn("column12",IntegerType()) \ .addColumn("action",StringType()) \ .partitionedBy("column1")\ .execute()3.2KViews0likes4CommentsRe: Cannot create delta table in lakehouse
Hi, I realize, also running just the select statement on the delta table results in the same error. Exact same query was working a day before. Support page shows no issues in West europe region. I am afraid the product doesnt seem to be stable even in GA.3.2KViews0likes0CommentsCannot create delta table in lakehouse
All, We have a fabric capacity in West-europe and since this morning we cannot create delta tables in lakehouse(existing) The error message is : "Create database for <<Lakehouse>> is not permitted using Apache Spark in Microsoft Fabric." This was working until yesterday(same script) Do you know if this a region issue? or am I missing something? Thanks!3.2KViews0likes12Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.