在安装hive时,安装完MySQL、启动Hadoop集群后,使用bin/hive启动Hive时报错
2020-11-26 16:53:03,705 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:newRawStore(589)) - 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore
2020-11-26 16:53:03,706 INFO [main]: metastore.ObjectStore (ObjectStore.java:initialize(289)) - ObjectStore, initialize called
2020-11-26 16:53:03,764 ERROR [main]: Datastore.Schema (Log4JLogger.java:error(125)) - Failed initialising database.
The java type java.lang.Integer (jdbc-type="", sql-type="") cant be mapped for this datastore. No mapping is available.
org.datanucleus.exceptions.NucleusException: The java type java.lang.Integer (jdbc-type="", sql-type="") cant be mapped for this datastore. No mapping is available.
at org.datanucleus.store.rdbms.mapping.RDBMSMappingManager.getDatastoreMappingClass(RDBMSMappingManager.java:1215)
at org.datanucleus.store.rdbms.mapping.RDBMSMappingManager.createDatastoreMapping(RDBMSMappingManager.java:1378)
at org.datanucleus.store.rdbms.table.ProbeTable.initialize(ProbeTable.java:66)
at org.datanucleus.store.rdbms.RDBMSStoreManager.initialiseSchema(RDBMSStoreManager.java:1430)
at org.datanucleus.store.rdbms.RDBMSStoreManager.(RDBMSStoreManager.java:391)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
at org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187)
at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at javax.jdo.JDOHelper
16.
r
u
n
(
J
D
O
H
e
l
p
e
r
.
j
a
v
a
:
1965
)
a
t
j
a
v
a
.
b
a
s
e
/
j
a
v
a
.
s
e
c
u
r
i
t
y
.
A
c
c
e
s
s
C
o
n
t
r
o
l
l
e
r
.
d
o
P
r
i
v
i
l
e
g
e
d
(
A
c
c
e
s
s
C
o
n
t
r
o
l
l
e
r
.
j
a
v
a
:
554
)
a
t
j
a
v
a
x
.
j
d
o
.
J
D
O
H
e
l
p
e
r
.
i
n
v
o
k
e
(
J
D
O
H
e
l
p
e
r
.
j
a
v
a
:
1960
)
a
t
j
a
v
a
x
.
j
d
o
.
J
D
O
H
e
l
p
e
r
.
i
n
v
o
k
e
G
e
t
P
e
r
s
i
s
t
e
n
c
e
M
a
n
a
g
e
r
F
a
c
t
o
r
y
O
n
I
m
p
l
e
m
e
n
t
a
t
i
o
n
(
J
D
O
H
e
l
p
e
r
.
j
a
v
a
:
1166
)
a
t
j
a
v
a
x
.
j
d
o
.
J
D
O
H
e
l
p
e
r
.
g
e
t
P
e
r
s
i
s
t
e
n
c
e
M
a
n
a
g
e
r
F
a
c
t
o
r
y
(
J
D
O
H
e
l
p
e
r
.
j
a
v
a
:
808
)
a
t
j
a
v
a
x
.
j
d
o
.
J
D
O
H
e
l
p
e
r
.
g
e
t
P
e
r
s
i
s
t
e
n
c
e
M
a
n
a
g
e
r
F
a
c
t
o
r
y
(
J
D
O
H
e
l
p
e
r
.
j
a
v
a
:
701
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
O
b
j
e
c
t
S
t
o
r
e
.
g
e
t
P
M
F
(
O
b
j
e
c
t
S
t
o
r
e
.
j
a
v
a
:
365
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
O
b
j
e
c
t
S
t
o
r
e
.
g
e
t
P
e
r
s
i
s
t
e
n
c
e
M
a
n
a
g
e
r
(
O
b
j
e
c
t
S
t
o
r
e
.
j
a
v
a
:
394
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
O
b
j
e
c
t
S
t
o
r
e
.
i
n
i
t
i
a
l
i
z
e
(
O
b
j
e
c
t
S
t
o
r
e
.
j
a
v
a
:
291
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
O
b
j
e
c
t
S
t
o
r
e
.
s
e
t
C
o
n
f
(
O
b
j
e
c
t
S
t
o
r
e
.
j
a
v
a
:
258
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
u
t
i
l
.
R
e
f
l
e
c
t
i
o
n
U
t
i
l
s
.
s
e
t
C
o
n
f
(
R
e
f
l
e
c
t
i
o
n
U
t
i
l
s
.
j
a
v
a
:
76
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
u
t
i
l
.
R
e
f
l
e
c
t
i
o
n
U
t
i
l
s
.
n
e
w
I
n
s
t
a
n
c
e
(
R
e
f
l
e
c
t
i
o
n
U
t
i
l
s
.
j
a
v
a
:
136
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
R
a
w
S
t
o
r
e
P
r
o
x
y
.
<
i
n
i
t
>
(
R
a
w
S
t
o
r
e
P
r
o
x
y
.
j
a
v
a
:
57
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
R
a
w
S
t
o
r
e
P
r
o
x
y
.
g
e
t
P
r
o
x
y
(
R
a
w
S
t
o
r
e
P
r
o
x
y
.
j
a
v
a
:
66
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
H
i
v
e
M
e
t
a
S
t
o
r
e
16.run(JDOHelper.java:1965) at java.base/java.security.AccessController.doPrivileged(AccessController.java:554) at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960) at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166) at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808) at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701) at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365) at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394) at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291) at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57) at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66) at org.apache.hadoop.hive.metastore.HiveMetaStore
16.run(JDOHelper.java:1965)atjava.base/java.security.AccessController.doPrivileged(AccessController.java:554)atjavax.jdo.JDOHelper.invoke(JDOHelper.java:1960)atjavax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166)atjavax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808)atjavax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701)atorg.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365)atorg.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394)atorg.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291)atorg.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258)atorg.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)atorg.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)atorg.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57)atorg.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66)atorg.apache.hadoop.hive.metastore.HiveMetaStoreHMSHandler.newRawStore(HiveMetaStore.java:593)
at org.apache.hadoop.hive.metastore.HiveMetaStore
H
M
S
H
a
n
d
l
e
r
.
g
e
t
M
S
(
H
i
v
e
M
e
t
a
S
t
o
r
e
.
j
a
v
a
:
571
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
H
i
v
e
M
e
t
a
S
t
o
r
e
HMSHandler.getMS(HiveMetaStore.java:571) at org.apache.hadoop.hive.metastore.HiveMetaStore
HMSHandler.getMS(HiveMetaStore.java:571)atorg.apache.hadoop.hive.metastore.HiveMetaStoreHMSHandler.createDefaultDB(HiveMetaStore.java:624)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.(RetryingHMSHandler.java:66)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.(HiveMetaStoreClient.java:199)
at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.(SessionHiveMetaStoreClient.java:74)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481)
at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.(RetryingMetaStoreClient.java:86)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)
at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005)
at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024)
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
2020-11-26 16:53:03,764 ERROR [main]: Datastore.Schema (Log4JLogger.java:error(125)) - Failed initialising database.
The java type java.lang.Integer (jdbc-type="", sql-type="") cant be mapped for this datastore. No mapping is available.
org.datanucleus.exceptions.NucleusException: The java type java.lang.Integer (jdbc-type="", sql-type="") cant be mapped for this datastore. No mapping is available.
at org.datanucleus.store.rdbms.mapping.RDBMSMappingManager.getDatastoreMappingClass(RDBMSMappingManager.java:1215)
at org.datanucleus.store.rdbms.mapping.RDBMSMappingManager.createDatastoreMapping(RDBMSMappingManager.java:1378)
at org.datanucleus.store.rdbms.table.ProbeTable.initialize(ProbeTable.java:66)
at org.datanucleus.store.rdbms.RDBMSStoreManager.initialiseSchema(RDBMSStoreManager.java:1430)
at org.datanucleus.store.rdbms.RDBMSStoreManager.(RDBMSStoreManager.java:391)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481)
at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631)
at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
at org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187)
at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333)
at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at javax.jdo.JDOHelper
16.
r
u
n
(
J
D
O
H
e
l
p
e
r
.
j
a
v
a
:
1965
)
a
t
j
a
v
a
.
b
a
s
e
/
j
a
v
a
.
s
e
c
u
r
i
t
y
.
A
c
c
e
s
s
C
o
n
t
r
o
l
l
e
r
.
d
o
P
r
i
v
i
l
e
g
e
d
(
A
c
c
e
s
s
C
o
n
t
r
o
l
l
e
r
.
j
a
v
a
:
554
)
a
t
j
a
v
a
x
.
j
d
o
.
J
D
O
H
e
l
p
e
r
.
i
n
v
o
k
e
(
J
D
O
H
e
l
p
e
r
.
j
a
v
a
:
1960
)
a
t
j
a
v
a
x
.
j
d
o
.
J
D
O
H
e
l
p
e
r
.
i
n
v
o
k
e
G
e
t
P
e
r
s
i
s
t
e
n
c
e
M
a
n
a
g
e
r
F
a
c
t
o
r
y
O
n
I
m
p
l
e
m
e
n
t
a
t
i
o
n
(
J
D
O
H
e
l
p
e
r
.
j
a
v
a
:
1166
)
a
t
j
a
v
a
x
.
j
d
o
.
J
D
O
H
e
l
p
e
r
.
g
e
t
P
e
r
s
i
s
t
e
n
c
e
M
a
n
a
g
e
r
F
a
c
t
o
r
y
(
J
D
O
H
e
l
p
e
r
.
j
a
v
a
:
808
)
a
t
j
a
v
a
x
.
j
d
o
.
J
D
O
H
e
l
p
e
r
.
g
e
t
P
e
r
s
i
s
t
e
n
c
e
M
a
n
a
g
e
r
F
a
c
t
o
r
y
(
J
D
O
H
e
l
p
e
r
.
j
a
v
a
:
701
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
O
b
j
e
c
t
S
t
o
r
e
.
g
e
t
P
M
F
(
O
b
j
e
c
t
S
t
o
r
e
.
j
a
v
a
:
365
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
O
b
j
e
c
t
S
t
o
r
e
.
g
e
t
P
e
r
s
i
s
t
e
n
c
e
M
a
n
a
g
e
r
(
O
b
j
e
c
t
S
t
o
r
e
.
j
a
v
a
:
394
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
O
b
j
e
c
t
S
t
o
r
e
.
i
n
i
t
i
a
l
i
z
e
(
O
b
j
e
c
t
S
t
o
r
e
.
j
a
v
a
:
291
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
O
b
j
e
c
t
S
t
o
r
e
.
s
e
t
C
o
n
f
(
O
b
j
e
c
t
S
t
o
r
e
.
j
a
v
a
:
258
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
u
t
i
l
.
R
e
f
l
e
c
t
i
o
n
U
t
i
l
s
.
s
e
t
C
o
n
f
(
R
e
f
l
e
c
t
i
o
n
U
t
i
l
s
.
j
a
v
a
:
76
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
u
t
i
l
.
R
e
f
l
e
c
t
i
o
n
U
t
i
l
s
.
n
e
w
I
n
s
t
a
n
c
e
(
R
e
f
l
e
c
t
i
o
n
U
t
i
l
s
.
j
a
v
a
:
136
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
R
a
w
S
t
o
r
e
P
r
o
x
y
.
<
i
n
i
t
>
(
R
a
w
S
t
o
r
e
P
r
o
x
y
.
j
a
v
a
:
57
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
R
a
w
S
t
o
r
e
P
r
o
x
y
.
g
e
t
P
r
o
x
y
(
R
a
w
S
t
o
r
e
P
r
o
x
y
.
j
a
v
a
:
66
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
H
i
v
e
M
e
t
a
S
t
o
r
e
16.run(JDOHelper.java:1965) at java.base/java.security.AccessController.doPrivileged(AccessController.java:554) at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960) at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166) at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808) at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701) at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365) at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394) at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291) at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57) at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66) at org.apache.hadoop.hive.metastore.HiveMetaStore
16.run(JDOHelper.java:1965)atjava.base/java.security.AccessController.doPrivileged(AccessController.java:554)atjavax.jdo.JDOHelper.invoke(JDOHelper.java:1960)atjavax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166)atjavax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808)atjavax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701)atorg.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365)atorg.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394)atorg.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291)atorg.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258)atorg.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)atorg.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)atorg.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57)atorg.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66)atorg.apache.hadoop.hive.metastore.HiveMetaStoreHMSHandler.newRawStore(HiveMetaStore.java:593)
at org.apache.hadoop.hive.metastore.HiveMetaStore
H
M
S
H
a
n
d
l
e
r
.
g
e
t
M
S
(
H
i
v
e
M
e
t
a
S
t
o
r
e
.
j
a
v
a
:
571
)
a
t
o
r
g
.
a
p
a
c
h
e
.
h
a
d
o
o
p
.
h
i
v
e
.
m
e
t
a
s
t
o
r
e
.
H
i
v
e
M
e
t
a
S
t
o
r
e
HMSHandler.getMS(HiveMetaStore.java:571) at org.apache.hadoop.hive.metastore.HiveMetaStore
HMSHandler.getMS(HiveMetaStore.java:571)atorg.apache.hadoop.hive.metastore.HiveMetaStoreHMSHandler.createDefaultDB(HiveMetaStore.java:624)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.(RetryingHMSHandler.java:66)
at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)
at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.(HiveMetaStoreClient.java:199)
at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.(SessionHiveMetaStoreClient.java:74)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481)
at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.(RetryingMetaStoreClient.java:86)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)
at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005)
at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024)
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
报出上面的异常,主要是因为Java的字段匹配不上数据库中一些字段,说的再明白一点就是Java版本过高,或者是说hive版本过低。
在之前我是用的是:
hive 1.2.1
hadoop 2.7.0
MySQL 5.1.x
jdk用的14.x版本
由于jdk版本过高,我换成的万能的jdk1.8,Hadoop中的hadoop-env.sh文件中的Java版本也需要修改。
再重新启动Hadoop集群后,启动hive,结果就成功了!
这就是修改完jdk后启动的hive