Hive Interview Questions and Answers For Freshers Part-5
41.Can we LOAD data into a view? No. A view can not be the target of a INSERT or LOAD statement.
Read MoreHive Interview Questions and Answers For Freshers Part-4
31.What does the following query do? INSERT OVERWRITE TABLE employees PARTITION (country, state) SELECT …, se.cnty, se.st FROM staged_employees se; It creates partition on table employees with partition values coming from the columns in the select clause. It is called…
Read MoreHive Interview Questions and Answers For Freshers Part-3
21.What is the significance of the line set hive.mapred.mode = strict; It sets the mapreduce jobs to strict mode.By which the queries on partitioned tables can not run without a WHERE clause. This prevents very large job running for long…
Read MoreHive Interview Questions and Answers For Freshers Part-2
11.What are collection data types in Hive? There are three collection data types in Hive. ARRAY MAP STRUCT
Read MoreHive Interview Questions and Answers For Freshers Part-1
1.What are the different types of tables available in HIve? There are two types. Managed table and external table. In managed table both the data an schema in under control of hive but in external table only the schema is…
Read More