I think the issue is because each table needs a fully qualified path. I see you were using $BLURHOME before. Try using something like file:///tmp/blur-tables/test1 or something like that and have each path be different per table. Or you could set a default location in the blur-site.properties file and then you don't have to set the location per table.
Aaron On Tuesday, August 5, 2014, Ameya Aware <[email protected]> wrote: > yeah.. that's the residual data.. but whenever i am creating new table and > querying it that data always shows up in output. > > Also, any idea how to clear all the tables so that no residual data comes > in? > > Thanks, > Ameya > > > On Tue, Aug 5, 2014 at 11:42 AM, Aaron McCurry <[email protected] > <javascript:;>> wrote: > > > My guess is that there are some residual data left around from previous > > attempts? Perhaps create a new table in a new location and repeat the > > steps from above. > > > > Aaron > > > > On Tuesday, August 5, 2014, Ameya Aware <[email protected] > <javascript:;>> wrote: > > > > > I am interacting through shell.. the default way given in blur > > > documentation.. > > > > > > blur (default)> create -t test -c 11 -l $BLUR_HOME > > > > > > blur (default)> mutate test r1 rid1 f1 c1:v1 > > > blur (default)> mutate test r1 rid1 f1 c2:v2 > > > blur (default)> mutate test r1 rid1 f1 c3:v3 > > > blur (default)> mutate test r1 rid1 f2 c1:v1 > > > blur (default)> mutate test r1 rid1 f2 c2:v2 > > > blur (default)> mutate test r1 rid2 f2 c1:v1 > > > blur (default)> mutate test r1 rid2 f1 c2:v2 > > > blur (default)> mutate test r2 rid1 f1 c1:v1 > > > blur (default)> mutate test r2 rid1 f1 c2:v2 > > > blur (default)> mutate test r2 rid1 f2 c2:v2 > > > > > > blur (default)> query test *:* -min 1000 -fetch 1000 > > > > > > > > > 4 results found in [61.891877 ms]. Row [4] Record [7] Column [7] Data > > > (bytes) > > > result# rowid recordid > > > 0 r-5678 family1.column3 > > > 0 1234 value4 > > > 0 9012 value1 > > > 0 family2.column16 > > > 0 4321 value1 > > > 1 r1 f1.c2 > > > 1 rid2 v2 > > > 1 f2.c2 > > > 1 rid1 v2 > > > 2 rowid1 fam2.col1 > > > 2 recordid1 value1 > > > 3 r2 f2.c2 > > > 3 rid1 v2 > > > > > > > > > As you can see, it is still not giving me correct output.. Plus > result# 0 > > > and 2 doesnot even belong to the table still they are coming in output. > > > > > > > > > Any suggestions what is happening here. > > > > > > > > > > > > Thanks, > > > Ameya > > > > > > > > > On Tue, Aug 5, 2014 at 11:02 AM, Tim Williams <[email protected] > <javascript:;> > > > <javascript:;>> wrote: > > > > > > > On Tue, Aug 5, 2014 at 10:54 AM, Ameya Aware <[email protected] > <javascript:;> > > > <javascript:;>> > > > > wrote: > > > > > It returns some of the rows of table but not all.. :( > > > > > > > > How are you interacting with Blur? the Shell? the thrift API? > > > > Console? By default Blur limits the number of results returned but > > > > those can be adjusted through the BlurQuery[1] object in the API. > Or, > > > > if you're using the shell, just adjust it with command line switches > > > > (e.g. query test *:* -min 1000 -fetch 1000 ) > > > > > > > > --tim > > > > > > > > [1] - > > > > > http://incubator.apache.org/blur/docs/0.2.3/Blur.html#Struct_BlurQuery > > > > > > > > > >
