[ https://issues.apache.org/jira/browse/DRILL-7037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16816675#comment-16816675 ]
Venkata Jyothsna Donapati commented on DRILL-7037: -------------------------------------------------- [~er.ayushsha...@gmail.com] Drill provides a way to create temporary tables. Please take a look at [this|[https://drill.apache.org/docs/create-temporary-table-as-cttas/]] > 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)