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