Apache Presto - Relational Operator


Advertisements

Relational operators are used to compare between two values. Take a look at the following queries. They show how relational operators work.

Query 1

presto:default> select 4 < 5 as lessthan;

Result

 lessthan 
---------- 
 true 
(1 row) 

The above condition is true, hence the result is true.

Query 2

presto:default> select 25 >= 45 as greater; 

Result

 greater 
--------- 
 false 
(1 row) 

The above condition is false, hence the result is false.

Query 3

presto:default> select 3<>5 as notequal;

Result

 notequal 
---------- 
  true

Here 3 is not equal to 5, hence the result is returned as true.

apache_presto_basic_sql_operations.htm

Useful Video Courses


Video

Apache Spark Online Training

46 Lectures 3.5 hours

Arnab Chakraborty

Video

Apache Spark with Scala - Hands On with Big Data

23 Lectures 1.5 hours

Mukund Kumar Mishra

Video

Learn Apache Cordova using Visual Studio 2015 & Command line

16 Lectures 1 hours

Nilay Mehta

Video

Delta Lake with Apache Spark using Scala

52 Lectures 1.5 hours

Bigdata Engineer

Video

Apache Zeppelin - Big Data Visualization Tool

14 Lectures 1 hours

Bigdata Engineer

Video

Olympic Games Analytics Project in Apache Spark for Beginner

23 Lectures 1 hours

Bigdata Engineer

Advertisements