Forum: Building VoltDB Applications

Post: More than 100MB of temp table memory used while executing SQL.

More than 100MB of temp table memory used while executing SQL.
Kev B
Nov 1, 2010
Hello I am attempting to run a query on a single table, but I am getting an exception stating that I have used more than the 100MB allocated to the temp table memory. Where in the configuration can this value be tuned? Below is the query that is being executed

SELECT COUNT(SSN) AS SSN, B_DATE FROM URL_DATA WHERE GENDER = ? GROUP BY B_DATE ORDER BY B_DATE
re: 100MB temp table limit
tcallaghan
Nov 3, 2010
Kev B,
The 100MB temp table limit is set internally in the code, it is not a configurable parameter.
Have you considered creating a view for URL_DATA as follows:


CREATE VIEW url_data_view (b_date, gender, num_rows)
AS SELECT b_date, gender, COUNT(*)
FROM url_data
GROUP BY b_date, gender;


You could then "SELECT num_rows AS SSN, b_date FROM url_data WHERE gender = ? ORDER BY b_date".

-Tim