adspace


How to change the column data type in hive? Explain rlike in hive.

Answer Posted / Anish Kumar Pandey

To change the column data type in Hive, you can use the ALTER TABLE command followed by the CHANGE COLUMN statement. Regarding rlike, it is a regular expression pattern for case-insensitive matching in Hive.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a Hive variable? What for we use it?

880


When we are using queries instead of scripting?

801


When to use explode in Hive?

832


What are the different types of tables available in Hive?

767


What is the stable version of Hive ?

2695


Can We Change settings within Hive Session? If Yes, How?

859


How to skip header rows from a table in Hive?

907


Where does the data of a Hive table gets stored?

750


How can I delete the above index named index_bonuspay?

807


When to choose "External Table" in Hive?

867