You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by Fawze Abujaber <fa...@gmail.com> on 2018/10/21 14:19:19 UTC
Impala queries through impala JDBC is running with empty user
Hi Community,
I'm struggling getting Impala to work with Zeppelin, I'm trying to pass the
user in the impala JDBC url.
My issue that when i configure the impala JDBC url with AuthMech=0 which
works without authentication i get it work and the query ran without user.
When i'm changing to AuthMech=2, the query is hanging at the UI.
Zeppelin version: 0.8.0
Impala JDBC: 2.6.3
My Url : jdbc:impala://node1.example.com:21050;AuthMech=2; UID=fawzea
[image: Screen Shot 2018-10-21 at 5.17.19 PM.png]
Log:
ERROR [2018-10-21 10:16:20,388] ({pool-2-thread-2}
JDBCInterpreter.java[open]:197) - zeppelin will be ignored. driver.zeppelin
and zeppelin.url is mandatory.
Any help is much appreciated.
Take Care
Fawze Abujaber
Re: Impala queries through impala JDBC is running with empty user
Posted by Fawze Abujaber <fa...@gmail.com>.
Thanks Jeff.
https://issues.apache.org/jira/browse/ZEPPELIN-3844
On Fri, Nov 2, 2018 at 3:40 AM Jeff Zhang <zj...@gmail.com> wrote:
>
> Thanks for the confirmation, please file a ticket for this issue.
>
> Fawze Abujaber <fa...@gmail.com>于2018年11月2日周五 上午9:30写道：
>
>> Yes, I can access and these auth are working as expected.
>>
>> On Fri, Nov 2, 2018 at 3:29 AM Jeff Zhang <zj...@gmail.com> wrote:
>>
>>>
>>> Can you access impala in auth mode via other tools ? If yes, then it
>>> seems a bug of zeppelin.
>>>
>>>
>>> Fawze Abujaber <fa...@gmail.com>于2018年11月2日周五 上午9:21写道：
>>>
>>>> AuthMech=0 no authentication
>>>> and AuthMech=2 authentication with user name
>>>>
>>>> On Fri, Nov 2, 2018 at 3:19 AM Jeff Zhang <zj...@gmail.com> wrote:
>>>>
>>>>> What's the difference between AuthMech=0 and AuthMech=2 ?
>>>>>
>>>>> Fawze Abujaber <fa...@gmail.com>于2018年11月2日周五 上午1:58写道：
>>>>>
>>>>>> Should i open a bug for this?
>>>>>>
>>>>>> Anyone who is able to replicate this in his side?
>>>>>>
>>>>>> On Tue, Oct 23, 2018 at 8:57 PM Fawze Abujaber <fa...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Any help here is so much appreciated.
>>>>>>>
>>>>>>> I’m over few days with no success.
>>>>>>>
>>>>>>> On Sun, 21 Oct 2018 at 17:19 Fawze Abujaber <fa...@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>> Hi Community,
>>>>>>>>
>>>>>>>> I'm struggling getting Impala to work with Zeppelin, I'm trying to
>>>>>>>> pass the user in the impala JDBC url.
>>>>>>>>
>>>>>>>> My issue that when i configure the impala JDBC url with AuthMech=0
>>>>>>>> which works without authentication i get it work and the query ran without
>>>>>>>> user.
>>>>>>>>
>>>>>>>> When i'm changing to AuthMech=2, the query is hanging at the UI.
>>>>>>>>
>>>>>>>> Zeppelin version: 0.8.0
>>>>>>>> Impala JDBC: 2.6.3
>>>>>>>>
>>>>>>>> My Url : jdbc:impala://node1.example.com:21050;AuthMech=2;
>>>>>>>> UID=fawzea
>>>>>>>>
>>>>>>>> [image: Screen Shot 2018-10-21 at 5.17.19 PM.png]
>>>>>>>>
>>>>>>>>
>>>>>>>> Log:
>>>>>>>>
>>>>>>>> ERROR [2018-10-21 10:16:20,388] ({pool-2-thread-2}
>>>>>>>> JDBCInterpreter.java[open]:197) - zeppelin will be ignored. driver.zeppelin
>>>>>>>> and zeppelin.url is mandatory.
>>>>>>>>
>>>>>>>> Any help is much appreciated.
>>>>>>>>
>>>>>>>> Take Care
>>>>>>>> Fawze Abujaber
>>>>>>>>
>>>>>>> --
>>>>>>> Take Care
>>>>>>> Fawze Abujaber
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Take Care
>>>>>> Fawze Abujaber
>>>>>>
>>>>>
>>>>
>>>> --
>>>> Take Care
>>>> Fawze Abujaber
>>>>
>>>
>>
>> --
>> Take Care
>> Fawze Abujaber
>>
>
--
Take Care
Fawze Abujaber
Re: Impala queries through impala JDBC is running with empty user
Posted by Jeff Zhang <zj...@gmail.com>.
Thanks for the confirmation, please file a ticket for this issue.
Fawze Abujaber <fa...@gmail.com>于2018年11月2日周五 上午9:30写道：
> Yes, I can access and these auth are working as expected.
>
> On Fri, Nov 2, 2018 at 3:29 AM Jeff Zhang <zj...@gmail.com> wrote:
>
>>
>> Can you access impala in auth mode via other tools ? If yes, then it
>> seems a bug of zeppelin.
>>
>>
>> Fawze Abujaber <fa...@gmail.com>于2018年11月2日周五 上午9:21写道：
>>
>>> AuthMech=0 no authentication
>>> and AuthMech=2 authentication with user name
>>>
>>> On Fri, Nov 2, 2018 at 3:19 AM Jeff Zhang <zj...@gmail.com> wrote:
>>>
>>>> What's the difference between AuthMech=0 and AuthMech=2 ?
>>>>
>>>> Fawze Abujaber <fa...@gmail.com>于2018年11月2日周五 上午1:58写道：
>>>>
>>>>> Should i open a bug for this?
>>>>>
>>>>> Anyone who is able to replicate this in his side?
>>>>>
>>>>> On Tue, Oct 23, 2018 at 8:57 PM Fawze Abujaber <fa...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Any help here is so much appreciated.
>>>>>>
>>>>>> I’m over few days with no success.
>>>>>>
>>>>>> On Sun, 21 Oct 2018 at 17:19 Fawze Abujaber <fa...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>>
>>>>>>> Hi Community,
>>>>>>>
>>>>>>> I'm struggling getting Impala to work with Zeppelin, I'm trying to
>>>>>>> pass the user in the impala JDBC url.
>>>>>>>
>>>>>>> My issue that when i configure the impala JDBC url with AuthMech=0
>>>>>>> which works without authentication i get it work and the query ran without
>>>>>>> user.
>>>>>>>
>>>>>>> When i'm changing to AuthMech=2, the query is hanging at the UI.
>>>>>>>
>>>>>>> Zeppelin version: 0.8.0
>>>>>>> Impala JDBC: 2.6.3
>>>>>>>
>>>>>>> My Url : jdbc:impala://node1.example.com:21050;AuthMech=2;
>>>>>>> UID=fawzea
>>>>>>>
>>>>>>> [image: Screen Shot 2018-10-21 at 5.17.19 PM.png]
>>>>>>>
>>>>>>>
>>>>>>> Log:
>>>>>>>
>>>>>>> ERROR [2018-10-21 10:16:20,388] ({pool-2-thread-2}
>>>>>>> JDBCInterpreter.java[open]:197) - zeppelin will be ignored. driver.zeppelin
>>>>>>> and zeppelin.url is mandatory.
>>>>>>>
>>>>>>> Any help is much appreciated.
>>>>>>>
>>>>>>> Take Care
>>>>>>> Fawze Abujaber
>>>>>>>
>>>>>> --
>>>>>> Take Care
>>>>>> Fawze Abujaber
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Take Care
>>>>> Fawze Abujaber
>>>>>
>>>>
>>>
>>> --
>>> Take Care
>>> Fawze Abujaber
>>>
>>
>
> --
> Take Care
> Fawze Abujaber
>
Re: Impala queries through impala JDBC is running with empty user
Posted by Fawze Abujaber <fa...@gmail.com>.
Yes, I can access and these auth are working as expected.
On Fri, Nov 2, 2018 at 3:29 AM Jeff Zhang <zj...@gmail.com> wrote:
>
> Can you access impala in auth mode via other tools ? If yes, then it seems
> a bug of zeppelin.
>
>
> Fawze Abujaber <fa...@gmail.com>于2018年11月2日周五 上午9:21写道：
>
>> AuthMech=0 no authentication
>> and AuthMech=2 authentication with user name
>>
>> On Fri, Nov 2, 2018 at 3:19 AM Jeff Zhang <zj...@gmail.com> wrote:
>>
>>> What's the difference between AuthMech=0 and AuthMech=2 ?
>>>
>>> Fawze Abujaber <fa...@gmail.com>于2018年11月2日周五 上午1:58写道：
>>>
>>>> Should i open a bug for this?
>>>>
>>>> Anyone who is able to replicate this in his side?
>>>>
>>>> On Tue, Oct 23, 2018 at 8:57 PM Fawze Abujaber <fa...@gmail.com>
>>>> wrote:
>>>>
>>>>> Any help here is so much appreciated.
>>>>>
>>>>> I’m over few days with no success.
>>>>>
>>>>> On Sun, 21 Oct 2018 at 17:19 Fawze Abujaber <fa...@gmail.com> wrote:
>>>>>
>>>>>>
>>>>>> Hi Community,
>>>>>>
>>>>>> I'm struggling getting Impala to work with Zeppelin, I'm trying to
>>>>>> pass the user in the impala JDBC url.
>>>>>>
>>>>>> My issue that when i configure the impala JDBC url with AuthMech=0
>>>>>> which works without authentication i get it work and the query ran without
>>>>>> user.
>>>>>>
>>>>>> When i'm changing to AuthMech=2, the query is hanging at the UI.
>>>>>>
>>>>>> Zeppelin version: 0.8.0
>>>>>> Impala JDBC: 2.6.3
>>>>>>
>>>>>> My Url : jdbc:impala://node1.example.com:21050;AuthMech=2; UID=fawzea
>>>>>>
>>>>>> [image: Screen Shot 2018-10-21 at 5.17.19 PM.png]
>>>>>>
>>>>>>
>>>>>> Log:
>>>>>>
>>>>>> ERROR [2018-10-21 10:16:20,388] ({pool-2-thread-2}
>>>>>> JDBCInterpreter.java[open]:197) - zeppelin will be ignored. driver.zeppelin
>>>>>> and zeppelin.url is mandatory.
>>>>>>
>>>>>> Any help is much appreciated.
>>>>>>
>>>>>> Take Care
>>>>>> Fawze Abujaber
>>>>>>
>>>>> --
>>>>> Take Care
>>>>> Fawze Abujaber
>>>>>
>>>>
>>>>
>>>> --
>>>> Take Care
>>>> Fawze Abujaber
>>>>
>>>
>>
>> --
>> Take Care
>> Fawze Abujaber
>>
>
--
Take Care
Fawze Abujaber
Re: Impala queries through impala JDBC is running with empty user
Posted by Jeff Zhang <zj...@gmail.com>.
Can you access impala in auth mode via other tools ? If yes, then it seems
a bug of zeppelin.
Fawze Abujaber <fa...@gmail.com>于2018年11月2日周五 上午9:21写道：
> AuthMech=0 no authentication
> and AuthMech=2 authentication with user name
>
> On Fri, Nov 2, 2018 at 3:19 AM Jeff Zhang <zj...@gmail.com> wrote:
>
>> What's the difference between AuthMech=0 and AuthMech=2 ?
>>
>> Fawze Abujaber <fa...@gmail.com>于2018年11月2日周五 上午1:58写道：
>>
>>> Should i open a bug for this?
>>>
>>> Anyone who is able to replicate this in his side?
>>>
>>> On Tue, Oct 23, 2018 at 8:57 PM Fawze Abujaber <fa...@gmail.com>
>>> wrote:
>>>
>>>> Any help here is so much appreciated.
>>>>
>>>> I’m over few days with no success.
>>>>
>>>> On Sun, 21 Oct 2018 at 17:19 Fawze Abujaber <fa...@gmail.com> wrote:
>>>>
>>>>>
>>>>> Hi Community,
>>>>>
>>>>> I'm struggling getting Impala to work with Zeppelin, I'm trying to
>>>>> pass the user in the impala JDBC url.
>>>>>
>>>>> My issue that when i configure the impala JDBC url with AuthMech=0
>>>>> which works without authentication i get it work and the query ran without
>>>>> user.
>>>>>
>>>>> When i'm changing to AuthMech=2, the query is hanging at the UI.
>>>>>
>>>>> Zeppelin version: 0.8.0
>>>>> Impala JDBC: 2.6.3
>>>>>
>>>>> My Url : jdbc:impala://node1.example.com:21050;AuthMech=2; UID=fawzea
>>>>>
>>>>> [image: Screen Shot 2018-10-21 at 5.17.19 PM.png]
>>>>>
>>>>>
>>>>> Log:
>>>>>
>>>>> ERROR [2018-10-21 10:16:20,388] ({pool-2-thread-2}
>>>>> JDBCInterpreter.java[open]:197) - zeppelin will be ignored. driver.zeppelin
>>>>> and zeppelin.url is mandatory.
>>>>>
>>>>> Any help is much appreciated.
>>>>>
>>>>> Take Care
>>>>> Fawze Abujaber
>>>>>
>>>> --
>>>> Take Care
>>>> Fawze Abujaber
>>>>
>>>
>>>
>>> --
>>> Take Care
>>> Fawze Abujaber
>>>
>>
>
> --
> Take Care
> Fawze Abujaber
>
Re: Impala queries through impala JDBC is running with empty user
Posted by Fawze Abujaber <fa...@gmail.com>.
AuthMech=0 no authentication
and AuthMech=2 authentication with user name
On Fri, Nov 2, 2018 at 3:19 AM Jeff Zhang <zj...@gmail.com> wrote:
> What's the difference between AuthMech=0 and AuthMech=2 ?
>
> Fawze Abujaber <fa...@gmail.com>于2018年11月2日周五 上午1:58写道：
>
>> Should i open a bug for this?
>>
>> Anyone who is able to replicate this in his side?
>>
>> On Tue, Oct 23, 2018 at 8:57 PM Fawze Abujaber <fa...@gmail.com> wrote:
>>
>>> Any help here is so much appreciated.
>>>
>>> I’m over few days with no success.
>>>
>>> On Sun, 21 Oct 2018 at 17:19 Fawze Abujaber <fa...@gmail.com> wrote:
>>>
>>>>
>>>> Hi Community,
>>>>
>>>> I'm struggling getting Impala to work with Zeppelin, I'm trying to pass
>>>> the user in the impala JDBC url.
>>>>
>>>> My issue that when i configure the impala JDBC url with AuthMech=0
>>>> which works without authentication i get it work and the query ran without
>>>> user.
>>>>
>>>> When i'm changing to AuthMech=2, the query is hanging at the UI.
>>>>
>>>> Zeppelin version: 0.8.0
>>>> Impala JDBC: 2.6.3
>>>>
>>>> My Url : jdbc:impala://node1.example.com:21050;AuthMech=2; UID=fawzea
>>>>
>>>> [image: Screen Shot 2018-10-21 at 5.17.19 PM.png]
>>>>
>>>>
>>>> Log:
>>>>
>>>> ERROR [2018-10-21 10:16:20,388] ({pool-2-thread-2}
>>>> JDBCInterpreter.java[open]:197) - zeppelin will be ignored. driver.zeppelin
>>>> and zeppelin.url is mandatory.
>>>>
>>>> Any help is much appreciated.
>>>>
>>>> Take Care
>>>> Fawze Abujaber
>>>>
>>> --
>>> Take Care
>>> Fawze Abujaber
>>>
>>
>>
>> --
>> Take Care
>> Fawze Abujaber
>>
>
--
Take Care
Fawze Abujaber
Re: Impala queries through impala JDBC is running with empty user
Posted by Jeff Zhang <zj...@gmail.com>.
What's the difference between AuthMech=0 and AuthMech=2 ?
Fawze Abujaber <fa...@gmail.com>于2018年11月2日周五 上午1:58写道：
> Should i open a bug for this?
>
> Anyone who is able to replicate this in his side?
>
> On Tue, Oct 23, 2018 at 8:57 PM Fawze Abujaber <fa...@gmail.com> wrote:
>
>> Any help here is so much appreciated.
>>
>> I’m over few days with no success.
>>
>> On Sun, 21 Oct 2018 at 17:19 Fawze Abujaber <fa...@gmail.com> wrote:
>>
>>>
>>> Hi Community,
>>>
>>> I'm struggling getting Impala to work with Zeppelin, I'm trying to pass
>>> the user in the impala JDBC url.
>>>
>>> My issue that when i configure the impala JDBC url with AuthMech=0
>>> which works without authentication i get it work and the query ran without
>>> user.
>>>
>>> When i'm changing to AuthMech=2, the query is hanging at the UI.
>>>
>>> Zeppelin version: 0.8.0
>>> Impala JDBC: 2.6.3
>>>
>>> My Url : jdbc:impala://node1.example.com:21050;AuthMech=2; UID=fawzea
>>>
>>> [image: Screen Shot 2018-10-21 at 5.17.19 PM.png]
>>>
>>>
>>> Log:
>>>
>>> ERROR [2018-10-21 10:16:20,388] ({pool-2-thread-2}
>>> JDBCInterpreter.java[open]:197) - zeppelin will be ignored. driver.zeppelin
>>> and zeppelin.url is mandatory.
>>>
>>> Any help is much appreciated.
>>>
>>> Take Care
>>> Fawze Abujaber
>>>
>> --
>> Take Care
>> Fawze Abujaber
>>
>
>
> --
> Take Care
> Fawze Abujaber
>
Re: Impala queries through impala JDBC is running with empty user
Posted by Fawze Abujaber <fa...@gmail.com>.
Should i open a bug for this?
Anyone who is able to replicate this in his side?
On Tue, Oct 23, 2018 at 8:57 PM Fawze Abujaber <fa...@gmail.com> wrote:
> Any help here is so much appreciated.
>
> I’m over few days with no success.
>
> On Sun, 21 Oct 2018 at 17:19 Fawze Abujaber <fa...@gmail.com> wrote:
>
>>
>> Hi Community,
>>
>> I'm struggling getting Impala to work with Zeppelin, I'm trying to pass
>> the user in the impala JDBC url.
>>
>> My issue that when i configure the impala JDBC url with AuthMech=0 which
>> works without authentication i get it work and the query ran without user.
>>
>> When i'm changing to AuthMech=2, the query is hanging at the UI.
>>
>> Zeppelin version: 0.8.0
>> Impala JDBC: 2.6.3
>>
>> My Url : jdbc:impala://node1.example.com:21050;AuthMech=2; UID=fawzea
>>
>> [image: Screen Shot 2018-10-21 at 5.17.19 PM.png]
>>
>>
>> Log:
>>
>> ERROR [2018-10-21 10:16:20,388] ({pool-2-thread-2}
>> JDBCInterpreter.java[open]:197) - zeppelin will be ignored. driver.zeppelin
>> and zeppelin.url is mandatory.
>>
>> Any help is much appreciated.
>>
>> Take Care
>> Fawze Abujaber
>>
> --
> Take Care
> Fawze Abujaber
>
--
Take Care
Fawze Abujaber
Re: Impala queries through impala JDBC is running with empty user
Posted by Fawze Abujaber <fa...@gmail.com>.
Any help here is so much appreciated.
I’m over few days with no success.
On Sun, 21 Oct 2018 at 17:19 Fawze Abujaber <fa...@gmail.com> wrote:
>
> Hi Community,
>
> I'm struggling getting Impala to work with Zeppelin, I'm trying to pass
> the user in the impala JDBC url.
>
> My issue that when i configure the impala JDBC url with AuthMech=0 which
> works without authentication i get it work and the query ran without user.
>
> When i'm changing to AuthMech=2, the query is hanging at the UI.
>
> Zeppelin version: 0.8.0
> Impala JDBC: 2.6.3
>
> My Url : jdbc:impala://node1.example.com:21050;AuthMech=2; UID=fawzea
>
> [image: Screen Shot 2018-10-21 at 5.17.19 PM.png]
>
>
> Log:
>
> ERROR [2018-10-21 10:16:20,388] ({pool-2-thread-2}
> JDBCInterpreter.java[open]:197) - zeppelin will be ignored. driver.zeppelin
> and zeppelin.url is mandatory.
>
> Any help is much appreciated.
>
> Take Care
> Fawze Abujaber
>
--
Take Care
Fawze Abujaber