The "database" that is locked has nothing to do with hive the problem is complete a hue problem. Find the appropriate hue mailing list to get help.
On Sun, Aug 7, 2016 at 9:11 AM, Sumit Khanna <sumit.kha...@askme.in> wrote: > Hey Edward, > > would still the issue ? How often? As in the storage format in here is > parquet, and am able to view sample sets for each column and raw select > queries are working just fine, but none of min / max / distinct / where 'd > work. > > Thanks, > > On Sun, Aug 7, 2016 at 6:38 PM, Edward Capriolo <edlinuxg...@gmail.com> > wrote: > >> 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 >>> >> >> >