Which of the following statement will create a column with varchar datatype?(a) CREATE TABLE foo (bar CHAR(10))(b) CREATE TABLE foo (bar VARCHAR(10))(c) CREATE TABLE foo (bar CHARVARYING(10))(d) All of the mentionedThis question was posed to me during an interview.Question is taken from Querying Data with HiveQL topic in chapter Hive and HBase of Hadoop

Which of the following statement will create a column with varchar dat

1.	Which of the following statement will create a column with varchar datatype?(a) CREATE TABLE foo (bar CHAR(10))(b) CREATE TABLE foo (bar VARCHAR(10))(c) CREATE TABLE foo (bar CHARVARYING(10))(d) All of the mentionedThis question was posed to me during an interview.Question is taken from Querying Data with HiveQL topic in chapter Hive and HBase of Hadoop
Answer» RIGHT OPTION is (b) CREATE TABLE FOO (bar VARCHAR(10)) Explanation: Varchar datatype was INTRODUCED in Hive 0.12.0

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