-
Notifications
You must be signed in to change notification settings - Fork 26
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Additional parameters for connection, namely, 'secure' and 'verify'? #77
Comments
+1 |
Thanks for bringing this up. Indeed, neither secure nor verify are supported right now. The reason is that this client is internally based on the official c++ client. AFAIK the c++ client does not support these features right now, but we'll investigate it. Furthermore, we are also planning a major rewrite of the communication parts were we'll consider it. |
Good news! It looks like SSL support has been added |
Nice to hear, but we are currently relying on an older version of the client. The newer one, which you are referring to, requires C++17 (or higher). Although R/Rcpp (partly) supports C++17, it would require a c++17 compiler, which is not always the case. I would love to switch to the latest versions, but as package developers, we have to scarify functionality and fancy features for the sake of supporting as many platforms as possible. In this case it even hurts since this would greatly benefit security. Nevertheless, we'll discuss this issue internally and evaluate all possibilities (e.g., backporting, switching the backend, upgrading to cpp17) - this issue stays open in the meanwhile. |
Hi Because we needed secure connection to our ClickHouse instances and since it is not yet supported by RClickhouse, I've developed a ClickHouse R DBI based on ClickHouse HTTP interface. It supports HTTP and HTTPS connections (with or without ssl peer verification). It's available on CRAN (https://cran.r-project.org/package=ClickHouseHTTP) and github (https://github.com/patzaw/ClickHouseHTTP). It is slower than RClickhouse (mainly because of data format transformation). Thus, if you don't need SSL, I recommend to still use RClickhouse package. I hope it helps anyway |
@patzaw Thanks for the great work! I see your point with the ssl-connection, but two packages with such a similar functionality are not really needed (and hard to maintain). If you want, we can merge our efforts. In particular, we could add a small abstraction layer and share common parts (e.g., dplyr level). As I already indicated in my last post, we already thought of supporting the HTTP interface. |
Hi @inkrement |
Hi,
In my organization I can connect with Clickhouse in Python with the code:
However, there are no such parameters as
secure
andverify
in RClickhouse.If I omit these parameters in R:
I got an error:
I also tried to pass parameters via the xml file but without success.
Are there any way connect with Clickhouse in R with such type of connection? Or, is it possible to add 'secure' and 'verify' as arguments for connection in the future version of RClickhouse?
The text was updated successfully, but these errors were encountered: