Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Spark Tables CREATE OR REPLACE not working

When running this code    %%sql CREATE OR REPLACE TABLE sample (     integer INT,     string VARCHAR(50) )   I get the error message "Error: REPLACE TABLE is only supported with v2 tables."...
data engineering
Fundamentals
HimanshuS-msft's avatar
HimanshuS-msft
Microsoft Employee
2 years ago

Hello Anonymous 
Thanks for using the Fabric community.
I have a repro and let me reach out to the internal team to get more help on this .


Error: REPLACE TABLE is only supported with v2 tables. org.apache.spark.sql.errors.QueryCompilationErrors$.operationOnlySupportedWithV2TableError(QueryCompilationErrors.scala:506) org.apache.spark.sql.catalyst.analysis.ResolveSessionCatalog$$anonfun$apply$1.applyOrElse(ResolveSessionCatalog.scala:189)

Thanks
HImanshu