Recursive view error while using spark 3.2.0 version

[manasa]

This happens while creating temp view using below code block

latest_data.createOrReplaceGlobalTempView("e_test")

ideally this command should replace the view if e_test already exists instead it is throwing

"Recursive view `global_temp`.`e_test` detected (cycle: `global_temp`.`e_test` -> `global_temp`.`e_test`)" error..Can anyone help me with this

[-werners-]

does it work when you don't use a global view?

[manasa]

Nope.Same error

[User16763506477]

Hi @Manasa Kalluri​  Is "latest_data" referring to "e_test".

How latest_data is created ?

[manasa]

Hi @Gaurav Rupnar​ ,

latest_data=spark.read.format('csv').option("header","true").option("multiLine","true").load(file_path)

latest_data is a simple dataframe of a small csv file

[shan_chandra · Accepted solution]

Hi, @Manasa​, could you please check SPARK-38318 and use Spark 3.1.2, Spark 3.2.2, or Spark 3.3.0 to allow cyclic reference?

[jose_gonzalez]

Hi @Manasa Kalluri​ ,

Just a friendly follow-up. Do you still need help with this issue?

[manasa]

No, it was resolved.Thanks!