[
https://issues.apache.org/jira/browse/HIVE-25662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17441211#comment-17441211
]
Karen Coppage commented on HIVE-25662:
--------------------------------------
Are you using Hive CLI by any chance?
> 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.0.0, 3.1.1, 3.1.2
> Reporter: Inmaculada Domínguez Mira
> Priority: Blocker
> Labels: hive3, localtimezone, timestamp
>
> 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.20.1#820001)
