Hive interview questions - 1

1. What is the syntax of Creating table in hive
CREATE TABLE records (year STRING, temperature INT, quality INT)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t';

2. How to populate Hive with the data
LOAD DATA LOCAL INPATH 'input/ncdc/micro-tab/sample.txt'
OVERWRITE INTO TABLE records;
Running this command tells Hive to put the specified local file in its warehouse directory.The OVERWRITE keyword in the LOAD DATA statement tells Hive to delete any existing files in the directory for the table.

3. Where can we see hive table location ?
Tables are stored as directories under Hive’s warehouse directory, which is controlled by the hive.metastore.warehouse.dir and defaults to /user/hive/warehouse.Thus, the files for the records table are found in the /user/hive/warehouse/records directory on the local filesystem:
% ls /user/hive/warehouse/records/
  <property>
    <name>hive.metastore.warehouse.dir</name>
    <value>/user/hive/warehouse</value>
  </property>

4. Where can we see the Configuration file in Hive ?
Hive is configured using an XML configuration file like Hadoop’s. The file is called hive-site.xml and is located in Hive’s conf directory. The contains hivedefault.xml, which documents the properties that Hive exposes and their default values.You can override the configuration directory that Hive looks for in hive-site.xml bypassing the --config option to the hive command:
% hive --config /Users/tom/dev/hive-conf same directory

5. How to do Warehouse sharing for multiple users ?
More than one Hive user sharing a Hadoop cluster, you need to make the directories that Hive uses writable by all users. The following commands will create the directories and set their permissions appropriately:
% hadoop fs -mkdir /tmp
% hadoop fs -chmod a+w /tmp
% hadoop fs -mkdir -p /user/hive/warehouse
% hadoop fs -chmod a+w /user/hive/warehouse

6. What is SET -v ?
SET -v  to list all the properties in the system,including Hadoop defaults.


12345678910