在传统数据库中以下语句能正常运行
SELECT DISTINCT CAST('' AS VARCHAR(10)) AS A1
,CAST('' AS VARCHAR(91)) AS A2
,CAST('' AS VARCHAR(8)) AS A3
FROM A;
但是在Impala中,这段语句会报错。
原因是 第三个字段长度8小于前面的小字段长度10,将8改为10则能正常运行。
在传统数据库中以下语句能正常运行
SELECT DISTINCT CAST('' AS VARCHAR(10)) AS A1
,CAST('' AS VARCHAR(91)) AS A2
,CAST('' AS VARCHAR(8)) AS A3
FROM A;
但是在Impala中,这段语句会报错。
原因是 第三个字段长度8小于前面的小字段长度10,将8改为10则能正常运行。