Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Exception on Creating Kudu table mapping in Impala

Exception on Creating Kudu table mapping in Impala

New Contributor

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

2 REPLIES 2

Re: Exception on Creating Kudu table mapping in Impala

Contributor

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.

Re: Exception on Creating Kudu table mapping in Impala

New Contributor
@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.