Hive Quiz – 1

Which of the following method will remove the spaces from both the ends of ” bigdata ” ?

What will be the output of
CONCAT_WS(‘|’,’hey’,’coder’,’how’,’are’,’you’)

How would you delete the data of hive table without deleting the table?

Which of the following function will remove duplicates?

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 ?

Which of the following is NOT a window function?

What is the extension of hive query file?

What is the output of regexp_replace(“pqrser”, “qr|er”, “”) ?

Which of the following function will return the size of string?

Which of the following will cast a column “a” having value 3.2 to 3 ?