This function is introduced in SQL Server 2017 (14x) concatenates the values of string expressions and places separator values between them. The separator is not
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.
Can we use INVALIDATE METADATA in Impala?
As per the documentation, the INVALIDATE METADATA command marks one or all tables’ metadata as stale. The next time the Impala service runs a query
Apache Impala or Cloudera’s Impala
The terms Cloudera Impala and Apache Impala are frequently confused. Cloudera Inc. is the initial designer/developer of Impala. It was, however, donated to Apache in
UPSERT in SQL
The UPSERT statement combines the INSERT and UPDATE statements into one statement. If another row with the identical set of primary key values already exists
Sqoop Import as Parquet File
We often wanted to import data in parquet format to take use of the benefit of parquet, which reduces storage space by using highly efficient
Apache Sqoop vs Apache Flume
One of my earlier post described about Hadoop and its ecosystem components. Please refer to it for basic understanding. We will be discussing in this
Big Data & SQL 