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.

Who agreed with this topic

Cannot create table stored as Parquet

Rising Star

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