What will be the result when you do cast(‘abc’ as int)?



What will be the result when you do cast(‘abc’ as int)?..

Answer / Brajesh Kumar Singh

"When casting a string 'abc' to an integer in Apache Hive using CAST function, it will return an error because 'abc' is not a valid integer value."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Apache Hive Interview Questions

Can you define serde in hive?

1 Answers  


What is the difference between Hbase and Hive?

1 Answers  


CONCAT function in Hive with Example?

1 Answers  


When to use explode in Hive?

0 Answers  


Explain the Differences between Hive and Spark SQL?

1 Answers  


what Hive query processor does?

1 Answers  


What will happen in case you have not issued the command?

1 Answers  


How to enable buckets in Hive?

1 Answers  


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

0 Answers  


What is bag?

1 Answers  


When executing Hive queries in different directories, why is metastore_db created in all places from where Hive is launched?

1 Answers  


What is the major difference between local and remote meta-store?

1 Answers  


Categories