在hive查询SQL的时候连接两个表需要对应的列字符类型一至,还有列的个数也要一样,不一样就会报错如下,修改多余的列就ok.
ERROR operation.ExecuteStatement: Error operating EXECUTE_STATEMENT: org.apache.spark.sql.AnalysisException: Union can only be performed on tables with the same number of columns, but the first table has 7 columns and the second table has 6 columns;
'WithCTE