Poly base script RRS feed

  • Question

  • I am using DWU 100 unit in our SQL data warehouse and facing issue while loading data from blob storage to stage environment for few tables. Poly base script is failing sometimes and we are getting below error:


    “Execution fail against sql server. Sql error number: 35386. Error Message: Unable to allocate 393851 KB for columnstore compression because it exceeds the remaining memory from total allocated for current resource class and DWU. Please rerun query at a higher resource class, and also consider increasing DWU. See ... for assistance.”


    Same Polybase script is working fine if we change resource_class to “xlargerc”.

    Wednesday, April 15, 2020 10:37 AM

All replies