What is difference between static and dynamic partition of a table?.What are the default record and field delimiter used for hive text files?.does Hive support record level Insert, delete or update?.does the archiving of Hive tables save space in HDFS?.Can a partition be archived? What are the advantages and disadvantages?.Suppose that I want to monitor all the open and aborted transactions in the system along with the transaction id and the transaction state.
What is the relationship between MapReduce and Hive? or How Mapreduce jobs submits on the cluster?.What is the significance of ‘IF EXISTS” clause while dropping a table?.Explain about the different types of partitioning in Hive?.While loading data into a hive table using the LOAD DATA clause, how do you specify it is a hdfs file and not a local file ?.How does Hive deserialize and serialize the data?.Why does Hive not store metadata information in HDFS?.Can we change the data type of a column in a hive table?.Whenever we run a Hive query, a new metastore_db is created.What is a Hive variable? What do we use it for?.How can you stop a partition form being queried?.Can Hive process any type of data formats?.Is it possible to add 100 nodes when we already have 100 nodes in Hive? If yes, how?.How can you connect an application, if you run Hive as a server?.What are the different components of a Hive architecture?.How can you prevent a large job from running for a long time?.What are the three different modes in which hive can be run?.Why will mapreduce not run if you run select * from table in hive?.How does bucketing help in the faster execution of queries?.What is ObjectInspector functionality in Hive?.Explain the functionality of ObjectInspector.Which classes are used in Hive to Read and Write HDFS Files?.What is the difference between local and remote metastore?.Explain about SORT BY, ORDER BY, DISTRIBUTE BY and CLUSTER BY in Hive.How data transfer happens from HDFS to Hive?.Where does the data of a Hive table gets stored?.What is the difference between partition and bucketing?.What are the different Modes in the Hive?.What is the Object Inspector functionality is in Hive?.Is Hive suitable to be used for OLTP systems? Why?.What are the types of database does Hive support ?.What kind of data warehouse application is suitable for Hive? What are the types of tables in Hive?.