question Re: Error when creating a Kudu table through Impala JDBC driver : table owner must not be null or empty in Support Questions

Error when creating a Kudu table through Impala JDBC driver : table owner must not be null or empty

JeromeAlbin — Fri, 28 Feb 2020 19:01:25 GMT

Hello,

We've recently migrated CDH from 5.16.2 to 6.3.3 and we now have the following message when we create a table using Impala JDBC driver (we are using the latest version 2.6.15.1017).

errorMessage:ImpalaRuntimeException: Error creating Kudu table 'impala::pdo.discoveries'
CAUSED BY: IllegalArgumentException: table owner must not be null or empty

When the same "create table" statement is executed in impala-shell, it works perfectly well.

The search for this error message in google did not find much result.

Any idea about the root cause ?

Re: Error when creating a Kudu table through Impala JDBC driver : table owner must not be null or empty

RKS — Tue, 02 Mar 2021 12:09:12 GMT

Hello,

I got the same issue as yours. I am running Kudu and Impala in docker. I can create tables from impala-shell but not using JDBC driver.

Is there any solution for this?

Re: Error when creating a Kudu table through Impala JDBC driver : table owner must not be null or empty

kingpin — Wed, 03 Mar 2021 05:15:41 GMT

Hi @JeromeAlbin

Looks like https://issues.apache.org/jira/browse/IMPALA-9486

The Error pop up because you are connecting to Impala anonymously (no user, no password).
You can specify a user (even if it's not declared in Kudu), then it should work

Please read the page 12 of the following document: https://docs.cloudera.com/documentation/other/connectors/impala-jdbc/2-6-15/Cloudera-JDBC-Driver-for-Impala-Install-Guide.pdf
Using User Name
-----------------------
This authentication mechanism requires a user name but does not require a password.
The user name labels the session, facilitating database tracking.

Does that answer your question ? if yes, then feel free to mark this post "accept as solution"

Regards,

vipin

Re: Error when creating a Kudu table through Impala JDBC driver : table owner must not be null or empty

RKS — Thu, 04 Mar 2021 14:56:23 GMT

Hello,

I tried with AuthMech=2 with UID as mentioned in the Cloudera Impala JDBC Driver documentation but I got HIveServer2 connection issue.

When I tried with AuthMech=0, along with UID (In my case no authentication is needed), it resolved the table owner error.

My connection string looks like -

jdbc:impala://localhost:21050/default;UseSasl=0;AuthMech=0;UID=impala

Hope this will resolve your issue as well.