datagrip / redis-jdbc-driver Goto Github PK

When trying to connect via spark, I get this exception:

Exception in thread "main" java.sql.SQLFeatureNotSupportedException
	at jdbc.RedisStatement.setQueryTimeout(RedisStatement.java:91)
	at org.apache.spark.sql.execution.datasources.jdbc.JDBCRDD$.getQueryOutputSchema(JDBCRDD.scala:67)
	at org.apache.spark.sql.execution.datasources.jdbc.JDBCRDD$.resolveTable(JDBCRDD.scala:58)
	at org.apache.spark.sql.execution.datasources.jdbc.JDBCRelation$.getSchema(JDBCRelation.scala:242)
	at org.apache.spark.sql.execution.datasources.jdbc.JdbcRelationProvider.createRelation(JdbcRelationProvider.scala:37)
	at org.apache.spark.sql.execution.datasources.DataSource.resolveRelation(DataSource.scala:350)
	at org.apache.spark.sql.DataFrameReader.loadV1Source(DataFrameReader.scala:228)
	at org.apache.spark.sql.DataFrameReader.$anonfun$load$2(DataFrameReader.scala:210)
	at scala.Option.getOrElse(Option.scala:121)
	at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:210)
	at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:171)
	at local.package.generate.Classname$.main(Sample.scala:57)

This is the code I am using, I assume that query param is not supported...
When I remove the line with query parameter, I get another error saying that "dbtable" or "query" params are mandatory.
When I try connecting without spark, everything works as expected and I am able to retrieve values.

sparkSession
      .read
      .format("jdbc")
      .option("url", "jdbc:redis://<password>@<host>:<port>?ssl=true")
      .option("driver", "jdbc.RedisDriver")
      .option("query", "keys startsWith*")
      .load()
      .printSchema()

Describe the bug
DataGrip throw exception as below when connect to AWS MemoryDB cluster even Redis CLI still connect and show correct version

Unable to get the server mode using the "INFO server" command to check if the connection mode matches the server mode.
No reachable node in cluster.

Steps to Reproduce

• Create a NAT instance to allow SSH port
• Create a MemoryDB on AWS: 1 shard 2 nodes
• Allow NAT instance connect to MemoryDB via port 6379
• Create a local tunnel ssh -vvvv -N -L 63790:xxx.clustercfg.memorydb.ap-northeast-1.amazonaws.com:6379 xxx-bastion
• Run Redis CLI redis-cli --verbose -h 127.0.0.1 -p 63790
• Check cluster info & info server

127.0.0.1:63790> cluster info
cluster_state:ok

127.0.0.1:63790> info server
# Server
redis_version:6.2.6
redis_git_sha1:0
redis_git_dirty:0
redis_build_id:0
redis_mode:cluster
os:Amazon MemoryDB

• Try to connect MemoryDB on DataGrip with host 127.0.0.1 and port 63790 and get exception

Platform Versions

• Redis CLI 6.0.1
• DataGrip 2023.2 Build #DB-232.8660.111, built on July 19, 2023
• Driver 1.4 stable
• MacOS Ventura 13.0.1

Expected behavior
DataGrip should connect to MemoryDB as Redis CLI instead of throw the exception

Thanks for publishing this JDBC driver, can you please add some some documentation?

When I enclose it with curly braces as indicated by the error message, I cannot obtain any results. like this:

but,when i use redis-cli to run this command, it`s ok

Platform Versions:
connection type: cluster
DataGrip: 2023.2
Driver: 1.4 stable
MacOS Ventura 13.5.1

Hi,
I have problem with connection to Azure Cache Redis and I'm not sure if it is possible or I did something wrong.
So far in my sevices I used connection string like: rediss://:[password]@[host]:6380. Default not ssl port is disabled by server configuration.

Tried Authentication "User & Password", "No Auth" with option Use SSL turned on and off and with parameter "sslprotocols=tls1.2" and "ssl=true".

DataGrip shows: "Failed to connect to any host resolved for DNS name."

Redis version: 6.0
Connection string works just fine with Jedis and Lettuce.

Thanks in advance.

Redis Console works fine on idea. But it is not convience to view full data with console.
Is it possible to support view data as a table?

Having it available in a repository would greatly simplify its use.

Thank you!

Is simply, faster, or stable?