Explore topic-wise InterviewSolutions in .

HCatalog is based on the metastore of Hive and includes Hive's ______________.
(1)DML
(2)DDL
(3)NONE of the OPTIONS.
(4)TCL
Answer:-(2)DDL

Where is the SCHEME for the DATA is SPECIFIED?
(1)setOutputSchema
(2)setSchema
(3)getTableSchema
Answer:-(2)setSchema

When using HCatalog, the client only needs to reference the table name
and HCatalog will provide the relational SCHEMA and the location of the data.
(1)True
(2)False
Answer:-(1)True

HCatalog SUPPORTS which of the following types of FILE?
(1)JSON
(2)ORC
(3)CVS
(4)All of the mentioned OPTIONS
Answer:-(4)All of the mentioned options

What is the role of data transfer API in HCatalog?
(1)For PARALLEL INPUT as WELL as output without even using MapReduce.
(2)None of the options.
(3)To read data from HCatalog-managed tables
(4)For issuing data definition and metadata exploration commands
Answer:-(1)For parallel input as well as output without even using MapReduce.

Which of the following option/options supports/support HCatalog features consistent with SQOOP usage?
Option 1: Accept a table to write to and optionally a specification of PARTITION keys to create a new partition.
Option 2: Automatic table schema mapping.
Option 3: Support both import and export data in various FORMATS.
(1)Option 1
(2)Option 2
(3)All the options except option 1
Answer:-(3)All the options except option 1

________ is a HCatalog REST API.
(1)Serde
(2)None of the OPTIONS.
(3)Both of the options
(4)WEBHCAT
Answer:-(4)WebHCat

___________ is implemented on top of HCATOUTPUTFORMAT.
(1)HcatLoader
(2)NONE of the options.
(3)HCATSTORER
(4)SerDe
Answer:-(3)HCatStorer

Which of the following option is the CORRECT way to load data into HDFS?
Option 1: hcat.py "LOAD DATA LOCAL INPATH '/home/user/sample.txt'
OVERWRITE INTO TABLE EMPLOYEE;"
Option 2: ./hcat e "LOAD DATA LOCAL INPATH '/home/user/sample.txt'
OVERWRITE INTO TABLE employee;"
Option 3: ./hcat f "LOAD DATA LOCAL INPATH '/home/user/sample.txt'
OVERWRITE INTO TABLE employee;"
(1)Option 3
(2)Option 1
(3)Option 2
Answer:-(3)Option 2

Why USE HCATALOG?
(1)It INTEGRATES Hadoop with all
(2)Capture processing states for sharing
(3)All of the mentioned options
(4)Using the right job tool
Answer-(3)All of the mentioned options

The Pig HCatalog INTERFACE is comprised of __________ for loading INTERFACES.
(1)HcatLoad
(2)HcatLoader
(3)NONE of the options
Answer:-(2)HcatLoader

HCatalog MAINTAINS a metastore CACHE of ________________.
(1)HiveServer
(2)HIVECLIENTS
(3)All of the mentioned
Answer:-(2)HiveClients

____________ METHOD is used to project SCHEMA and ____________ method is used to determine the table schema for a STIPULATED input table.
(1)setOutputSchema, getTableSchema
(2)HcatStorer, HCATLOADER
(3)setOutputSchema, HcatLoader
Answer:-(1)setOutputSchema, getTableSchema

______________ is USED to read the DATA from HCATALOG tables.
(1)HcatOutputFormat
(2)HcatInput
(3)HcatInputFormat
(4)Hcatoutput
Answer:-(3)HcatInputFormat

Which of the FOLLOWING option defines the reading entity in HcatReader?
SELECT the correct option from below list
(1)ReadEntity.Builder
(2)DataTransfer.Entity
(3)WriteEntity.Builder
Answer:-(1)ReadEntity.Builder

Which of the following API will generate instances for READERS and writers?
Select the correct OPTION from below list
(1)HcatReader
(2)DataTransferFactory
(3)HCatWriter
Answer:-(2)DataTransferFactory

