This article aims to explain the usage of the SPLIT function in HiveQL. If you are looking for a similar function in SQL Server, then
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.
File formats and compression in Apache Hive
The purpose of this article is to address the different file formats and compression codecs in Apache Hive that are available for different data sets.
Commonly used Apache Hive non-SQL Statements
Commands are non-SQL statements such as setting a property or adding a resource. They can be used in HiveQL scripts or directly in the CLI or Beeline. The
HDFS Basic Commands
This article will explore some Hadoop basic commands that help in our day-to-day activities. Hadoop file system shell commands are organized in a similar way
File exists error in HDFS – CopyFromLocal
HDFS is a distributed file system designed to run on top of the local file system. Many times we may need to copy files from
Difference between CopyFromLocal, Put, CopyToLocal and Get
The purpose of this article is to let you know about few HDFS commands that are identical in behavior but distinct. CopyFromLocal and Put: These
Big Data & SQL 