You need to take this up with the appropriate hue/cloudera user group. One issue is that SQL lite is a embedded single user database and does not work well with more than one user. We switched to postges in our deployment and would still hit this issue. I never got it resolved,
On Sun, Aug 7, 2016 at 4:42 AM, Sumit Khanna <sumit.kha...@askme.in> wrote: > Hello, > > we have hue configured against sqlite as default database. > > *queries like select height from students limit 222;* work > > but *queries like select max(height) from students;* wont. > > in fact that displays " database is locked " error message. > > is sqlite / hue and as in not migrating to mysql the only reason? > > Kindly let me know. The sample data (which is nothing but select queries) > are working / displaying up from hue UI too. just that any queries which > actually involve M/R ( a reducer) arent working. > > Thanks, > Sumit >