Here are several examples with explanations and sample datasets for practicing SerDe. This post contains a compilation of all of the articles previously published on
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.
Error while dropping the database in HIVE
InvalidOperationException(message:Database test_db2 is not empty. One or more tables exist.)If you receive the error listed above, it means that the database you are attempting to
Hive SerDe – Cannot validate SerDe Error
A return code or an error code is an alphanumeric or numbered code that is used to evaluate the essence of the error and why
Hive SerDe – RegEx – Example2
In this post, we will be learning different patterns in input regular expressions itself. With a slight change in delimitation, the below dataset is similar
Hive SerDe – RegEx – Example1
SerDe: is short-form for Serializer/Deserializer. A SerDe allows Hive to read in data from a table, and write it back out to HDFS in any
Failed to initialize sqlcmd library with error number -2147467259.
While sending the mail through SQL Server using DBMail, sometimes we get the error message “Failed to initialize sqlcmd library with error number -2147467259”. This
Big Data & SQL 