Error when trying to get the data from Hive Materialized View
Hi Team , We are not getting any error when retrieving the data from hive table in PYSPARK , but getting the error ( Scala.matcherror MATERIALIZED_VIEW ( of class org.Apache.Hadoop.hive.metastore.TableType ) . Please let me know resolution for this ? Thanks
Spark join produce duplicate rows in resultset
Hello all: I am using spark sql to join two tables. To my surprise I am getting redundant rows. What could be the cause. select rev.* from rev inner join customer c on rev.custumer_id =c.id inner join product p rev.sys = p.sys rev.prin = p.prin rev.scode= p.bcode left join item I on rev.sys = i.sys rev.custumer_id = I.custumer_id rev. scode = I.scode where rev.custumer_id = '123456789' The first part of the code brings one row select rev.* from rev inner join customer c on rev.custumer_id =c.id inner join product p rev.sys = p.sys rev.prin = p.prin rev.scode= p.bcode The item has two rows which have common attributes and the* final join should result in 2 rows. But I am seeing 4 rows instead.* left join item I on rev.sys = i.sys rev.custumer_id = I.custumer_id rev. scode = I.scode Regards, Meena