hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: hue / hive issue with sqlite
Date Sun, 07 Aug 2016 16:54:24 GMT
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.khanna@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 <edlinuxguru@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.khanna@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
>>>
>>
>>
>

Mime
View raw message