This is a collection of posts about Apache Hive Complex data types that were first published on this blog.
Apache Impala – Data Analysis – Problem Scenario-1
One of the problem scenarios that can aid in analytical thought and problem-solving is shown below. SQL Server, MySQL, any RDBMS product, Apache Hive, Apache
SQL Server – Sample Schema – Tables – For Practice
Beginners can practice creating new tables, joining them together, using sub-queries, etc. with the schema below. I hope this will be useful to you as
MySQL Error 1067 – Invalid default value for Date
You may have noticed that date columns’ default dates in legacy systems are 0000-00-00. The data cannot be changed, therefore you’ll have to accept it.
EC2 Crontab Scheduling
Crontab is a job scheduling tool included with the Linux system pack. The first five elements relate to the execution date and time and are
Store AWS RDS Database in S3 Bucket
A MySQL database backup can be stored in an S3 bucket in a number of different ways. The S3 bucket can be mounted as a
Big Data & SQL 