Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

ImpalaRuntimeException: Error making 'createTable' RPC to Hive Metastore

avatar
Explorer

Hi,,

 

Error thrown while creating table in impala using HUE.

 

  • Query Status: ImpalaRuntimeException: Error making 'createTable' RPC to Hive Metastore: CAUSED BY: MetaException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: could not extend file "base/24863/24866": No space left on device Hint: Check free disk space.CREATE TABLE temp_enc.e060908_mcc_ecomm_map
    (
    mcc_id string,
    segment string
    )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','

Thanks

Yasmin

1 ACCEPTED SOLUTION

avatar
Master Collaborator
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
5 REPLIES 5

avatar
Contributor

It looks like the Postgres system used by HMS is out of disk space. 

 

-Andrew

avatar
Explorer

Hi Andrew,

 

Thanks much or your quick response, appreciate it 🙂

 

So, it means that no impala query will succeed unless the space on the Postgres System is under threshold.

Is my understanding correct?

 

Thank you, Waiting for your response!

 

Yasmin

avatar
Master Collaborator
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
Explorer

Andrew,

 

Stuckup with hive now

Please help me, why this error below.Is something wrong with Hive metastore?

 

hive> show databases;
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset

 

Help me , thanks !

 

Yasmin

avatar
Contributor

Hi Yasmin,

 

there's not much information there but it does sound like your HS2 can't connect to the HMS.

If you didn't fix the space issues for HMS then maybe HMS isn't running well.

You may find useful information in the HMS logs

 

-Andrew