Hive Quiz – 1

Welcome to your Hive Quiz - 1

1. Which of the following method will remove the spaces from both the ends of  " bigdata "  ?
2. How would you delete the data of hive table without deleting the table?
3. Which of the following will cast a column "a" having value 3.2 to 3 ?
4. You have one column in hive table named as "my_ts" having datatype as string and sample value like "2018-02-24 17:22:35". how would you extract only day from it i.e. 24 ?
5. What is the extension of hive query file?
6. Which of the following is NOT a window function?
7. Which of the following function will remove duplicates?
8. What will be the output of 
CONCAT_WS('|','hey','coder','how','are','you')
9. Which of the following function will return the size of string?
10. What is the output of regexp_replace("pqrser", "qr|er", "")  ?

Load CSV file into hive AVRO table

Requirement You have comma separated(CSV) file and you want to create Avro table in hive on top of it, then ...
Read More

Load CSV file into hive PARQUET table

Requirement You have comma separated(CSV) file and you want to create Parquet table in hive on top of it, then ...
Read More

Hive Most Asked Interview Questions With Answers – Part II

What is bucketing and what is the use of it? Answer: Bucket is an optimisation technique which is used to ...
Read More
/ hive, hive interview, interview-qa

Spark Interview Questions Part-1

Suppose you have a spark dataframe which contains millions of records. You need to perform multiple actions on it. How ...
Read More

Leave a Reply