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 |
In which scenario Hive is good fit?
What are the different Primitive Data Types available in Hive?
How do you write your own SerDe?
What is the difference between the external table and managed table?
Can we change the data type of a column in a hive table?
What is the difference between Cassandra, Pig and Hive?
What is the difference between external table and managed table?
How will you convert the string ’51.2’ to a float value in the price column?
When to use Hive?
What do you understand by hive?
Explain about ACID transactions in Hive?
When you point a partition of a hive table to a new directory, what happens to the data?
Apache Hadoop (394)
MapReduce (354)
Apache Hive (345)
Apache Pig (225)
Apache Spark (991)
Apache HBase (164)
Apache Flume (95)
Apache Impala (72)
Apache Cassandra (392)
Apache Mahout (35)
Apache Sqoop (82)
Apache ZooKeeper (65)
Apache Ambari (93)
Apache HCatalog (34)
Apache HDFS Hadoop Distributed File System (214)
Apache Kafka (189)
Apache Avro (26)
Apache Presto (15)
Apache Tajo (26)
Hadoop General (407)