Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Pig >> mail # user >> CONCAT(null, "something") == NULL ?


+
Yang 2012-11-02, 22:09
Copy link to this message
-
Re: CONCAT(null, "something") == NULL ?
To give some context, the null semantics in Pig follow SQL's.  In SQL, null is viral, so any operation with null results in null.  The idea is that null means unknown, not empty.  So concat('x', unknown) = unknown.

Alan.

On Nov 2, 2012, at 3:09 PM, Yang wrote:

> looks a more intuitive result should be "something" , right?
>
> but on my system it gave null
+
Cheolsoo Park 2012-11-02, 22:40
+
Yang 2012-11-05, 17:15
+
Alan Gates 2012-11-05, 16:16
+
Jonathan Coveney 2012-11-05, 18:01
+
Cheolsoo Park 2012-11-02, 22:14