Redis Connector to Trino

[Anastasis Aglogallos]

The code provided by the trino documentation to be used in the trino/etc/catalog is the code below: Inside the redis.connector write : connector.name=redis redis.table-names=schema1.table1,schema1.table2 redis.nodes=host:portMy question is : What is the schema1.table1 in redis ? I added data through the cli and since Redis is No-sql I think there is no table structure or schema.Is it possible to determine where my data is stored ? Or what is their structure ? 

When I used the redis-cli info command 
I got the following for my Keyspace: 

#Keyspace 
dbo:key=3, expires=0, avg_tt1=0

[Greg Andrews]

When I look up the Trino documentation on-line, I find the page describing the Redis connector here:  https://trino.io/docs/current/connector/redis.html

After the first paragraph, it says:

    Each Redis key/value pair is presented as a single row in Trino. Rows can be broken down into cells by using table definition files.

    Currently, only Redis key of string and zset types are supported, only Redis value of string and hash types are supported.

Farther down the page the table definition files and other configuration parameters (of the Trino connector, not of Redis) are described.  I think the information you need is there in the documentation page, it's just spread out among multiple config parameters.

I haven't used an application like Trino before, so I can't give you any more specific pointers on what Redis info to put into these config parameters.

[Anastasis Aglogallos]

Thank you for the reply, 

You are right the solution was indeed on the documentation page and I couldn't understand it.

The solution is the following : 
Set the 

redis.hide-internal-columns = false 

So for the connector you need the following code 

connector.name=redis redis.table-
names=schema1.table1,schema1.table2 
redis.nodes=host:port //default port is 6379
redis.hide-internal-columns = false 

--
You received this message because you are subscribed to the Google Groups "Redis DB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redis-db+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/redis-db/8dd08902-9c81-4930-abfc-9e632654d3den%40googlegroups.com.