Default dates in legacy systems, particularly MySQL, were set to 0000-00-00. From version 5.6 on, MySQL stopped allowing users to enter these values without first
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.
Complex Data Types – STRUCT
STRUCT in Hive is similar to STRUCT in the C programming language. It’s a record type that contains a collection of named fields that can
Apache Hive Complex Data Types
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.
Big Data & SQL 