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 …
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 …
11.What are collection data types in Hive? There are three collection data types in Hive. ARRAY MAP STRUCT
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 …
41.In PCB which field is used to store the level of the segment that was processed? Segment level is known as Segment Hierarchy Level Indicator. It contains character data and …
31.How can we access the data in IMS DB? Data can be processed in both the ways: Sequential & Random.
21.What is the return code you get after a successful IMS call? We receive spaces after a successful call.
11.What is the use of PROCOPT? Procopt parameter specifies PROCESSING OPTIONS that define the type of processing performed on a segment.
1.What is a hierarchy path? Hierarchy path is a line that starts at the root, passes through the intermediate levels in the hierarchy, and ends at a segment at the …
41.What does “file could only be replicated to 0 nodes, instead of 1” mean? The namenode does not have any available DataNodes.
