title: sql sever 2017: sp_execute_external_script: execution freezes when loading large amount of data
body: <p>Is there a method to increase the amount of data, which can be loaded to sp_execute_external_script?</p>
  <p>When loading into execute sp_execute_external_script - 500 thousand rows * 50 columns like:</p>
  <pre><code>exec sp_execute_external_script 
  @language = N'Python'
  ,@script = N'python script'
  ,@input_data_1 = N'select 500000 rows * 50 columns from table'
  ,@input_data_1_name = N'df';
  </code></pre>
  <p>Execution freezes (starts and longs for hours while is not stopped).
  When decrease the number of rows to 300 thousand, but keep 50 columns - it perfectly works.
  When decrease the number of columns to 5, but keep 500 thousand rows - it perfectly works.</p>
  <p>The method of splitting the data on chunks and then combine it into one file works for me, but I wouldn't like, if possible, to apply it, since it requires additional hours of work to develop code and to support it.</p>
  <p>Thank you.</p>