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
Purging in Apache Hive
Purge in Apache Hive aids in the permanent deletion of data. This will be used with the DROP TABLE statement. This can also be used for deleting
Big Data & SQL 