- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ImpalaRuntimeException: Error making 'createTable' RPC to Hive Metastore
- Labels:
-
Apache Impala
-
Cloudera Hue
Created on ‎02-06-2019 04:12 PM - edited ‎09-16-2022 07:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created ‎02-07-2019 07:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Impala relies on hivemetastore for persisting table metadata. HMS inturn uses db to persist metadata. So if the db's filesystem is out of space, request from hms to persist metadata will be denied and yes if the space on the db is not freed up then request from hms will be failed and eventually impala also fails the query
Created ‎02-07-2019 04:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It looks like the Postgres system used by HMS is out of disk space.
-Andrew
Created ‎02-07-2019 06:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created ‎02-07-2019 07:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Impala relies on hivemetastore for persisting table metadata. HMS inturn uses db to persist metadata. So if the db's filesystem is out of space, request from hms to persist metadata will be denied and yes if the space on the db is not freed up then request from hms will be failed and eventually impala also fails the query
Created ‎02-07-2019 07:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created ‎02-08-2019 05:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
