Answer / Nirbhay Kumar

"Hive supports several common SQL-like commands such as SELECT, FROM, WHERE, GROUP BY, JOIN, UNION, INSERT, DELETE, and DROP. Additionally, Hive provides specific commands like:

1. CREATE TABLE - creates a table with specified schema.
2. DESCRIBE - describes the structure of the specified table or database.
3. DESCRIBE EXTENDED - provides additional information about the table, such as storage location, partitioning details, and statistics.
4. ALTER TABLE - modifies the properties or structure of an existing table.
5. CREATE DATABASE - creates a new database in Hive.
6. SHOW - lists all databases, tables, partitions, functions, serdes, etc.
7. EXPLAIN - explains how Hive plans to execute the given SQL query.
8. BEGIN TRANSACTION, COMMIT, and ROLLBACK - manage transactions in Hive.
9. LOAD DATA - loads data from an external file into a table or partition.
10. TRUNCATE TABLE - removes all rows from the specified table without actually deleting them.

Beeline CLI, which is a shell for Hive, also supports commands like SET, SHOW VARIABLES, and EXIT.".

What is bucketing in Hive?

1 Answers  

---

Mention what is ObjectInspector functionality in Hive?

1 Answers  

---

Can we load data into a view?

1 Answers  

---

Explain REVERSE function in Hive with example?

1 Answers  

---

Is hive suitable to be used for oltp systems? Why?

1 Answers  

---

what is partitions in hive?

1 Answers  

---

Is it possible to create cartesian join between 2 tables, using hive?

1 Answers  

---

what does /*streamtable(table_name)*/ do?

1 Answers  

---

I want to see the present working directory in UNIX from hive. Is it possible to run this command from hive?

1 Answers  

---

Why Hive is not suitable for OLTP systems?

1 Answers  

---

Where is table data stored in Apache Hive by default?

1 Answers  

---

What are the different Complex Data Types available in Hive?

1 Answers  

---