Recent questions and answers in Hive

0 votes

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

answered Dec 3, 2020 in Hive by sharadyadav1986 (30.5k points)

+1 vote

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

answered Dec 3, 2020 in Hive by sharadyadav1986 (30.5k points)

+1 vote

What are the components used in Hive query processors?

answered Dec 3, 2020 in Hive by sharadyadav1986 (30.5k points)

+1 vote

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 (30.5k points)

+1 vote

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 (30.5k points)

0 votes

What are the key differences between Hive and Pig?

answered Dec 3, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

How is Apache Pig different from MapReduce?

answered Dec 3, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

What are the different ways of executing a Pig script?

answered Dec 3, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

Which of the following is an assertion library?

answered Nov 3, 2020 in Hive by rahuljain1 (6.0k points)

0 votes

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

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

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

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

The result of a Hive query is saved in _______________.

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

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 (30.5k points)

0 votes

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 (30.5k points)

0 votes

Where is data stored?

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

+1 vote

If the partition of an index table is dropped, then

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

Hive is a __________________.

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

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 (30.5k points)

+1 vote

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 (30.5k points)

0 votes

Hive will provide Data Warehousing Layer to data over Hadoop.

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

Apache Hive was initially developed by ____________.

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

In which mode, HiveServer2 accepts real Thrift calls.

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

Which of the following are types of metastore?

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

Which of the following options Hive doesn’t convert queries to?

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

Hive can replace RDBMS.

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

Hive stores metadata by default in ____________.

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

+1 vote

When the schema of the table doesn’t match with the data types of the file that is to be loaded, what does Hive do?

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

Which of the following command is to be used in a DDL statement to create Avro-backed tables?

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

Hive allows the feature to copy __________.

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

0 votes

If you create a table but don't create a database then where will the table be stored?

answered Oct 25, 2020 in Hive by sharadyadav1986 (30.5k points)

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

...