You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@spark.apache.org by mayangyang02 <ma...@imdada.cn> on 2019/03/04 06:18:05 UTC

Spark SQL doesn't produce output while hive does

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楼