spark-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Du Li <l...@yahoo-inc.com.INVALID>
Subject Spark SQL use of alias in where clause
Date Thu, 25 Sep 2014 00:58:34 GMT
Hi,

The following query does not work in Shark nor in the new Spark SQLContext or HiveContext.
SELECT key, value, concat(key, value) as combined from src where combined like ’11%’;

The following tweak of syntax works fine although a bit ugly.
SELECT key, value, concat(key, value) as combined from src where concat(key,value) like ’11%’
order by combined;

Are you going to support alias in where clause soon?

Thanks,
Du

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message