Hi All,
hive> create table UK ( a decimal(10,2)) ;
hive> create table IN ( a decimal(10,5)) ;
hive> create view T as select a from UK union all select a from IN ;
above all statements executes successfully in Hive and return results when select statement is executed. However, when select statement executed from python using pyspark I get error saying "Cannot up cast a from decimal(10,2) to decimal(10,5)".
Ideally view looks for same datatype and also this work fine in its source data db(hive). This has become a show stopper and Cculd you please help me with a possible solution to fix this in pyspark please ?
Thanks in advance,
Anand.
#pyspark