query hint

Understanding Map join in Hive

Apache Hive is a big data query language which is used to read, transform and write large datasets in a distributed environment. It has a SQL like syntax which gets translated into a MapReduce job in order to execute on Hadoop clusters. In Hadoop ecosystem, we use Hive for batch processing to extract, transform and […]

Understanding Map join in Hive Read More »

The join order has been enforced because a local join hint is used – Warning in SQL Server

When we use a local JOIN hint in T-SQL query, sometimes, SQL Server throws a warning message as “Warning: The join order has been enforced because a local join hint is used.“. For example, below is a query with a local join hint: After execution, we will get below warning message with result set: In above code, we are using

The join order has been enforced because a local join hint is used – Warning in SQL Server Read More »

Convert a comma separated list into table

In this post, we are going to learn “how we can convert a comma separated list into a table using a recursive CTE”. Below is the code: Why OPTION MAXRECURSION? Hint OPTION(MAXRECURSION 32767) is a query hint which instructs to compiler to iterate 32767 times. Default, max recursion of a loop in SQL is 100 and in case we

Convert a comma separated list into table Read More »