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 mentioned

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 mentioned
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

Point out the correct statement.(a) YARN also extends the power of Hadoop to incumbent and new technologies found within the data center(b) YARN is the central point of investment for Hortonworks within the Apache community(c) YARN enhances a Hadoop compute cluster in many ways(d) All of the mentioned
________ is the architectural center of Hadoop that allows multiple data processing engines.(a) YARN(b) Hive(c) Incubator(d) Chuckwa
___________ is used to decommission more than one RegionServer at a time by creating sub-znodes.(a) /hbase/master(b) /hbase/draining(c) /hbase/passive(d) None of the mentioned
Zookeeper keep track of the cluster state such as the ______ table location.(a) DOMAIN(b) NODE(c) ROOT(d) All of the mentioned
_______ has a design policy of using ZooKeeper only for transient data.(a) Hive(b) Imphala(c) Hbase(d) Oozie
A ___________ server is a machine that keeps a copy of the state of the entire system and persists this information in local log files.(a) Master(b) Region(c) Zookeeper(d) All of the mentioned
The ________ master will register its own address in this znode at startup, making this znode the source of truth for identifying which server is the Master.(a) active(b) passive(c) region(d) all of the mentioned
Point out the wrong statement.(a) All the znodes are prefixed using the default /hbase location(b) ZooKeeper provides an interactive shell that allows you to explore the ZooKeeper state(c) The znodes that you’ll most often see are the ones that coordinate operations like Region Assignment(d) All of the mentioned
When a _______ is triggered the client receives a packet saying that the znode has changed.(a) event(b) watch(c) row(d) value
Which of the following command does not operate on tables?(a) enabled(b) disabled(c) drop(d) all of the mentioned

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 mentioned

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment