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

Array to columns ( or rows )

I have a DB table which stores ( as a string ) values in an array.   I don't like it, but I don't have any say in the matter nor do I have access to the DB to rework it there.What I'd like to do is query the table ( e.g. select ID, Name, ArrayField f...

RADSr by Captain
  • 590 Views
  • 1 replies
  • 0 kudos

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....