Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> FAILED: Error in semantic analysis: Unable to fetch table test_table


Copy link to this message
-
Re: FAILED: Error in semantic analysis: Unable to fetch table test_table
not that this is any consolation but on my mysql instance, same cdh
release, i have the following for IS_COMPRESSED where you have 'false':

{code}
{metastore@etl1 root 13:13}>select SD_ID, is_compressed from SDS limit 10;
+-------+---------------+
| SD_ID | is_compressed |
+-------+---------------+
|     1 |               |
|     2 |               |
|     6 |               |
|    11 |               |
|    26 |               |
|    31 |               |
|    36 |               |
|    41 |               |
|    46 |               |
|    47 |               |
+-------+---------------+
10 rows in set (0.00 sec)
{code}

so *maybe* that 'false' value there is something specific to your backend
store?  might you experiment and change it to a null string? and see if
that changes anything?   Something to think about anyway.

On Mon, Jun 3, 2013 at 12:49 PM, Jamal B <[EMAIL PROTECTED]> wrote:

> Please forgive the cross post, but I could really use some help.
>
> I have Hive setup using a remote metastore, backed by H2, and am able to
> create tables, load data, and query them without issue.  However, when I
> restart the remote metastore, I can no longer query previously created
> tables.  'show tables' shows them, but when I perform a simple select
> 'select * from test_table limit 5' I receive a FAILED: Error in semantic
> analysis: Unable to fetch table test_table error.  When I look at the logs
> in the metastore, I noticed the following exceptions repeat until the retry
> limit is exceeded:
>
> 13/06/03 19:02:06 INFO HiveMetaStore.audit: ugi=rtws ip=unknown-ip-addr cmd=get_table
> : db=default tbl=test_table
> 13/06/03 19:02:06 INFO DataNucleus.MetaData: Listener found initialisation
> for persistable class org.apache.hadoop.hive.metastore.model.MSerDeInfo
> 13/06/03 19:02:06 INFO DataNucleus.MetaData: Listener found initialisation
> for persistable class
> org.apache.hadoop.hive.metastore.model.MStorageDescriptor
> 13/06/03 19:02:06 INFO DataNucleus.MetaData: Listener found initialisation
> for persistable class org.apache.hadoop.hive.metastore.model.MTable
> 13/06/03 19:02:06 INFO DataNucleus.JDO: Exception thrown
>  Illegal null value in column SDS.IS_COMPRESSED
> org.datanucleus.exceptions.NucleusDataStoreException: Illegal null value
> in column SDS.IS_COMPRESSED
> at
> org.datanucleus.store.rdbms.mapping.CharRDBMSMapping.getBoolean(CharRDBMSMapping.java:374)
>  at
> org.datanucleus.store.mapped.mapping.SingleFieldMapping.getBoolean(SingleFieldMapping.java:122)
> at
> org.datanucleus.store.rdbms.fieldmanager.ResultSetGetter.fetchBooleanField(ResultSetGetter.java:64)
>  at
> org.datanucleus.state.AbstractStateManager.replacingBooleanField(AbstractStateManager.java:1038)
> at
> org.apache.hadoop.hive.metastore.model.MStorageDescriptor.jdoReplaceField(MStorageDescriptor.java)
>  at
> org.apache.hadoop.hive.metastore.model.MStorageDescriptor.jdoReplaceFields(MStorageDescriptor.java)
> at
> org.datanucleus.jdo.state.JDOStateManagerImpl.replaceFields(JDOStateManagerImpl.java:2860)
>  at
> org.datanucleus.store.rdbms.query.PersistentClassROF$2.fetchFields(PersistentClassROF.java:487)
> at
> org.datanucleus.jdo.state.JDOStateManagerImpl.loadFieldValues(JDOStateManagerImpl.java:858)
>  at
> org.datanucleus.jdo.state.JDOStateManagerImpl.initialiseForHollow(JDOStateManagerImpl.java:258)
> at
> org.datanucleus.state.StateManagerFactory.newStateManagerForHollowPopulated(StateManagerFactory.java:87)
>  at
> org.datanucleus.ObjectManagerImpl.findObject(ObjectManagerImpl.java:2389)
> at
> org.datanucleus.store.rdbms.query.PersistentClassROF.getObjectForDatastoreId(PersistentClassROF.java:481)
>  at
> org.datanucleus.store.rdbms.query.PersistentClassROF.getObject(PersistentClassROF.java:366)
> at
> org.datanucleus.store.rdbms.fieldmanager.ResultSetGetter.fetchObjectField(ResultSetGetter.java:144)
>  at
> org.datanucleus.state.AbstractStateManager.replacingObjectField(AbstractStateManager.java:1183)
> at
> org.apache.hadoop.hive.metastore.model.MTable.jdoReplaceField(MTable.java)