We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Sql TIME data type is not fully supported by unixODBC driver — Vertica Forum

Sql TIME data type is not fully supported by unixODBC driver

Hi!

SQL standard defines data type TIME with precision, i.e. "HH:MM:SS.MSEC" , but unixODBC driver do not supports in floating point for TIME.

isql
daniel@synapse:~$ isql Vertica
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select '13:14:15.161718'::TIME;
+---------+
| ?column?|
+---------+
| 13:14:15|
+---------+

Looks like ODBC isn't supported (sorry, but its very hard to call it as "supported"):
  • no support for all data types (for Python its even worst - no support for intervals)
  • no support for profiling (you have to do some workaround to get query profiled via connectivity drivers)
  • no driver support for special Vertica features
  • can't process TIME ZONE because Vertica converts all to UTC and returns incorrect results (incorrect time zone).
No, it isn't calls as "protocol support".

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file