Reply
New Contributor
Posts: 2
Registered: ‎11-01-2017

Exception on Creating Kudu table mapping in Impala

Hi,

 

I created a Kudu table via the KuduContext, and creation was successful. I copied the CREATE TABLE statement from the Kudu UI and tried to execute it on the Impala shell. However, it complains of "invalid table/name". Here is the error:

 

Query: create EXTERNAL TABLE `app_db.sg_test17110117` STORED AS KUDU
TBLPROPERTIES(
'kudu.table_name' = 'app_db.sg_test17110117',
'kudu.master_addresses' = 'host.domain.net:7051')
ERROR: AnalysisException: Invalid table/view name: app_db.sg_test17110117

 

Can anyone throw more light on this error, and any workarounds, please?

 

Thanks,

Sree

Cloudera Employee
Posts: 6
Registered: ‎03-16-2017

Re: Exception on Creating Kudu table mapping in Impala

Hi,

 

Impala uses Hive metastore validators, and those do not allow a table to have a dot (i.e. '.' symbol) it name of a table.  Usually, the prefix before the dot stands for a database name.

 

Kudu allows table names to have a dot in the name, and that's because it does not support a concept of a database yet.  That may change in future, though.

 

As a workaround, don't add dots into the names of your Kudu tables.

New Contributor
Posts: 2
Registered: ‎11-01-2017

Re: Exception on Creating Kudu table mapping in Impala

@Alexey1c: Thanks for your reply. The string before the “.” Is in fact the database name. I contected Cloudera Support and they confirmed that the CREATE EXTERNAL TABLE statement on the Kudu UI is erroneous.
Announcements