ReQL is the RethinkDB query language. It offers a convenient way to manipulate JSON documents.
ReQL is the RethinkDB query language. It offers a convenient way to manipulate JSON documents.
Questions tagged [reql]
99 questions
0
votes
1 answer
how to filter out non-numeric values
I have a table (in a RethinkDB database) that has a bunch of documents with the field VIN0. This field almost always stores numbers, as intended.
I had some data corruption recently where there are some strings in place of numbers for the field…
Heath Westbrook
- 23
- 2
0
votes
1 answer
How to inner join two tables by one table's pid with other table's embeded array field value?
(sorry,the question title is quite awkward)
Hello,I have two table with data like this:
//friend_group table
{
.....
{
"id":"user-me"//owner id
"FriendGroups":[
…
Alex Luya
- 9,412
- 15
- 59
- 91
0
votes
1 answer
Emit multiple values in RethinkDB map step
I have datasets that consist of arrays and single values
{
"a": "18",
"b": ["x","y","z"]
}
or arrays and arrays
{
"a": ["g", "h", "i"],
"b": ["x", "y", "z"]
}
and i plan to map out each combination (like "18-x", "18-y", "18-z"…
Moritz Mahringer
- 1,240
- 16
- 28
0
votes
1 answer
Rethinkdb Query Not Working
I'm doing the following query on Rethinkdb:
r.table('skydata').filter(r.row("DeviceID").eq("JBAnFrdlbkcO").and(r.row("TS").ge(0)).and(r.row("TS").le(143556949)) ).orderBy("TS")
It worked perfect when run directly on Data Explorer on their website…
J Freebird
- 3,664
- 7
- 46
- 81
0
votes
1 answer
select within an element which might be array or string in rethinkdb
My json in the rethinkdb database is as follows (I have given 4 docs as an example) :
{
"label": {
"id": 59,
"country": "Germany",
"formats": {
"format": {
"text":…
user4993723
0
votes
1 answer
REQL to match string expression
I have the following json:
{
"release": {
"genres": {
"genre": "Electronic"
},
"identifiers": {
"identifier": [
{
"description": "Text",
"value": "5 709498 101026",
…
user4849989
0
votes
1 answer
REQL command taking too long
I have a table in a database in rethinkdb with 5.8 million records, a sample of which is provided below:
{
"release": {
"genres": {
"genre": "Electronic"
},
"identifiers": {
"identifier": [
{
…
user4849989
0
votes
1 answer
Count both sides of a partition in ReQL
I have a dataset which has a boolean attribute, like:
{
name: 'Steven',
isQualified: true
}
And I want to count both sides of a partition. That is, how many documents are qualified or not. What's the best way to do this with a single rethinkdb…
Josh Hunt
- 14,225
- 26
- 79
- 98
-2
votes
1 answer
As there is no officical docs for php with ReQl , can you please show the PHP equivalent of :
Basically I have an array in the format: array('context_text'=>some_value,'name'=>some_value,'target'=>{..});
I need to add another value to the target index like:
array('context_text'=>some_value,'name'=>some_value,'target'=>{..},{...},{...});…
Arvi128
- 13
- 5