InterviewSolution
Saved Bookmarks
InterviewSolution
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.
| 51. |
HiveServer2 introduced in Hive 0.11 has a new CLI called __________(a) BeeLine(b) SqlLine(c) HiveLine(d) CLilLineThis question was addressed to me in quiz.Enquiry is from HiveQL in chapter Hive and HBase of Hadoop |
|
Answer» The CORRECT ANSWER is (a) BeeLine |
|
| 52. |
Point out the correct statement.(a) list FILE[S] *executes a Hive query and prints results to standard output(b) executes a Hive query and prints results to standard output(c) executes a Hive query and prints results to standard output(d) All of the mentionedI have been asked this question in unit test.Query is from HiveQL topic in chapter Hive and HBase of Hadoop |
|
Answer» The correct answer is (b) |
|
| 53. |
Hive uses _________ for logging.(a) logj4(b) log4l(c) log4i(d) log4jI had been asked this question in quiz.The doubt is from HiveQL topic in portion Hive and HBase of Hadoop |
|
Answer» CORRECT choice is (d) log4j For explanation I WOULD say: By DEFAULT Hive will USE hive-log4j.default in the conf/ directory of the Hive installation. |
|
| 54. |
_________ is a shell utility which can be used to run Hive queries in either interactive or batch mode.(a) $HIVE/bin/hive(b) $HIVE_HOME/hive(c) $HIVE_HOME/bin/hive(d) All of the mentionedThe question was asked in an internship interview.I'd like to ask this question from Introduction to Hive topic in section Hive and HBase of Hadoop |
|
Answer» The CORRECT CHOICE is (c) $HIVE_HOME/bin/hive |
|
| 55. |
Point out the wrong statement.(a) source FILE executes a script file inside the CLI(b) bfs executes a dfs command from the Hive shell(c) hive is Query language similar to SQL(d) none of the mentionedThis question was posed to me by my school principal while I was bunking the class.This interesting question is from Introduction to Hive in chapter Hive and HBase of Hadoop |
|
Answer» RIGHT option is (B) bfs Explanation: dfsexecutes a dfs command from the Hive shell. |
|
| 56. |
Which of the following will remove the resource(s) from the distributed cache?(a) delete FILE[S] *(b) delete JAR[S] *(c) delete ARCHIVE[S] *(d) all of the mentionedThis question was posed to me in quiz.Asked question is from Introduction to Hive topic in section Hive and HBase of Hadoop |
|
Answer» RIGHT OPTION is (d) all of the mentioned The explanation: Delete command is USED to remove existing RESOURCE. |
|
| 57. |
Which of the following operator executes a shell command from the Hive shell?(a) |(b) !(c) ^(d) +The question was asked in examination.Asked question is from Introduction to Hive topic in portion Hive and HBase of Hadoop |
|
Answer» RIGHT answer is (B) ! The EXPLANATION is: EXCLAMATION operator is for execution of command. |
|
| 58. |
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 mentionedThe question was posed to me by my college professor while I was bunking the class.My question is taken from Introduction to Hive topic in division Hive and HBase of Hadoop |
|
Answer» CORRECT CHOICE is (a) Hive Commands are non-SQL statement such as setting a property or adding a resource Easiest explanation: Commands can be used in HiveQL SCRIPTS or directly in the CLI or BEELINE. |
|
| 59. |
Which of the following command sets the value of a particular configuration variable (key)?(a) set -v(b) set =(c) set(d) resetThe question was asked during an online interview.My question is based upon Introduction to Hive in chapter Hive and HBase of Hadoop |
|
Answer» CORRECT option is (B) set Best EXPLANATION: If you misspell the variable name, the CLI will not show an ERROR. |
|