Apache Hive Quiz

what social media platform developed Apache Hive?

• Facebook

• Twitter

• Tiktok

• Instagram

OLAP stands for?

• Online Analysis Practice

• Online Australian Post

• Online Analytical Processing

• Online Active Process

Apache Hive language for querying called?

• SQL

• HL

• AQL

• HQL

Data storage technique to store data in file system

• Server

• Oracle

• HDFS

Data types can be specified using single quote (' ') or double quote (" ")

• Integral Types

• String Types

• Float

• Dates

Apache Hive command used to deletes all the tables and databases

• CLEAR

• ERASE

• DELETE

• DROP

Apache Hive command which is way of dividing a table into related parts based on the values of partitioned column such as dates, city and department.

• divide

• partitioning

• split

• portion

TRUE if expression A is equivalent to expression B otherwise FALSE

• A / B

• A != B

• A = B

TRUE if expression is greater than or equal to expression B otherwise FALSE

• A <= B

• A >= B

• A > B

A clause works similar to a condition

• WHERE

• WITH

• AS