Re: Spark SQL doesn't produce output while hive does

2019-03-04 Thread Patrik Medvedev
Hi, Are you connecting in collocated mode or via jdbc? Could you give more details? Cheers, Patrick пн, 4 мар. 2019 г. в 08:18, mayangyang02 : > 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. > >

Re: Spark SQL doesn't produce output while hive does

2019-03-04 Thread Chunpeng Wang
check the data schema especially for user_mobile On Mon, Mar 4, 2019 at 1:18 AM mayangyang02 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

Spark SQL doesn't produce output while hive does

2019-03-03 Thread mayangyang02
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