[jira] [Created] (HIVE-25662) JDBC driver returns " java.lang.IllegalArgumentException: Unrecognized type name: timestamp with local time zone('Europe/Madrid') in the table's introspection

["Inmaculada Domínguez Mira (Jira)" <ji...@apache.org>]

Inmaculada Domínguez Mira created HIVE-25662:
------------------------------------------------

             Summary: JDBC driver returns " java.lang.IllegalArgumentException: Unrecognized type name: timestamp with local time zone('Europe/Madrid') in the table's introspection
                 Key: HIVE-25662
                 URL: https://issues.apache.org/jira/browse/HIVE-25662
             Project: Hive
          Issue Type: Bug
          Components: Hive, JDBC, SQL, Types
    Affects Versions: 3.1.2, 3.1.1, 3.0.0
            Reporter: Inmaculada Domínguez Mira


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



--
This message was sent by Atlassian Jira
(v8.3.4#803005)