hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sumit Khanna <sumit.kha...@askme.in>
Subject Re: hue / hive issue with sqlite
Date Sun, 07 Aug 2016 13:11:41 GMT
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