Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-25662

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

    XMLWordPrintableJSON

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

      Attachments

        Activity

          People

            Unassigned Unassigned
            idominguez Inmaculada Domínguez Mira
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: