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", "")  ?

Join in hive with example

Requirement You have two table named as A and B. and you want to perform all types of join in ...
Read More

Join in pyspark with example

Requirement You have two table named as A and B. and you want to perform all types of join in ...
Read More

Join in spark using scala with example

Requirement You have two table named as A and B. and you want to perform all types of join in ...
Read More

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.