We have a customer who is running HDP HDP-22.214.171.124 with HIve 126.96.36.199.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.?