How will you convert the string ’51.2’ to a float value in the price column?



How will you convert the string ’51.2’ to a float value in the price column?..

Answer / Shishir Tiwari

"To convert a string into a float value for the price column in Apache Hive, you can use the CAST function: CAST('51.2' AS FLOAT)."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Apache Hive Interview Questions

In which scenario Hive is good fit?

1 Answers  


What are the different Primitive Data Types available in Hive?

1 Answers  


How do you write your own SerDe?

1 Answers  


What is the difference between the external table and managed table?

1 Answers  


Can we change the data type of a column in a hive table?

1 Answers  


What is the difference between Cassandra, Pig and Hive?

1 Answers  


What is the difference between external table and managed table?

1 Answers  


How will you convert the string ’51.2’ to a float value in the price column?

1 Answers  


When to use Hive?

1 Answers  


What do you understand by hive?

1 Answers  


Explain about ACID transactions in Hive?

1 Answers  


When you point a partition of a hive table to a new directory, what happens to the data?

1 Answers  


Categories