[
https://issues.apache.org/jira/browse/DRILL-7037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16766058#comment-16766058
]
Vitalii Diravka commented on DRILL-7037:
----------------------------------------
[[email protected]] Thank you for reporting the issue for this
interesting case.
Could you please provide logs and query profile?
Did you try the same query from the JDBC client or Drill SqlLine?
You can store your query to the script file and run it with -f or --run, see
https://drill.apache.org/docs/configuring-the-drill-shell/#sqlline-connection-parameters
Did you check the heap dump after OOM? Did you try to perform the same query
from the JSON file?
> 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
> Attachments: scheduler.txt
>
>
> 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)
