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.

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

Explorer

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.?

Don't have an account?
Coming from Hortonworks? Activate your account here