You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Sumit Khanna <su...@askme.in> on 2016/08/07 08:42:39 UTC
hue / hive issue with sqlite
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
Re: hue / hive issue with sqlite
Posted by Sumit Khanna <su...@askme.in>.
Any ideas?
Please let me know.
Thanks,
On Sun, Aug 7, 2016 at 2:12 PM, Sumit Khanna <su...@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
>
Re: hue / hive issue with sqlite
Posted by Edward Capriolo <ed...@gmail.com>.
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 <su...@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 <ed...@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 <su...@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
>>>
>>
>>
>
Re: hue / hive issue with sqlite
Posted by Sumit Khanna <su...@askme.in>.
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 <ed...@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 <su...@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
>>
>
>
Re: hue / hive issue with sqlite
Posted by Edward Capriolo <ed...@gmail.com>.
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 <su...@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
>