OR (U-SQL)

Article
03/30/2017

Summary

U-SQL’s logical OR operator performs a disjunction of two Boolean expressions and returns true if at least one of the two expression is true and returns false if both expressions are false. Unlike the equivalent C# || expression, OR will not preserve the execution order and will not short-cut the expression evaluation.

When more than one logical operator is used in an expression, OR operators bind weaker than both AND and NOT. Parentheses can be used to change the binding precedence.

Syntax

OR_Expression :=                                                                                         
     Boolean_Expression 'OR' Boolean_Expression.

Remarks

Boolean_Expression
The two Boolean expressions to be combined that return a not-null value of type bool.

Return Type

bool

Examples

The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.
The scripts can be executed locally. An Azure subscription and Azure Data Lake Analytics account is not needed when executed locally.

@data  = 
    SELECT * FROM 
        (VALUES  
        (1, "Noah",   100, (int?)10000, new DateTime(2012,05,31)),
        (2, "Sophia", 100, (int?)15000, new DateTime(2012,03,19)),
        (3, "Liam",   100, (int?)30000, new DateTime(2014,09,14)),
        (6, "Emma",   200, (int?)8000,  new DateTime(2014,03,08)),
        (7, "Jacob",  200, (int?)8000,  new DateTime(2014,09,02)),
        (8, "Olivia", 200, (int?)8000,  new DateTime(2013,12,11)),
        (9, "Mason",  300, (int?)50000, new DateTime(2016,01,01)),
        (10, "Ava",   400, (int?)15000, new DateTime(2014,09,14)),
        (11, "Ethan", 400, (int?)null,  new DateTime(2015,08,22))
        ) AS T(EmpID, EmpName, DeptID, Salary, StartDate);

@result =
    SELECT * FROM @data
    WHERE DeptID == 100 OR DeptID == 400;

OUTPUT @result TO "/ReferenceGuide/Operators/Logical/Or1.txt" USING Outputters.Csv();


@result =
    SELECT * FROM @data
    WHERE DeptID == 100 OR Salary > 10000;

OUTPUT @result TO "/ReferenceGuide/Operators/Logical/Or2.txt" USING Outputters.Csv();


@result =
    SELECT * FROM @data
    WHERE (DeptID == 100 AND Salary > 10000) OR DeptID == 400;

OUTPUT @result TO "/ReferenceGuide/Operators/Logical/Or3.txt" USING Outputters.Csv();


@result =
    SELECT * FROM @data
    WHERE (DeptID == 100 OR DeptID == 400) AND Salary > 10000;

OUTPUT @result TO "/ReferenceGuide/Operators/Logical/Or4.txt" USING Outputters.Csv();

Share via