Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

is there a limit to the number of rows and columns in a hive table.

Highlighted

is there a limit to the number of rows and columns in a hive table.

New Contributor

We have a customer who is running HDP HDP-2.5.0.0 with HIve 1.2.1.2.5

they have a hive table with 400 Columns and 10 billion rows.

when they run a query through Rstudio

testQuery1 = "select * from XXXXXXXXX limit 10" testResult1 <- dbGetQuery(conn, testQuery1)

It takes a long time or errors out with Java heap space exception.

Is there any limitations to the size of a table at various HIVE versions??

What type of memory modifications would we need to make to get this query to run successfully.?