Delta lake connected via STS JDBC unable to get table columns meta data (using hive-jdbc)

[Mahendra Hegde]

Hello,

I am using hive-jdbc jar to connect delta lake using Spark Thrift Servre connection string.

I am able to read table data with simple sql etc.

But jdbc driver api is not able to get table columns details

DatabaseMetaData dmd = con.getMetaData();
ResultSet colrs = dmd.getColumns(null, "mh_test", "using_delta", "%");

This above line of code work for "hive" format table but not for "delta" format tables.

Any idea on the reason?

Alternatively is there any sql query for delta which can give all the details of columns a table? like nullable, length allowed, default value etc.
Describe kind of quries give only col name and type.

Thanks

Mahendra

This Electronic Mail (e-mail) contains confidential and privileged information intended only for the use of the individual or entity to which it is sent.  If the reader of this message is not the intended recipient, or the employee or agent responsible for delivery to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is STRICTLY PROHIBITED.  If you have received this communication in error, please immediately notify the sender by reply e-mail or telephone.