Introduction to Apache Hive

Great Learning

Brochure

Enquire

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

The internal table gets created by default in a specific location in Apache Hive when the user does not specify it as external, with the path similar to /user/hive/warehouse directory of HDFS.

Text files, SequenceFile, RCFile, Avro files. ORC files, Parquet, Custom INPUT FORMAT, and OUTPUT FORMAT are the different file formats supported by Apache Hive.

The Apache Hive Query Language (HQL) follows similar semantics and functions to that of standard SQL in the relational database. You will learn in detail with examples further in this section.

SHOW SCHEMA, SHOW TABLES, and USE are the most commonly used queries/commands in Apache Hive. You will understand working with it better with examples in this section.