search

mmsmdali / dremio-clickhouse-arp-connector

Dremio ARP driven connector that supports ClickHouse Columnar Database
Apache License 2.0
12 stars 8 forks source link

ParseException: Unparseable date: #1

Open haochihaokan opened 4 years ago

haochihaokan commented 4 years ago

I was able to build the connector and connect to clickhouse using this connector and this driver https://community.dremio.com/t/incorrect-datasource-schema-generated/4906/9 (which fixed the problem of one more layer of "default" schema generated if using the official clickhouse driver. And the other two drivers you included does not work with my settings.) I tried both the connector in the link above and the connector I build using this github source code. But I'm getting errors like "ParseException: Unparseable date: XXXXX" when running the query in Dremio. I’m not sure if it is the connector or the clickhoue jbdc driver's problem. I thought it might be data type mapping settings in the clickhouse-arp.yaml file.

mmsmdali commented 4 years ago

It works with Dremio version 4.1.8-202003120636020140-9c2a6b13 as mentioned in [pom.xml] through both official ClickHouse JDBC driver as well as third party alternative for the official ClickHouse JDBC driver but NOT with third party ClickHouse Native JDBC driver, which doesn't meet the Dremio's requirements. I'll update the connector to work with recent version of Dremio shortly. Can you please share the version of dremio which you are using?

haochihaokan commented 4 years ago

It works with Dremio version 4.1.8-202003120636020140-9c2a6b13 as mentioned in pom.xml through both official ClickHouse JDBC driver as well as third party alternative for the official ClickHouse JDBC driver but NOT with third party ClickHouse Native JDBC driver, which doesn't meet the Dremio's requirements. I'll update the connector to work with recent version of Dremio shortly. Can you please share the version of dremio which you are using?

Thank you for the reply. I'm using 3.3.2-201908142136370993-d60145d in a Windows environment which is no longer supported in the newer version.

mmsmdali commented 4 years ago

I'm unable to find the source code of Dremio version works under Windows environment. Can you please share the source code of Dremio version 3.3.2-201908142136370993-d60145d, so that i can try it out.

haochihaokan commented 4 years ago

I'm unable to find the source code of Dremio version works under Windows environment. Can you please share the source code of Dremio version 3.3.2-201908142136370993-d60145d, so that i can try it out.

The download link of the exe file is here: https://download.dremio.com/community-server/3.3.2-201908142136370993-d60145d/

Sorry I don’t know where the source code is.

mmsmdali commented 4 years ago

I know about the above link. But I need the source to see the pom.xml and other configurations, so that I can modify the ARP connector pom.xml and compile. Anyway I'll try other ways and make the ARP connector work for Dremio version for Windows...

mmsmdali commented 2 years ago

Hi now it works with latest Dremio 20.1.0 & connects latest ClickHouse v22.3.3.44-lts through latest official ClickHouse JDBC driver v0.3.2-patch8 in Linux Environment.