Hi Mali, This could be a number of things. First, check to make sure the RangeServers (slaves) are idle when the query appears to be hanging. I've witnessed situations where a query appears to hang, but is actually still being executed, scanning over a large section of data that, for example, does not contain the column "meta:eklemetarihi". The next thing to do is to double-check that there are no errors in the Hypertable logs. You can do this with:
grep -i ERROR /opt/hypertable/current/log/*.log grep -i Except /opt/hypertable/current/log/*.log Next double-check the Hadoop logs to be sure there are no errors (see your Hadoop distro documentation for location of logs). If none of the above turns up anything, let us know and we can help you capture stack traces of the RangeServers to determine if they're stuck in a deadlock. - Doug On Tue, Aug 14, 2012 at 7:38 AM, Mehmet Ali Cetinkaya < [email protected]> wrote: > Hello, > > i have a Hadoop (0.20)+Hypertable (0.9.6) system that one master and two > slaves. > > we inserted 1 million data to hypertable succesfully. > But now, when use the select query ( select meta:eklemetarihi from urls; ) > hypertable frozen after approximate 300.000 data show. > > i didn't see any error in hypertable logs. > > i read some document from internet. and their solution is "you must erase > cell cache of hypertable". > but i didn't find how can i erase cell cache. > > what can be done to resolvee this issue? > > thanx, > mali > > -- > You received this message because you are subscribed to the Google Groups > "Hypertable Development" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/hypertable-dev?hl=en. > -- Doug Judd CEO, Hypertable Inc. -- You received this message because you are subscribed to the Google Groups "Hypertable Development" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/hypertable-dev?hl=en.
