Finding out the data type of a value in Presto

Question

I'm getting values from nested maps and it's hard to figure out what data type each value is. Is there a typeof function that can tell me the data type of each value?

Stoughton

prestodb.io/docs/current/functions/conversion.html maybe this could help. – Diann

Answer 1

Yes, there is the typeof function:

presto> select typeof(1), typeof('a');
  _col0  |   _col1
---------+------------
 integer | varchar(1)
(1 row)

Marte