FAQ
Hi,

The latest version of Impala doesn't seem to work with the EC2 set up
instructions listed here:

http://blog.cloudera.com/blog/2013/02/from-zero-to-impala-in-minutes

The cluster seems to set up fine, but I get the following error when
running a 'show tables' command from the Hive CLI:

*-bash-4.1$ hive*
*Logging initialized using configuration in
file:/etc/hive/conf.dist/hive-log4j.properties*
*Hive history
file=/tmp/impala/hive_job_log_impala_201302272345_1246843221.txt*
*hive> show tables;*
*FAILED: Error in metadata: MetaException(message:Got exception:
org.apache.hadoop.hive.metastore.api.MetaException
javax.jdo.JDODataStoreException: Required table missing :
"`SKEWED_STRING_LIST`" in Catalog "" Schema "". DataNucleus requires this
table to perform its persistence operations. Either your MetaData is
incorrect, or you need to enable "datanucleus.autoCreateTables"*
*NestedThrowables:*
*org.datanucleus.store.rdbms.exceptions.MissingTableException: Required
table missing : "`SKEWED_STRING_LIST`" in Catalog "" Schema "". DataNucleus
requires this table to perform its persistence operations. Either your
MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables")
*
*FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask*
*hive> *

I get the same type of error in the Impala shell.

Can someone take a look and update the instructions?

Thanks,

Dave

Search Discussions

  • Lenni Kuff at Feb 28, 2013 at 12:09 am
    Hi,
    The problem is that the Hive metastore schema is not backwards compatible
    between Hive v0.9 and Hive v0.10. The deployment script needs to be updated
    to change:
    SOURCE
    /usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.9.0.mysql.sql;
    To:
    SOURCE
    /usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.10.0.mysql.sql;

    We will get the blog updated, thanks for letting us know!

    Thanks,
    Lenni
    Software Engineer - Cloudera

    On Wed, Feb 27, 2013 at 3:51 PM, Dave Mariani wrote:

    Hi,

    The latest version of Impala doesn't seem to work with the EC2 set up
    instructions listed here:

    http://blog.cloudera.com/blog/2013/02/from-zero-to-impala-in-minutes

    The cluster seems to set up fine, but I get the following error when
    running a 'show tables' command from the Hive CLI:

    *-bash-4.1$ hive*
    *Logging initialized using configuration in
    file:/etc/hive/conf.dist/hive-log4j.properties*
    *Hive history
    file=/tmp/impala/hive_job_log_impala_201302272345_1246843221.txt*
    *hive> show tables;*
    *FAILED: Error in metadata: MetaException(message:Got exception:
    org.apache.hadoop.hive.metastore.api.MetaException
    javax.jdo.JDODataStoreException: Required table missing :
    "`SKEWED_STRING_LIST`" in Catalog "" Schema "". DataNucleus requires this
    table to perform its persistence operations. Either your MetaData is
    incorrect, or you need to enable "datanucleus.autoCreateTables"*
    *NestedThrowables:*
    *org.datanucleus.store.rdbms.exceptions.MissingTableException: Required
    table missing : "`SKEWED_STRING_LIST`" in Catalog "" Schema "". DataNucleus
    requires this table to perform its persistence operations. Either your
    MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables")
    *
    *FAILED: Execution Error, return code 1 from
    org.apache.hadoop.hive.ql.exec.DDLTask*
    *hive> *

    I get the same type of error in the Impala shell.

    Can someone take a look and update the instructions?

    Thanks,

    Dave
  • Dave Mariani at Feb 28, 2013 at 4:01 am
    Thanks Lenni. That did the trick.

    Dave

    On Wed, Feb 27, 2013 at 4:09 PM, Lenni Kuff wrote:

    Hi,
    The problem is that the Hive metastore schema is not backwards compatible
    between Hive v0.9 and Hive v0.10. The deployment script needs to be
    updated to change:
    SOURCE
    /usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.9.0.mysql.sql;
    To:
    SOURCE
    /usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.10.0.mysql.sql;

    We will get the blog updated, thanks for letting us know!

    Thanks,
    Lenni
    Software Engineer - Cloudera

    On Wed, Feb 27, 2013 at 3:51 PM, Dave Mariani wrote:

    Hi,

    The latest version of Impala doesn't seem to work with the EC2 set up
    instructions listed here:

    http://blog.cloudera.com/blog/2013/02/from-zero-to-impala-in-minutes

    The cluster seems to set up fine, but I get the following error when
    running a 'show tables' command from the Hive CLI:

    *-bash-4.1$ hive*
    *Logging initialized using configuration in
    file:/etc/hive/conf.dist/hive-log4j.properties*
    *Hive history
    file=/tmp/impala/hive_job_log_impala_201302272345_1246843221.txt*
    *hive> show tables;*
    *FAILED: Error in metadata: MetaException(message:Got exception:
    org.apache.hadoop.hive.metastore.api.MetaException
    javax.jdo.JDODataStoreException: Required table missing :
    "`SKEWED_STRING_LIST`" in Catalog "" Schema "". DataNucleus requires this
    table to perform its persistence operations. Either your MetaData is
    incorrect, or you need to enable "datanucleus.autoCreateTables"*
    *NestedThrowables:*
    *org.datanucleus.store.rdbms.exceptions.MissingTableException: Required
    table missing : "`SKEWED_STRING_LIST`" in Catalog "" Schema "". DataNucleus
    requires this table to perform its persistence operations. Either your
    MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables")
    *
    *FAILED: Execution Error, return code 1 from
    org.apache.hadoop.hive.ql.exec.DDLTask*
    *hive> *

    I get the same type of error in the Impala shell.

    Can someone take a look and update the instructions?

    Thanks,

    Dave

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupimpala-user @
categorieshadoop
postedFeb 27, '13 at 11:51p
activeFeb 28, '13 at 4:01a
posts3
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Dave Mariani: 2 posts Lenni Kuff: 1 post

People

Translate

site design / logo © 2022 Grokbase