Home >> Big Data Hadoop >> Will the reducer work or not if you use Limit 1 in any HiveQL query in Big Data Hadoop

Will the reducer work or not if you use Limit 1 in any HiveQL query in Big Data Hadoop

Reducer should work, because as per Hive documentation -- Limit indicates the number of rows to be returned. The rows returned are chosen at random. The following query returns 5 rows from t1 at random.

SELECT * FROM t1 LIMIT 5

Post Your Comment

Next Questions
Hive Explain about SORT BY, ORDER BY, DISTRIBUTE BY and CLUSTER BY
What is difference between hive internal table and external table
Why you should choose Hive instead of Hadoop MapReduce
How will you optimize Hive performance
Hive Difference between Sort By and Order By
Sqoop vs Flume
What is the default file format to import data using Apache Sqoop
we have around 300 tables in a database. I want to import all the tables from the database except the tables named Table298, Table 123, and Table299. How can I do this without having to import the tables one by one using sqoop
How can you execute a free form SQL query in Sqoop to import the rows in a sequential manner
How will you list all the columns of a table using Apache Sqoop
What is the difference between Sqoop and DistCP command
What is Sqoop metastore
What is the significance of using --split-by clause for running parallel import tasks in Apache Sqoop

Copyright ©2022 coderraj.com. All Rights Reserved.