Data & Schema Discussions
The dataverse runs deep. Get help with connections, loading, schema development, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Failed to create MV

Ive been trying to create an MV. Im running the query in edit in notebook where it is giving result. But when i try to add it to MV it is failing giving below errorTransformation error [Error can not infer schema from empty dataset ValueError : can n...

Materialized Views with Scala

I am trying to refactor some tables that were previously using pyspark to use scala. However whenever I try to read in my data I am met with an error that states "table or view not found"My code looks something like this: import org.apache.spark.sql....

Resolved! Materialized views - Query ends with _X

Hi,I'm trying to write a query in MV (Spark SQL) which excludes the items ending with "_X" I understand underscore ("_") is single character wildcard in SQL and should be addressed as '%[_]x' or '%\_x' which will include the Underscore (_).  But it s...