Saved Bookmarks
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
How do you specify the table creator name when creating a table in Hive? |
| Answer» | |
| 2. |
The following statement failed to execute. What can be the cause? |
| Answer» | |
| 3. |
What is a generic UDF in hive? |
| Answer» | |
| 4. |
Can a partition be archived? What are the advantages and Disadvantages? |
| Answer» | |
| 5. |
What does /*streamtable(table_name)*/ do? |
| Answer» | |
| 6. |
What is bucketing ? |
| Answer» | |
| 7. |
Give the command to see the indexes on a table. |
| Answer» | |
| 8. |
What types of costs are associated in creating index on hive tables? |
| Answer» | |
| 9. |
Can we LOAD data into a view? |
| Answer» | |
| 10. |
Can the name of a view be same as the name of a hive table? |
| Answer» | |
| 11. |
What will be the result when you do cast(‘abc’ as INT)? |
| Answer» | |
| 12. |
How will you convert the string ’51.2’ to a float value in the price column? |
| Answer» | |
| 13. |
What is the usefulness of the DISTRIBUTED BY clause in Hive? |
| Answer» | |
| 14. |
As part of Optimizing the queries in HIve, what should be the order of table size in a join query? |
| Answer» | |
| 15. |
Is it possible to create Cartesian join between 2 tables, using Hive? |
| Answer» | |
| 16. |
What is the difference between LIKE and RLIKE operators in Hive? |
| Answer» | |
| 17. |
How can Hive avoid mapreduce? |
| Answer» | |
| 18. |
What is a Table generating Function on hive? |
| Answer» | |
| 19. |
What does the following query do? |
| Answer» | |
| 20. |
If you omit the OVERWRITE clause while creating a hive table,what happens to file which are new and files which already exist? |
| Answer» | |
| 21. |
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 ? |
| Answer» | |
| 22. |
How can you stop a partition form being queried? |
| Answer» | |
| 23. |
Does the archiving of Hive tables give any space saving in HDFS? |
| Answer» | |
| 24. |
Write a query to insert a new column(new_col INT) into a hiev table (htab) at a position before an existing column (x_col) |
| Answer» | |
| 25. |
When you point a partition of a hive table to a new directory, what happens to the data? |
| Answer» | |
| 26. |
What is the significance of ‘IF EXISTS” clause while dropping a table? |
| Answer» | |
| 27. |
Which java class handles the output record encoding into files which result from Hive queries? |
| Answer» | |
| 28. |
Which java class handles the Input record encoding into files which store the tables in Hive? |
| Answer» | |
| 29. |
How do you check if a particular partition exists? |
| Answer» | |
| 30. |
What is the significance of the line |
| Answer» | |
| 31. |
How can you delete the DBPROPERTY in Hive? |
| Answer» | |
| 32. |
What does the “USE” command in hive do? |
| Answer» | |
| 33. |
How do you list all databases whose name starts with p? |
| Answer» | |
| 34. |
What do you mean by schema on read? |
| Answer» | |
| 35. |
What are the default record and field delimiter used for hive text files? |
| Answer» | |
| 36. |
What is the importance of .hiverc file? |
| Answer» | |
| 37. |
Can hive queries be executed from script files? How? |
| Answer» | |
| 38. |
What is a Hive variable? What for we use it? |
| Answer» | |
| 39. |
Can we run unix shell commands from hive? Give example. |
| Answer» | |
| 40. |
What are collection data types in Hive? |
| Answer» | |
| 41. |
Is there a date data type in Hive? |
| Answer» | |
| 42. |
What are the three different modes in which hive can be run? |
| Answer» | |
| 43. |
What is the default location where hive stores table data? |
| Answer» | |
| 44. |
Why do we need Hive? |
| Answer» | |
| 45. |
What is the need for custom Serde? |
| Answer» | |
| 46. |
What is a metastore in Hive? |
| Answer» | |
| 47. |
Can we change the data type of a column in a hive table? |
| Answer» | |
| 48. |
Can a table be renamed in Hive? |
| Answer» | |
| 49. |
Is Hive suitable to be used for OLTP systems? Why? |
| Answer» | |
| 50. |
What are the different types of tables available in HIve? |
| Answer» | |