question Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos in Support Questions

[Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

hebamahmoud — Thu, 25 Aug 2022 12:00:46 GMT

Hi ,

Kindly for your support, I'm trying to create a kudu table from impala shell after enabling kerberos but i got the following error:

ERROR: AnalysisException: Cannot analyze Kudu table 'courses_kudu': Error determining if Kudu's integration with the Hive Metastore is enabled: Couldn't find a valid master in (cloudera.ngdw.com:7051). Exceptions received: [org.apache.kudu.client.NonRecoverableException: Server requires Kerberos, but this client is not authenticated (missing or expired TGT)]

Kindly find attached steps and error returned.

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

hebamahmoud — Mon, 29 Aug 2022 15:10:31 GMT

Any support is highly appreciated.

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

hebamahmoud — Mon, 29 Aug 2022 15:18:38 GMT

Hi ,

I tried to create a kudu table from hue but i got the same error in impala shell , Kindly support.

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

hebamahmoud — Mon, 29 Aug 2022 16:19:30 GMT

Hi,

I checked cloudera runtime 7.1.7 know issues for kudu , i found that HMS integration isn't supported. Although i disabled Kudu and HMS integration configuration , i'm still getting the same error message from impala shell and hue.

https://docs.cloudera.com/cdp-private-cloud-base/7.1.7/runtime-release-notes/topics/rt-pvc-known-issues-kudu.html

Kindly support.

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

hebamahmoud — Thu, 01 Sep 2022 09:34:54 GMT

Hi,

I tried disabling kerberos for Kudu and i'm able to create a table from impala-shell. Once i re-enabled kerberos configuration for kudu , i got the same issue.

Any advice or recommendation for configuring kerberos for kudu service in cloudera runtime 7.1.7.

Any recommendation is highly appreciated.

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

Shelton — Thu, 01 Sep 2022 17:57:07 GMT

@hebamahmoud
You first need to integrate Kudu with HMS I would advise you to read the whole document

Geoffrey

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

araujo — Fri, 02 Sep 2022 05:25:39 GMT

@hebamahmoud ,

Try enabling the Kudu Service as a dependency for the Impala service, as shown below.

When you do that Impala will use the selected Kudu service as the default service whenever you use a Kudu table that does not explicitly sets the Kudu masters.

If you don't set the property above you can still use Kudu from Impala but when you create the table you have to specify the Kudu masters through the TBLPROPERTIES clause.

Cheers,

André

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

hebamahmoud — Sun, 04 Sep 2022 10:14:02 GMT

Dear @Shelton ,

Many thanks. Initially, i configured kudu with HMS and i got the same issue creating kudu table. Until i checked a know issue in Cloudera runtime 7.1.7 in Kudu and HMS.

Kindly check

https://docs.cloudera.com/cdp-private-cloud-base/7.1.7/runtime-release-notes/topics/rt-pvc-known-issues-kudu.html

Then i disabled Kudu and HMS integration , unfortunately i got the same error.

Troubleshooting and investigating the issue shows it's kerberos related configuration because

Once i disabled kerberos for kudu , i managed to create a kudu table from impala-shell and hue.
I verified in a non-kerberized cluster in different machine , creating a kudu table from impala shell and hue and it worked.

Any recommendation for troubleshooting and investigating issue for configuring kudu kerberos in cloudera 7.1.7 runtime.

Thanks in advance

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

araujo — Mon, 05 Sep 2022 00:32:00 GMT

@hebamahmoud ,

Did you try enabling the dependency between Kudu and Impala, as per my post above?

Cheers,

André

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

hebamahmoud — Mon, 05 Sep 2022 09:12:20 GMT

Dear @araujo ,

Many thanks , yes . This configuration is already enabled and configured.

Any recommendation for troubleshooting and investigating issue for configuring kudu kerberos in cloudera 7.1.7 runtime is highly appreciated.

Thanks in advance,

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

dsajdklajdklsa — Thu, 03 Aug 2023 06:16:35 GMT

Dear @hebamahmoud , seems we ran into this issue too. Have you fixed this issue? Thanks in advance.

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

VidyaSargur — Thu, 03 Aug 2023 08:53:37 GMT

@dsajdklajdklsa, Welcome to our community! To help you get the best possible answer, I have tagged our experts @ChethanYM @willx @araujo @Shelton who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

Althotta — Tue, 29 Aug 2023 07:36:15 GMT

Having the same issue while loading data from NIFI 1.21 to Kudu. Anyone find the solution?. I can connect to Kudu Via Hue and Impala

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

ChethanYM — Tue, 29 Aug 2023 15:51:19 GMT

Hi @hebamahmoud

You mean even after configuring the KUDU-HMS integration you are still facing the same issue/error? Can you confirm?

Have you followed the given workaround on all HMS servers?

https://docs.cloudera.com/cdp-private-cloud-base/7.1.7/runtime-release-notes/topics/rt-pvc-known-issues-kudu.html

If that does not work can you try below and check?

CM > kudu > configuration> kudu service Advanced Configuration Snippet (Safety Valve) ==> --trusted_user_acl=impala,hive and restart the kudu services,

Regards,

Chethan YM

Re: [Kerberos ][Cloudera manager 7] Unable to create a kudu table from impala shell after enabling kerberos

ChethanYM — Wed, 13 Sep 2023 14:00:22 GMT

Hello @hebamahmoud

If the issue is has been from any of the above responses, Could you accept it as a solution?

Regards,

Chethan YM