Details
Description
I have created in Hive 3.1.1 the following table:
CREATE TABLE `hive.timestamps_hive3`(
`localdate_field` date,
`timestamp_field` timestamp,
`timestamptz_field` timestamp with local time zone
)
Then I hve inserted one row:
insert into `hive.timestamps_hive3` values
(DATE '2017-03-26',TIMESTAMP '2017-03-26 01:01:02.345000','2017-03-25 17:01:02.345-07:00')
Both of these sentences have gone ok but when I try to get the columns from the created table, the following error appears:
SQL Error: java.lang.IllegalArgumentException: Unrecognized type name: timestamp with local time zone('Europe/Madrid')
I have used some JDBC clients to connect to this schema/table with the same error therefore I understand the problem is in the JDBC driver.
Some help woulb be very appreciate because it is blocking my project.
REgards and thanks in advance
Inma