Top 100+ questions and answers in Hive

0 votes

Q: What is the difference between an external table and a managed table in Hive?

answered Dec 3, 2020 in Hive by sharadyadav1986

0 votes

Q: What is a partition in Hive and why is partitioning required in Hive

answered Dec 3, 2020 in Hive by sharadyadav1986

0 votes

Q: What are the components used in Hive query processors?

answered Dec 3, 2020 in Hive by sharadyadav1986

0 votes

Q: Suppose there are several small CSV files present in /user/input directory in HDFS and you want to create a single Hive table from these files.

answered Dec 3, 2020 in Hive by sharadyadav1986

0 votes

Q: Write a query to insert a new column(new_col INT) into a hive table (h_table) at a position before an existing column (x_col).

answered Dec 3, 2020 in Hive by sharadyadav1986

0 votes

Q: What are the key differences between Hive and Pig?

answered Dec 3, 2020 in Hive by sharadyadav1986

0 votes

Q: How is Apache Pig different from MapReduce?

answered Dec 3, 2020 in Hive by sharadyadav1986

0 votes

Q: What are the different ways of executing a Pig script?

answered Dec 3, 2020 in Hive by sharadyadav1986

0 votes

Q: Which of the following is an assertion library?

answered Nov 3, 2020 in Hive by rahuljain1

0 votes

Q: Which of the following command can be used to show partitions?

answered Oct 25, 2020 in Hive by sharadyadav1986

0 votes

Q: Which is the following is more convenient to get table details?

answered Oct 25, 2020 in Hive by sharadyadav1986

0 votes

Q: The result of a Hive query is saved in _______________.

answered Oct 25, 2020 in Hive by sharadyadav1986

0 votes

Q: When there is a large set of data and you want to retrieve a small set of data. What is the concept called?

answered Oct 25, 2020 in Hive by sharadyadav1986

0 votes

Q: If the database contains some tables, then using which keyword can it be forced to drop the tables?

answered Oct 25, 2020 in Hive by sharadyadav1986

0 votes

Q: Where is data stored?

answered Oct 25, 2020 in Hive by sharadyadav1986

0 votes

Q: If the partition of an index table is dropped, then

answered Oct 25, 2020 in Hive by sharadyadav1986

0 votes

Q: Hive is a __________________.

answered Oct 25, 2020 in Hive by sharadyadav1986

0 votes

Q: A UDF is created to accept arguments of different data types. Which of the following defines the given statement?

answered Oct 25, 2020 in Hive by sharadyadav1986

0 votes

Q: When the schema of the table doesn’t match with the data types of the file. What does Hive do?

answered Oct 25, 2020 in Hive by sharadyadav1986

0 votes

Q: Hive will provide Data Warehousing Layer to data over Hadoop.

answered Oct 25, 2020 in Hive by sharadyadav1986

To see more, click for all the questions in this category.

...