databricks-sql-nodejs icon indicating copy to clipboard operation
databricks-sql-nodejs copied to clipboard

Published 20 hours ago • verified publisher icon databricks

Array<TIMESTAMP> Returns an empty list

Open Dannystu12 opened this issue 2 years ago • 3 comments

Hi,

When I SELECT * from a table with columns containing an Array of TIMESTAMPS I always get back an empty list. Array of STRING seems to work perfectly fine as well as columns of type TIMESTAMP.

Dannystu12 avatar Mar 15 '23 10:03 Dannystu12

Hi @Dannystu12! Your issue is related to databricks/databricks-sql-nodejs#103 - date/time values anywhere in complex structures, and also any complex structure used as map key, lead to malformed JSON which cannot be parsed on client. Yesterday we merged support for Arrow-based results and very soon we'll cut a release with it - it should help in such cases. Sorry for the inconvenience

kravets-levko avatar Mar 15 '23 12:03 kravets-levko

is this issue open to contribution @kravets-levko ?

vishalsingh2972 avatar Aug 09 '23 05:08 vishalsingh2972

@Dannystu12 did you have a chance to try newer versions of Nodejs connector? Is this issue still relevant? Thank you!

kravets-levko avatar Apr 11 '24 14:04 kravets-levko