On Fri, Dec 6, 2013 at 7:54 AM, Naresh Yadav <[email protected]> wrote:

> Hi,
>
> I have few doubts related to blur please help me on this :
>
> 1. Is there a way i can see all rows of data in a blur table ??? did not
> find any blur shell command..
>

This will give you all the rows.

query <tablename> *


>
> 2. Is delete of data possible with where clause as query (similar to query
> command)?? I want to delete all data by matching two columns values through
> blur shell..
>

Not yet.  https://issues.apache.org/jira/browse/BLUR-130

This shouldn't difficult to add.


>
> 3.After storing 17000 rows then i run queries to get each one then that
> returned only 16900 rows...After 5 mins i again run queries to get each one
> then returned all 17000 rows.........Is there solution for this ?? In my
> cased just after inserting data, i need to immediately run query over it.
>

There is a delay on visibility of data within Blur.  I believe the default
for a given table is 3 seconds, this can be configured by changing this
setting:

blur.shard.time.between.refreshs=3000

In the table properties, or in the blur-site.properties file.

Be aware that decreasing this time will also decrease the speed in which
mutates can occur.  Also there is a flag on the RowMutation object called
waitForVisiblity if this is set to true the mutate command will not return
until the data is searchable.  NOTE: This will slow things down!  So only
do this if you have to wait.

Hope this helps.

Aaron


>
> Thanks,
> Naresh
>

Reply via email to