Collect_List is one of the aggregate functions that help in return a set of objects with duplicate elements. This is similar to COLLECT_SET and will
Author: SHAFI SHAIK
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.
Get the Connected User in Apache Hive
Apache Hive introduced a function named “current_user()” from version 1.2.0 which returns the current user name from the authenticator manager configured. It could be the
Substring_Index Function in Apache Hive
The aim of this post is to let you know how to use the SUBSTRING INDEX() function to get a substring from a string until
Get Version Of Apache Hive
If you are using Apache Hive 2.1.0 or later versions, you can SELECT VERSION() function in the Apache Hive prompt to get the version. Otherwise,
Usage of Collect_Set Function in Apache Hive
Collect_Set is one of the aggregate functions that help in return a set of objects with duplicate elements eliminated. This will help in bringing the
Type Conversion Functions in Apache Hive
One of the commonly used functions in RDBMS is the CAST function, which helps to transform the expression of one data type to another data
Big Data & SQL 