Skewed tables are those in which some column values occur more frequently than others. As a result, the distribution is skewed. Hive will automatically separate
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.
Adding multiple partitions at once – Hive
Is it possible to add multiple partitions to a table in Apache Hive at the same time? If you’re using version 0.7 or older, the
Name node is in safe mode error in HDFS
When we create a directory in HDFS or move a directory from the local machine to HDFS, we occasionally encounter the following error. Cannot create
Adding a file in External Table’s Location in Hive
When we create an external table in Hive, we typically specify its location rather than the actual file. Hive reads data from the specified location,
Alter Statements For Constraints in Hive
SQL constraints can be used to enforce data integrity and boost speed. The optimizer can make queries easier to understand by using constraints. Constraints can
Altering Skewed Tables in Hive
As we discussed in the earlier posts, Skewed tables are those in which some column values occur more frequently than others. As a result, the
Big Data & SQL 