hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mich Talebzadeh" <m...@peridale.co.uk>
Subject RE: SemanticException Unable to fetch table t. null
Date Tue, 03 Nov 2015 20:07:49 GMT
Thanks where is it fixed? Is there any patch available.

 

 

 

Mich Talebzadeh

 

Sybase ASE 15 Gold Medal Award 2008

A Winning Strategy: Running the most Critical Financial Data on ASE 15

http://login.sybase.com/files/Product_Overviews/ASE-Winning-Strategy-091908.pdf

Author of the books "A Practitioner’s Guide to Upgrading to Sybase ASE 15", ISBN 978-0-9563693-0-7.


co-author "Sybase Transact SQL Guidelines Best Practices", ISBN 978-0-9759693-0-4

Publications due shortly:

Complex Event Processing in Heterogeneous Environments, ISBN: 978-0-9563693-3-8

Oracle and Sybase, Concepts and Contrasts, ISBN: 978-0-9563693-1-4, volume one out shortly

 

http://talebzadehmich.wordpress.com <http://talebzadehmich.wordpress.com/> 

 

NOTE: The information in this email is proprietary and confidential. This message is for the
designated recipient only, if you are not the intended recipient, you should destroy it immediately.
Any information in this message shall not be understood as given or endorsed by Peridale Technology
Ltd, its subsidiaries or their employees, unless expressly so stated. It is the responsibility
of the recipient to ensure that this email is virus free, therefore neither Peridale Ltd,
its subsidiaries nor their employees accept any responsibility.

 

From: Sergey Shelukhin [mailto:sergey@hortonworks.com] 
Sent: 03 November 2015 19:52
To: user@hive.apache.org
Subject: Re: SemanticException Unable to fetch table t. null

 

This error is not related to the issue, it’s just an old DB type check that runs db-specific
queries and sees which ones don’t fail. It has been fixed to not use db-specific queries
lately.

 

From: Mich Talebzadeh <mich@peridale.co.uk <mailto:mich@peridale.co.uk> >
Reply-To: "user@hive.apache.org <mailto:user@hive.apache.org> " <user@hive.apache.org
<mailto:user@hive.apache.org> >
Date: Tuesday, November 3, 2015 at 07:59
To: "user@hive.apache.org <mailto:user@hive.apache.org> " <user@hive.apache.org <mailto:user@hive.apache.org>
>
Subject: RE: SemanticException Unable to fetch table t. null

 

Correct.

 

I am getting this error in hive.log

 

2015-11-03 11:20:28,470 INFO  [main]: hive.metastore (HiveMetaStoreClient.java:open(319))
- Trying to connect to metastore with URI thrift://localhost:9083

2015-11-03 11:20:28,471 INFO  [main]: hive.metastore (HiveMetaStoreClient.java:open(410))
- Connected to metastore.

2015-11-03 11:20:28,471 INFO  [pool-3-thread-83]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(713))
- 59: source:127.0.0.1 get_table : db=asehadoop tbl=t

2015-11-03 11:20:28,476 INFO  [pool-3-thread-83]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(339))
- ugi=hduser      ip=127.0.0.1    cmd=source:127.0.0.1 get_table : db=asehadoop tbl=t

2015-11-03 11:20:28,476 INFO  [pool-3-thread-83]: metastore.HiveMetaStore (HiveMetaStore.java:newRawStore(556))
- 59: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore

2015-11-03 11:20:28,476 INFO  [pool-3-thread-83]: metastore.ObjectStore (ObjectStore.java:initialize(264))
- ObjectStore, initialize called

2015-11-03 11:20:28,478 INFO  [pool-3-thread-83]: metastore.MetaStoreDirectSql (MetaStoreDirectSql.java:<init>(109))
- MySQL check failed, assuming we are not on mysql: ORA-00922: missing or invalid option

 

 

My metastore is Oracle and this indicates 

 


ORA-00922:

missing or invalid option


Cause:

An invalid option was specified in defining a column or storage clause. The valid option in
specifying a column is NOT NULL to specify that the column cannot contain any NULL values.
Only constraints may follow the datatype. Specifying a maximum length on a DATE or LONG datatype
also causes this error.

 

So I may have to hack the metadata manually. 

 

 

Mich Talebzadeh

 

Sybase ASE 15 Gold Medal Award 2008

A Winning Strategy: Running the most Critical Financial Data on ASE 15

http://login.sybase.com/files/Product_Overviews/ASE-Winning-Strategy-091908.pdf

Author of the books "A Practitioner’s Guide to Upgrading to Sybase ASE 15", ISBN 978-0-9563693-0-7.


co-author "Sybase Transact SQL Guidelines Best Practices", ISBN 978-0-9759693-0-4

Publications due shortly:

Complex Event Processing in Heterogeneous Environments, ISBN: 978-0-9563693-3-8

Oracle and Sybase, Concepts and Contrasts, ISBN: 978-0-9563693-1-4, volume one out shortly

 

http://talebzadehmich.wordpress.com <http://talebzadehmich.wordpress.com/> 

 

NOTE: The information in this email is proprietary and confidential. This message is for the
designated recipient only, if you are not the intended recipient, you should destroy it immediately.
Any information in this message shall not be understood as given or endorsed by Peridale Technology
Ltd, its subsidiaries or their employees, unless expressly so stated. It is the responsibility
of the recipient to ensure that this email is virus free, therefore neither Peridale Ltd,
its subsidiaries nor their employees accept any responsibility.

 

From: Rajkumar Singh [mailto:rkstech.java@gmail.com] 
Sent: 03 November 2015 11:11
To: user@hive.apache.org <mailto:user@hive.apache.org> 
Subject: Re: SemanticException Unable to fetch table t. null

 

it seems that you are having a problem metastore.

 

On Tue, Nov 3, 2015 at 1:46 PM, Mich Talebzadeh <mich@peridale.co.uk <mailto:mich@peridale.co.uk>
> wrote:

Hi,

 

Has anyone got a quick fix for dropping such table please?

 

hive> drop table t;

FAILED: SemanticException Unable to fetch table t. null

hive> desc t;

FAILED: SemanticException Unable to fetch table t. null

 

Thanks,

 

Mich Talebzadeh

 

Sybase ASE 15 Gold Medal Award 2008

A Winning Strategy: Running the most Critical Financial Data on ASE 15

http://login.sybase.com/files/Product_Overviews/ASE-Winning-Strategy-091908.pdf

Author of the books "A Practitioner’s Guide to Upgrading to Sybase ASE 15", ISBN 978-0-9563693-0-7.


co-author "Sybase Transact SQL Guidelines Best Practices", ISBN 978-0-9759693-0-4

Publications due shortly:

Complex Event Processing in Heterogeneous Environments, ISBN: 978-0-9563693-3-8

Oracle and Sybase, Concepts and Contrasts, ISBN: 978-0-9563693-1-4, volume one out shortly

 

http://talebzadehmich.wordpress.com <http://talebzadehmich.wordpress.com/> 

 

NOTE: The information in this email is proprietary and confidential. This message is for the
designated recipient only, if you are not the intended recipient, you should destroy it immediately.
Any information in this message shall not be understood as given or endorsed by Peridale Technology
Ltd, its subsidiaries or their employees, unless expressly so stated. It is the responsibility
of the recipient to ensure that this email is virus free, therefore neither Peridale Ltd,
its subsidiaries nor their employees accept any responsibility.

 

 


Mime
View raw message