hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergey Shelukhin <ser...@hortonworks.com>
Subject Re: SemanticException Unable to fetch table t. null
Date Tue, 03 Nov 2015 21:30:39 GMT
https://issues.apache.org/jira/browse/HIVE-11123

However the point is, it’s not a real error, i.e. not the cause of this bug.

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 12:07
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

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<mailto: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