Can we run unix shell commands from hive? Can hive queries be executed from script files? How? Give an example.
What is the precedence order of hive configuration?
Why hive does not store metadata information in hdfs?
Whenever we run hive query, new metastore_db is created. Why?
How hive can improve performance with orc format tables?
How to change the column data type in hive? Explain rlike in hive.
What are the uses of explode hive?
how can we access the sub directories recursively?
How do we write our own custom serde?
Explain the functionality of object-inspector.
Differentiate between hive and hbase?
Explain process to access sub directories recursively in hive queries.
Mention the date data type in hive. Name the hive data type collection.
What is the work of hive/hcatalog?
What is apache hcatalog?