Tag: out-of-memory

Avoid ‘out of shared memory error’ in PostgreSQL function

loops out-of-memory postgresql sql sql-function

I have two tables, a table called companies_display with information about publicly traded companies such as ticker symbol, market cap etc. and a partitioned table stock_prices with the historical stock prices for each company. I want to calculate the beta of each stock and write that into companies_display. For that I wrote the function calculate_beta(ticker) that calculates it: The function

Optimize Hive Query. java.lang.OutOfMemoryError: Java heap space/GC overhead limit exceeded

azure-hdinsight beeline hive out-of-memory sql

How can I optimize a query of this form since I keep running into this OOM error? Or come up with a better execution plan? If I removed the substring clause, the query would work fine, suggesting that this takes a lot of memory. When the job fails, the beeline output shows the OOM Java heap space. Readings online suggested