Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Cannot create table stored as Parquet

avatar
Contributor

While I am executing a simple create table command it errors out:

 

create table <table-name-1> stored as parquet as (select * from <table-name-2>)

 

The message is as follows:


ERROR: AnalysisException: Failed to load metadata for table: <table-name-1>
CAUSED BY: TableLoadingException: Failed to load metadata for table: <table-name-1>
CAUSED BY: CatalogException: Failed to create partition:
CAUSED BY: IOException: Incomplete HDFS URI, no host: hdfs://master:8020:8020/user/hive/warehouse/<table-name-1>

 

<Q> Why am I getting the port 8020 twice??

 

BTW, I have been able to come with a work around, as follows:

 

create table <table-name-1> stored as parquet location '/jobs/impala/<table-name-1>' as (select * from <table-name-2>) 

 

 

Who agreed with this topic