in Big Data | Hadoop by (31.6k points)
What is a Skewed table in Hive?

1 Answer

0 votes
by (23.9k points)

A Skewed tables is a special type of table in which some values in a column appear more often. Due to this the distribution in skewed. In Hive, when we specify a table as SKEWED during  creation, then skewed values are written into separate files and remaining values go to another file.

E.g. CREATE TABLE tableName (column1 STRING, column2



(column1) on (‘value1’)

During queries, we get better performance in Hive with SKEWED tables.

Related questions

0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986 (31.6k points)
0 votes
asked Apr 1, 2020 in Big Data | Hadoop by AdilsonLima (6.2k points)
0 votes
asked Sep 7, 2019 in Big Data | Hadoop by john ganales (14.0k points)