spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chunpeng Wang <cpwang...@gmail.com>
Subject Re: Spark SQL doesn't produce output while hive does
Date Mon, 04 Mar 2019 14:34:08 GMT
check the data schema especially for user_mobile

On Mon, Mar 4, 2019 at 1:18 AM mayangyang02 <mayangyang02@imdada.cn> wrote:

> Hi,
>
> We have a sql. When we ran it with Hive, it produced the result normally.
> But when we ran it with Spark, id didn’t produce any output.
>
> We found that what caused the problem is the where statement. The where
> statement is as following:
>
> where 1=1 and user_id <> '未知' and user_mobile <> -99
> Can anyone please tell what’s the problem and how can we avoid this
> problem?
>
> Thans a lot!
>
> Best
>     Regards
>
> 马阳阳
> Phone: 15021906687
> E-mail: mayangyang02@imdada.cn
> Address: 上海市杨浦区杨树浦路1088号东方渔人码头20楼
>

Mime
View raw message