Answer / Arun Yadav

Bucketing in Hive is a technique used for data locality optimization. It divides the table into equal-sized partitions called buckets. By default, Hive creates 128 buckets for a table. Bucketing can significantly reduce the number of blocks that need to be scanned during a query, thereby improving performance. Here's an example:

```sql
CREATE TABLE table_name (columns...) BUCKETED BY bucket_column;
```

Replace `table_name`, `columns`, and `bucket_column` with appropriate names.

What are the default record and field delimiter used for hive text files?

1 Answers  

---

What do you mean by schema on reading?

1 Answers  

---

What are the different parts of Hive ?

1 Answers  

---

RLIKE in Hive?

1 Answers  

---

Can the name of a view be same as the name of a hive table?

1 Answers  

---

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

1 Answers  

---

What is a generic UDF in the hive?

1 Answers  

---

What is the difference between CREATE TABLE AND CREATE EXTERNAL TABLE?

1 Answers  

---

Specify the partitions in hive?

1 Answers  

---

What are the uses of explode hive?

1 Answers  

---

What are the components used in Hive query processor?

1 Answers  

---

What is the major difference between local and remote meta-store?

1 Answers  

---