[
https://issues.apache.org/jira/browse/DRILL-7037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16780127#comment-16780127
]
Ayush Sharma commented on DRILL-7037:
-------------------------------------
[~kkhatua] Are temporary tables provided by Drill or i need to use my own
database?
In case its my own database the read and write time would be higher than normal
disk read write which i am using as a workaround for now.
However security is not liking the fact that we are writing data into the disk
even though we delete it post querying.
> Apache Drill Crashes when a 50mb json string is queried via the REST API
> provided
> ---------------------------------------------------------------------------------
>
> Key: DRILL-7037
> URL: https://issues.apache.org/jira/browse/DRILL-7037
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - HTTP
> Affects Versions: 1.14.0
> Environment: Windows 10
> 24GB RAM
> 8 Cores
> Used the REST API call to query drill
> Reporter: Ayush Sharma
> Priority: Blocker
>
> Apache Drill crashes with OutofMemoryException (24GB RAM) when a REST API
> call is made by supplying a json of size 50MB in the query paramater of the
> REST API.
> The REST API even crashes for a 10MB query (16GB RAM) and works with a 5MB
> query.
> This is a blocker for us and will need immediate remediation.
> We are also not aware of any sys.options which might bring the HEAP size down
> drastically or currently making it go up.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
