SQLBank: Alternative to ISNULL() and NVL() function in Hive; nvl()

Pages

▼

Showing posts with label Alternative to ISNULL() and NVL() function in Hive; nvl(). Show all posts

Showing posts with label Alternative to ISNULL() and NVL() function in Hive; nvl(). Show all posts

Monday, September 28, 2020

An alternative to ISNULL() and NVL() functions in Hive

The NVL() function enables you to substitute null for a more relevant alternative in the query results. This function accepts two arguments....

View web version

About Me

Shafi Shaik: Dubai, United Arab Emirates; Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.

View my complete profile

Powered by Blogger.