How can I get documents from a single or specific shard with ReQL in RethinkDB?





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















I have a table with this configuration,

3 shards and 3 replicas,

I have 24 documents:


in Shard 1 = 16 Documents

in Shard 2 = 15 Documents and

in Shard 3 = 12 Documents,



Is it possible get only the documents from specific shard? I mean, if I run this query 



r.db("test01").table("testTable01")


the result are the 24 documents



I want to make a query than the result only the data from a shard, something like that:



 r.db("test01").table("testTable01").shards('shard1')


and the result are the 16 documents.






replication rethinkdb sharding reql







share|improve this question































    0















    I have a table with this configuration,

    3 shards and 3 replicas,

    I have 24 documents:


    in Shard 1 = 16 Documents

    in Shard 2 = 15 Documents and

    in Shard 3 = 12 Documents,



    Is it possible get only the documents from specific shard? I mean, if I run this query 



    r.db("test01").table("testTable01")


    the result are the 24 documents



    I want to make a query than the result only the data from a shard, something like that:



     r.db("test01").table("testTable01").shards('shard1')


    and the result are the 16 documents.






    replication rethinkdb sharding reql







    share|improve this question



























      0












      0








      0








      I have a table with this configuration,

      3 shards and 3 replicas,

      I have 24 documents:


      in Shard 1 = 16 Documents

      in Shard 2 = 15 Documents and

      in Shard 3 = 12 Documents,



      Is it possible get only the documents from specific shard? I mean, if I run this query 



      r.db("test01").table("testTable01")


      the result are the 24 documents



      I want to make a query than the result only the data from a shard, something like that:



       r.db("test01").table("testTable01").shards('shard1')


      and the result are the 16 documents.






      replication rethinkdb sharding reql







      share|improve this question
















      I have a table with this configuration,

      3 shards and 3 replicas,

      I have 24 documents:


      in Shard 1 = 16 Documents

      in Shard 2 = 15 Documents and

      in Shard 3 = 12 Documents,



      Is it possible get only the documents from specific shard? I mean, if I run this query 



      r.db("test01").table("testTable01")


      the result are the 24 documents



      I want to make a query than the result only the data from a shard, something like that:



       r.db("test01").table("testTable01").shards('shard1')


      and the result are the 16 documents.






      replication rethinkdb sharding reql




      replication rethinkdb sharding reql






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jan 3 at 7:48









      Brian Tompsett - 汤莱恩

      4,2521339103




      4,2521339103










      asked Jan 3 at 3:38









      Rafael SocarrasRafael Socarras

      11




      11
























          0






          active

          oldest

          votes












          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54016027%2fhow-can-i-get-documents-from-a-single-or-specific-shard-with-reql-in-rethinkdb%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid …



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54016027%2fhow-can-i-get-documents-from-a-single-or-specific-shard-with-reql-in-rethinkdb%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          android studio warns about leanback feature tag usage required on manifest while using Unity exported app?

          Image
          .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 This is a simple project showing cubes on Unity, exported to android project and imported on Android studio. On maifest file it showed following warning: Expecting <uses-feature android:name="android.software.leanback" android:required="false" /> tag I have no information about it. And also on default emptyview android project does not use/mention this feature. I know it is required by TV's and such but why its not added by default? Why is this? And Should I concern about it? android unity3d
          Read more

          SQL update select statement

          Image
          0 I'm trying to update an entry in my database (postgresql). I'm having a problem with updating the query: INSERT INTO prices (price, product_id) SELECT product_price, commn_id FROM products_temp as prod WHERE NOT EXISTS (SELECT * FROM prices od WHERE prod.commn_id = od.product_id) OR prod.product_price != ( SELECT price FROM prices as p WHERE p.product_id = prod.commn_id order by p.end desc LIMIT 1 ) Query works fine when i delete: OR prod.product_price != ( SELECT price FROM prices as p WHERE p.product_id = prod.commn_id order by p.end desc LIMIT 1 ) So it seems to me that it's looping through this operation. My question is, how can I fix it? sql postgresql
          Read more

          'app-layout' is not a known element: how to share Component with different Modules

          Image
          0 My application was working fine until I decided to go with lazy loading: So, my shared component looks like this: import { Component, Renderer2 } from '@angular/core'; export interface FormModel { captcha?: string; } @Component({ selector: 'app-layout', templateUrl: './app-layout.component.html', styleUrls: ['./app-layout.css'] }) export class FullLayoutComponent { } app-layout.component.ts I am using this component in my Another component say school-home.component.html like this: <app-layout> </app-layout> and it was working fine until I created a Module school-home.module.ts like this: import { NgModule } from '@angular/core'; import { CommonModule } from '@angular/common'; import { SchoolhomeRoutingModule
          Read more