Hive Quiz – 1

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

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

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

Which of the following is NOT a window function?

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

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

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 ?

What is the extension of hive query file?

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