ResultSet metadata does not return correct type for TIMESTAMP_NTZ

[EricCournarie]

Hello, using the JDBC driver, when I retrieve the metadata of a ResultSet, the type for a TIMESTAMP_NTZ is not correct (it's a TIMESTAMP one).

My SQL is a simple SELECT * on a table where you have a TIMESTAMP_NTZ column

This works when retrieving metadata for a table , where the correct type is retrieved.

Thanks for your help

Eric

[saurabh18cs]

Hi @EricCournarie  I think this is a JDBC driver limitation. Looks it reports generic type which is TIMESTAMP.

[Khaja_Zaffer]

Hello @EricCournarie 

Good day!!

This is explicitly noted in the Databricks documentation for the TIMESTAMP_NTZ type 

"TIMESTAMP_NTZ is not supported in Databricks JDBC/ODBC drivers or Databricks open source drivers."

the workaround is mentioned here: https://docs.databricks.com/aws/en/sql/language-manual/data-types/timestamp-ntz-type 

You can use TIMESTAMP or TIMESTAMP_LTZ in your table schema instead, as these are fully supported.

[EricCournarie]

Hi, thanks for the response !

ok,as it was working on table metadata, I thought the doc was not up to date.. so it's partially supported. 

do you know if there is any chance it will be fully supported in some 'near' future ?

Thanks

[szymon_dybczak]

Hi @EricCournarie ,

It seems that they added support for timestamp_ntz in open source version of the driver. At least, following PR suggest that. Try to use OSS driver version and maybe it will work 🙂

[PECOBLR-108]support timestamp_ntz by shivam2680 · Pull Request #725 · databricks/databricks-jdbc · ...

[EricCournarie]

Hello, I did try switching to the OSS version , but it does not fix my problem

Thanks for your help anyway

[Khaja_Zaffer]

hello @EricCournarie 

Thank you for your reply. 

You must contact your databricks account team(usually every company has a databricks account team) OR raise a ticket this link  https://help.databricks.com/s/contact-us?ReqType=training explaining the issue clearly so that it will be easy for supoort team to help easily.

Depending upon many such request or urgency they will start implementing the feature request.

[Advika]

Hello @EricCournarie!

Just to confirm, were you initially using the JDBC driver v2.7.3? According to the release notes, this version adds support for the TIMESTAMP_NTZ data type.

[EricCournarie]

Yes, I was using the latest driver version