datafusion
datafusion copied to clipboard
a `arrow_typeof` like posgresql's `pg_typeof`
Is your feature request related to a problem or challenge? Please describe what you are trying to do. A clear and concise description of what the problem is. Ex. I'm always frustrated when [...] (This section helps Arrow developers understand the context and why for this feature, in addition to the what)
sometimes it's not that easy to know the output type. e.g.
❯ select now();
+----------------------------+
| now() |
+----------------------------+
| 2022-08-10 06:36:01.967605 |
+----------------------------+
1 row in set. Query took 0.000 seconds.
i thought that it's a Timestamp(Nanosecond, None)
until
❯ select now() + 1;
Plan("'Timestamp(Nanosecond, Some(\"UTC\")) + Int64' can't be evaluated because there isn't a common type to coerce the types to")
Describe the solution you'd like A clear and concise description of what you want to happen.
A arrow_typeof
to output the type like this
❯ select arrow_typeof(now());
+---------------------------------------+
| arrowtypeof(now()) |
+---------------------------------------+
| Timestamp(Nanosecond, Some("UTC") |
+---------------------------------------+
1 row in set. Query took 0.000 seconds.
Describe alternatives you've considered A clear and concise description of any alternative solutions or features you've considered.
Additional context Add any other context or screenshots about the feature request here.