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
Category: Apache Hive
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
SQL Assignment-1
For beginners to intermediate levels, this is a quick test/assignment to check how familiar they are with SQL. Such types of exercises will certainly help
SPACE function in Apache Hive & Apache Impala
There are some functions that hardly come into use. Often this kind of function would have some other replacement that we use. SPACE is one
Big Data & SQL 