Skip to main content
yasmin
yasmin
Silver ⭐️⭐️⭐️
February 7, 2019
Solved

ImpalaRuntimeException: Error making 'createTable' RPC to Hive Metastore

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

venkatsambath
venkatsambathAnswer
Gold ⭐️⭐️⭐️
February 8, 2019

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

View in thread

5 replies

Andrew_Sherman
Gold ⭐️
Andrew_Sherman
Gold ⭐️
February 8, 2019

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

 

-Andrew

Translate
    yasmin
    yasminAuthor
    Silver ⭐️⭐️⭐️
    February 8, 2019

    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

    Translate
    venkatsambath
    Gold ⭐️⭐️⭐️
    venkatsambathAnswer
    Gold ⭐️⭐️⭐️
    February 8, 2019

    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

    Translate
    Terms & ConditionsAccessibility statement