Which of the following command will rename the department table to members?
OPTION 1: ./hcat f "ALTER TABLE department NAME TO members;"
Option 2: ./hcat p "ALTER TABLE department NAME TO members;"
Option 3; ./hcat e "ALTER TABLE department RENAME TO members;"
Select the correct option rom below LIST
(1)Option 2
(2)Option 1
(3)Option 3
Answer:-(3)Option 3

Which of the following options is the HCATINPUTFORMAT APIs?
Select the correct option rom below list
Option 1: setInput
Option 2: setOutputSchema
Option 3: getTableSchema
(1)Option 3
(2)Option 2
(3)Option 1
(4)all of the mentioned
Answer:-(4)all of the mentioned

HCatalog DOESNOT offer any SERVICE of notification.
Select the correct answer from below OPTION
(1)True
(2)False
Answer:-(2)False

The HCatLoader accepts a table to READ in data form, and you can indicate which partitions to scan
By IMMEDIATELY following the load statement with a partition filter statement.
(1)False
(2)TRUE
Answer:-(2)True

Which of the FOLLOWING options is the correct syntax to get a READERCONTEXT from a READER?
(1)ReaderContext cntxt = reader.prepareRead();
(2)ReaderContext cntxt = DataTransferFactory.getHCatReader();
(3)HCatReader cntxt = reader.prepareRead();
Answer:-(1)ReaderContext cntxt = reader.prepareRead();

_______________ with PIG scripts is used to write data to HCATALOG tables.
(1)None of the OPTIONS
(2)HcatLoader
(3)HcatStore
(4)HCatStorer
Answer:-(4)HCatStorer

HCatLoader with PIG scripts is USED to write DATA from HCatalog tables.
(1)TRUE
(2)False
Answer:-(2)False

Which of the following option is the main PURPOSE of HCatalog?
Select the correct option from LIST
(1)The purpose is to enable a range of clients to have COMMON ACCESS to the same data.
(2)HCatalog itself has a rather NARROW approach.
Answer:-(1)The purpose is to enable a range of clients to have common access to the same data.

Which of the FOLLOWING option is the CORRECT command to execute a HCatalog script?
Select the correct option from below list
Option 1:hcat.py -e create_table.HCatalog
Option 2: hcat.py -P create_table.HCatalog
Option 3: hcat.py -f create_table.HCatalog
(1)None of the OPTIONS.
(2)Option 3
(3)Option 2
(4)Option 1
Answer:-(2)Option 3

Which of the FOLLOWING option is the command to check if HCATALOG is present?
Select the CORRECT answer from below list
(1)hcat
(2)/.hcat
(3)./hcat
(4)None of the options.
Answer:-(3)./hcat

Which of the following option is the CORRECT command of executing DDL statements?
Option 1: hcat.py -e "create table MYTABLE(a int);"
Option 2: hcat.py -f "create table mytable(a int);"
Option 3: hcat.py -P "create table mytable(a int);"
Select the correct option from below
(1)Option 1
(2)None of the options
(3)Option 3
(4)Option 2
Answer:-(1)Option 1

Which of the FOLLOWING option is correct about HCatalog?
Select the correct option from below list
Option 1: HCatalog is a storage and MANAGEMENT layer for Hadoop.
Option 2: HCatalog table abstraction presents USERS with a relational view of the data in the HDFS.
Option 3: Users need not WORRY about where or in what format their data is stored.

(1)Option 2
(2)All of the options
(3)Option 3
(4)Option 1

Answer:-(2)All of the options

When you USE HCATALOG, then you donot have to use file paths or the schema.
Select the correct option from below list
(1)TRUE
(2)False
Answer:-(1)True

Which of the following OPTION will TELL Pig to use HCatalog?
Select the correct option from BEOW list
(1)pig -useHCatalog
(2)Pig -use HCatalog
(3)./pig use HCatalog
(4)pig
Answer:-(1)pig -useHCatalog