Interview Questions and Answers

Example:

SELECT * FROM table_name;

Example:

SELECT column1, column2 FROM table_name WHERE condition;

Example:

SELECT * FROM table_name LIMIT 10;

Example:

LOAD DATA INPATH '/path/to/data' INTO TABLE table_name;

Example:

CREATE TABLE sorted_table (column1 INT, column2 STRING) SORT BY column1;

Example:

SELECT * FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.id;

Example:

SELECT column1, COALESCE(column2, 'NA') FROM table_name;

Example:

SELECT * FROM table_name TABLESAMPLE(BUCKET x OUT OF total);

Example:

EXPLAIN SELECT * FROM table_name;