赞
踩
使用spark job导数之后,job显示执行成功,去dbeaver查询表但是显示Syntax error or analysis exception: Union can only be performed on tables with the compatible column types.
- Query execution failed
-
- 原因:
- SQL 错误 [20000] [42000]: (SQLState=42000 Severity=20000) (Server=rf-sd0003.rayfay.io/192.168.106.96[2527] Thread=ThriftProcessor-3982) Syntax error or analysis exception: Union can only be performed on tables with the compatible column types. TimestampType <> DecimalType(38,0) at the first column of the second table;;
- 'Union
- :- Project [id#13361, name#13362, creat_time#13363, upt#13364, money#13365, _upt#13366, _SID#13379, timestamptomill(_UPT#13366) AS __T_UPT_T#13407L]
- : +- Project [id#13361, name#13362, creat_time#13363, upt#13364, money#13365, _upt#13366, 0 AS _SID#13379]
- : +- SubqueryAlias app_db_tset_t_talbe_test_lq
- : +- Relation[id#13361,name#13362,creat_time#13363,upt#13364,money#13365,_upt#13366] RowFormatRelation[app_db_tset.app_db_tset_t_talbe_test_lq]
- +- Filter (1 = 1)
- +- Project [_upt#13387, money#13388, upt#13389, creat_time#13390, name#13391, id#13392, _SID#13399, timestamptomill(_UPT#13387) AS __T_UPT_T#13416L]
- +- Project [_upt#13387, money#13388, upt#13389, creat_time#13390, name#13391, id#13392, 1 AS _SID#13399]
- +- Relation[_upt#13387,money#13388,upt#13389,creat_time#13390,name#13391,id#13392] parquet
- <?xml version="1.0" encoding="UTF-8"?>
- <daas-model xmlns="http://daas-model.rayfay.cn/pipline/job/"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xsi:schemaLocation="http://daas-model.rayfay.cn/pipline/job/ http://daas-model.rayfay.cn/pipline/job/daas-model.xsd">
- <domain viural="true">
- <sources>
- <source view="source_DF" provider="csv">
- <options>
- <option key="pat
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。