Build a include and expand feature into the ReJson module to fetch parts of large JSON documents about redisjson HOT 8 CLOSED

@aniruddhadas
I can confirm it supports multi-level selects:

> JSON.SET key2 . '{"a":"1", "b": { "x" : 45, "y" : 21 }, "c":"1"}'
OK
> JSON.GET key2 a b.x
"{\"a\":\"1\",\"b.x\":45}"

from redisjson.

Hi. This sounds a lot like what this module does already. Can you please show an example of input/output that you've tried, and what kind of change you want to see in the current module, and why?

from redisjson.

Hi. The problem is rejson only pulls out one attribute, we store large json documents in redis. We are looking for some way to pull out multiple parts from the json document in a single call. for e.g.:
document in redis: key1: {'a':'1', 'b':'1', 'c':'1'}. We want to pull out a and c from the document so something like
Input: JSON.GET key .a .c
Output: key1: {'a':'1', 'c':'1'}

from redisjson.

+1 This would be a really useful feature to have.

from redisjson.

Hello @aniruddhadas,

Please read the docs and/or experiment - ReJSON's JSON.GET already supports multiple paths:

127.0.0.1:6379> JSON.SET key1 . '{"a":"1", "b":"1", "c":"1"}'
OK
127.0.0.1:6379> JSON.GET key1 a b
"{\"a\":\"1\",\"b\":\"1\"}"

I believe this issue can be closed.

Cheers,
Itamar

from redisjson.

Thanks @itamarhaber! This is awesome! One quick questions, does this support multi level selects or index based selects?

JSON.SET key1 . '{"a":"1", "b":"1", "c":"{ "x":"1" }"}'
JSON.GET key1 a c.x?

We use jedis. I dont think Jedis supports this ReJson but we can work around it.

from redisjson.

Thanks @stockholmux, @mnunberg and @itamarhaber for the quick feedback! This is awesome! Adding documentation link here for completeness: https://github.com/RedisLabsModules/rejson/blob/master/docs/commands.md#jsonget

I will close this.

from redisjson.

@aniruddhadas the latest docs should also be always available online at https://oss.redislabs.com/rejson/commands/#jsonget

Happy hacking!

from redisjson.