Defining Value Data Type in Presto

Question

I get values ​​from nested maps, and it's hard to understand what data type each value has. Is there a function typeofthat can tell me the data type for each value?

Answer 1

Yes, there is a function : typeof

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