What will be the output of cast ('XYZ' as INT)?



What will be the output of cast ('XYZ' as INT)?..

Answer / Ran Bahadur Singh

The output of casting a string 'XYZ' to an integer in Hive will result in an error, as 'XYZ' is not a valid integer.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Apache Hive Interview Questions

What are collection data types in Hive?

1 Answers  


How Facebook Uses Hadoop, Hive and Hbase ?

1 Answers  


Mention what is ObjectInspector functionality in Hive?

1 Answers  


What do you mean by schema on read?

1 Answers  


Differentiate between PigLatin and Hive?

1 Answers  


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

1 Answers  


Mention what are the type of database does Hive support ?

1 Answers  


Does Pig give any warning when there is a type mismatch or missing field?

1 Answers  


Explain process to access sub directories recursively in hive queries.

1 Answers  


What is Hive Present Version ?

1 Answers  


How do you write your own SerDe?

1 Answers  


What are hive operators and its types?

1 Answers  


Categories