This article addresses the conversion of the delimited data into columns in MySQL. There are is a function called “SUBSTRING_INDEX” that helps us convert the
Tag: STRING_SPLIT function in SQL Server
Convert Delimited Data Into Columns In SQL Server
This article addresses the conversion of the delimited data into columns in SQL Server. There are two functions called “STRING_SPLIT” and “PARSENAME” that helps us
Convert Delimited Data Into Columns In Hive
The conversion of delimited data into columns in Apache Hive is discussed in this article. If the data is already loaded as a single column
Convert Delimited Data Into Columns in Impala
The conversion of delimited data into columns in Apache Impala is discussed in this article. If the data is already loaded as a single column
SQL Server 2016 – Compatibility Issues – Invalid object name
If you are using SQL Server 2016 version and still you are getting the error Invalid object name ‘STRING_SPLIT’ as shown below while using the functions
Word Count in SQL Server – String_Split Usage
STRING_SPLIT is a table-valued function that splits the words from the input text and returns into rows. This function has been introduced in SQL Server
Big Data & SQL 