The CONCAT_WS function in Apache Hive incorporates two or more strings into a single string with the specified delimiter. Example: SELECT fname, lname, CONCAT_WS(‘ ‘,
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.
Logged In User in Apache Impala
This is a continuation post of “Connected User in Impala Daemon“ Apart from USER() and Effective_User() there’s one more function that retrieves user information in
Accessing Part of the Date – Apache Hive
The most critical and significant column is always the date/time in the data. A date/time dimension provides all the information you need for a given
Listing All The Functions In Apache Hive & Impala
The purpose of this article is to let you know how to list all the available functions in Apache Hive and Apache Impala. Once you
Listing All The Databases In Apache Hive & Impala
The purpose of this article is to let you know how to list all the Apache Hive Metastore databases that can be found with the
Listing All The Tables In Apache Hive & Imapala
The purpose of this article is to let you know how to list all the tables that exists in the current database in Apache Hive
Big Data & SQL 