Querying with Hive MCQ question and answer with solution

Home

Competitive Exams MCQs

Aptitude English Verbal Reasoning Non Verbal Reasoning General Knowledge(GK) General Science(GS) Data Interpretation(DI) Banking Awareness Current Affairs

Computer Fundatmental MCQs

Computer Fundamentals Microsoft Word Microsoft Excel MS Power Point Tally Operating System Python AI(Artificial Intelligence)

Engineering Subjects MCQs

Computer Science Electronics & Communication Mechanical Engineering Civil Engineering Electrical Engineering

More Engineering MCQs

Chemical Engineering Automobile Engineering Biotechnology Mining Engineering Geological Engineering Metallurgical Engineering

Engineering Core

Engineering Mathematics Engineering Physics Engineering Chemistry

Computer Fundamentals MCQs

Computer Fundamentals Microsoft Word Microsoft Excel MS Power Point Tally Operating System Networking Database SQL MySQL

Programming MCQs

C Programming C++ Programming Java Python PHP JavaScript

Advanced Programming MCQs

Artificial Intelligence Machine Learning Data Science Cloud Computing Hadoop IoT

Graduation & PG

Commerce Management Law Agriculture Sociology Psychology Home Science Mass Communication Political Science Psychology

Resources

Current Affairs Interview Blog

Exam Categories

SSC Exams Railway Exams All Exams

SSC Exams

SSC CGL SSC CHSL SSC MTS SSC CPO SSC GD SSC JHT SSC Selection Post SSC Stenographer SSC JE

Railway Exams

RRB ALP RRB Technician RRB Section Controller RRB JE RRB Paramedical RRB Group D

Popular Exams

SSC CGL SSC CHSL SSC MTS RRB NTPC (Graduate) RRB Group D RRB ALP RRB Technician RRB Section Controller

Point out the correct statement.

A) -helpusage display a usage message B) The JDBC connection URL format has the prefix jdbc:hive: C) Starting with Hive 0.14, there are improved SV output formats D) None of the mentioned

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

Types that may be null must be defined as a . . . . . . . . of that type and Null within Avro.

A) Union B) Intersection C) Set D) All of the mentioned

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

Which of the following is a command line option?

A) -d,–define <key=value> B) -e,–define <key=value> C) -f,–define <key=value> D) None of the mentioned

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

Which of the following operator executes a shell command from the Hive shell?

A) | B) ! C) ^ D) +

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

Which is the additional command line option is available in Hive 0.10.0?

A) -database <dbname> B) -db <dbname> C) -dbase <<dbname> D) All of the mentioned

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

Integral literals are assumed to be . . . . . . . . by default.

A) SMALL INT B) INT C) BIG INT D) TINY INT

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

Point out the wrong statement.

A) TIMESTAMP is Only available starting with Hive 0.10.0 B) DECIMAL introduced in Hive 0.11.0 with a precision of 38 digits C) Hive 0.13.0 introduced user definable precision and scale D) All of the mentioned

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

Hive uses . . . . . . . . style escaping within the strings.

A) C B) Java C) Python D) Scala

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

Which of the following data type is converted to Array prior to Hive 0.12.0?

A) map B) long C) float D) bytes

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

Point out the correct statement.

A) Hive Commands are non-SQL statement such as setting a property or adding a resource B) Set -v prints a list of configuration variables that are overridden by the user or Hive C) Set sets a list of variables that are overridden by the user or Hive D) None of the mentioned

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

1 2 3 4 5 6 7

Querying with Hive MCQ question and answer with solution | Hadoop MCQs