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

Point out the correct statement.(a) Hive Commands are non-SQL statemen

1.	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.

Discussion

No Comment Found

Related InterviewSolutions

__________ command disables drops and recreates a table.(a) drop(b) truncate(c) delete(d) none of the mentionedI had been asked this question in a national level competition.This key question is from Schema Design in HBase topic in section Hive and HBase of Hadoop
Which command is used to disable all the tables matching the given regex?(a) remove all(b) drop all(c) disable_all(d) all of the mentionedI got this question in homework.This key question is from Schema Design in HBase topic in section Hive and HBase of Hadoop
__________ does re-write data and pack rows into columns for certain time-periods.(a) OpenTS(b) OpenTSDB(c) OpenTSD(d) OpenDBThe question was asked during an internship interview.My doubt stems from Schema Design in HBase in portion Hive and HBase of Hadoop
The _________ suffers from the monotonically increasing rowkey problem.(a) rowkey(b) columnkey(c) counterkey(d) all of the mentionedI got this question in an online quiz.I would like to ask this question from Schema Design in HBase topic in section Hive and HBase of Hadoop
Point out the wrong statement.(a) Where time-ranges are very wide (e.g., year-long report) and where the data is voluminous, summary tables are a common approach(b) Coprocessors act like RDBMS triggers(c) HBase does not currently support ‘constraints’ in traditional (SQL) database parlance(d) None of the mentionedI have been asked this question during an internship interview.My question is from Schema Design in HBase in chapter Hive and HBase of Hadoop
One supported data type that deserves special mention are ____________(a) money(b) counters(c) smallint(d) tinyintThis question was posed to me during an interview.My doubt is from Schema Design in HBase in chapter Hive and HBase of Hadoop
HBase supports a ____________ interface via Put and Result.(a) “bytes-in/bytes-out”(b) “bytes-in”(c) “bytes-out”(d) none of the mentionedThis question was posed to me in quiz.My doubt stems from Schema Design in HBase in division Hive and HBase of Hadoop
Point out the correct statement.(a) The default for max versions is 1(b) It is recommended setting the number of max versions to an exceedingly high level(c) HBase does overwrite row values(d) All of the mentionedThe question was asked in an internship interview.I'm obligated to ask this question of Schema Design in HBase topic in division Hive and HBase of Hadoop
The minimum number of row versions to keep is configured per column family via _____________(a) HBaseDecriptor(b) HTabDescriptor(c) HColumnDescriptor(d) All of the mentionedI have been asked this question in an internship interview.My doubt stems from Schema Design in HBase in chapter Hive and HBase of Hadoop
_________ command fetches the contents of a row or a cell.(a) select(b) get(c) put(d) none of the mentionedThe question was asked in an interview for internship.My question is from Introduction to HBase in chapter Hive and HBase of Hadoop

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment