https://community.cloudera.com/t5/Archives-of-Support-Questions/Why-are-T-SQL-queries-from-MS-SQL-Server-2016-via-PolyBase/m-p/174333#M46135 <P>Hi <A rel="user" href="https://community.cloudera.com/users/12546/claymcdonald.html" nodeid="12546">@Clay McDonald</A>. One of the reason is because of MapReduce. Hive uses Tez but Polybase is not compatible yet with Tez. MapReduce is a batch data processing engine. You will also want to make sure your Hive tables are properly configured using best practices. Try implementing some of these rules where applicable <A href="http://hortonworks.com/blog/5-ways-make-hive-queries-run-faster/" target="_blank">http://hortonworks.com/blog/5-ways-make-hive-queries-run-faster/</A>. </P><P>Also be aware of your cluster size. MapReduce (as well as other data processing engines) use parallel processing but if you don't have many nodes than you are taking advantage of the design. </P><P>Note sure if its applicable in your case but you could use multiple SQL Servers to parallelize your Polybase query. <A href="https://msdn.microsoft.com/en-us/library/mt607030.aspx" target="_blank">https://msdn.microsoft.com/en-us/library/mt607030.aspx</A></P> Tue, 15 Nov 2016 00:45:20 GMT SQLShaw 2016-11-15T00:45:20Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Why-are-T-SQL-queries-from-MS-SQL-Server-2016-via-PolyBase/m-p/174332#M46134 <P>Cannot find any deep learning documentation on how exactly PolyBase works and nothing on performance tuning. Any help would be appreicated.</P> Tue, 15 Nov 2016 00:24:15 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Why-are-T-SQL-queries-from-MS-SQL-Server-2016-via-PolyBase/m-p/174332#M46134 clay_mcdonald 2016-11-15T00:24:15Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Why-are-T-SQL-queries-from-MS-SQL-Server-2016-via-PolyBase/m-p/174333#M46135 <P>Hi <A rel="user" href="https://community.cloudera.com/users/12546/claymcdonald.html" nodeid="12546">@Clay McDonald</A>. One of the reason is because of MapReduce. Hive uses Tez but Polybase is not compatible yet with Tez. MapReduce is a batch data processing engine. You will also want to make sure your Hive tables are properly configured using best practices. Try implementing some of these rules where applicable <A href="http://hortonworks.com/blog/5-ways-make-hive-queries-run-faster/" target="_blank">http://hortonworks.com/blog/5-ways-make-hive-queries-run-faster/</A>. </P><P>Also be aware of your cluster size. MapReduce (as well as other data processing engines) use parallel processing but if you don't have many nodes than you are taking advantage of the design. </P><P>Note sure if its applicable in your case but you could use multiple SQL Servers to parallelize your Polybase query. <A href="https://msdn.microsoft.com/en-us/library/mt607030.aspx" target="_blank">https://msdn.microsoft.com/en-us/library/mt607030.aspx</A></P> Tue, 15 Nov 2016 00:45:20 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Why-are-T-SQL-queries-from-MS-SQL-Server-2016-via-PolyBase/m-p/174333#M46135 SQLShaw 2016-11-15T00:45:20Z