SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 65176: Registering an SPD Engine table with SAS® Hive SerDe for SPD Engine might fail with a java.lang.NoSuchMethodError exception

DetailsHotfixAboutRate It

Registering a SAS® Scalable Performance Data (SPD) Engine table with the SAS Hive SerDe for SPD Engine might fail with an error similar to the following:

SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/usr/hdp/3.0.0.8-1/hadoop/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl
/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/net/bb02na2a/vol/sasusr/u/fedadmin/sdm/hadoopjars/hdp30/prod/log4j-sl
f4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/net/bb02na2a/vol/sasusr/u/fedadmin/sdm/hadoopjars/hdp30/prod/slf4j-lo
g4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
19/01/31 14:07:09 INFO conf.HiveConf: Found configuration file
file:/net/bb02na2a/vol/sasusr/u/fedadmin/sdm/hadoopcfg/hdp30d1/prod/hive-site.xm
l
19/01/31 14:07:09 WARN conf.HiveConf: HiveConf of name
hive.stats.fetch.partition.stats does not exist
19/01/31 14:07:09 WARN conf.HiveConf: HiveConf of name hive.heapsize does not
exist
Exception in thread "main" java.lang.NoSuchMethodError:
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(Lorg/apache/hadoop/h
ive/conf/HiveConf;)V
        at
com.sas.hadoop.serde.spde.hive.MetastoreRegistration.run(MetastoreRegistration.j
ava:122)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:90)
        at
com.sas.hadoop.serde.spde.hive.MetastoreRegistration.main(MetastoreRegistration.
java:53)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
a:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.hadoop.util.RunJar.run(RunJar.java:318)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:232)

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemBase SASz/OS9.4_M69.4_M69.4 TS1M69.4 TS1M6
z/OS 64-bit9.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft® Windows® for x649.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows 8 Enterprise 32-bit9.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows 8 Enterprise x649.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows 8 Pro 32-bit9.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows 8 Pro x649.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows 8.1 Enterprise 32-bit9.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows 8.1 Enterprise x649.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows 8.1 Pro 32-bit9.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows 8.1 Pro x649.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows 109.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows Server 2012 Datacenter9.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows Server 2012 R2 Datacenter9.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows Server 2012 R2 Std9.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows Server 2012 Std9.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows Server 20169.4_M69.4_M69.4 TS1M69.4 TS1M6
Microsoft Windows Server 20199.4_M69.4_M69.4 TS1M69.4 TS1M6
Windows 7 Enterprise 32 bit9.4_M69.4_M69.4 TS1M69.4 TS1M6
Windows 7 Enterprise x649.4_M69.4_M69.4 TS1M69.4 TS1M6
Windows 7 Home Premium 32 bit9.4_M69.4_M69.4 TS1M69.4 TS1M6
Windows 7 Home Premium x649.4_M69.4_M69.4 TS1M69.4 TS1M6
Windows 7 Professional 32 bit9.4_M69.4_M69.4 TS1M69.4 TS1M6
Windows 7 Professional x649.4_M69.4_M69.4 TS1M69.4 TS1M6
Windows 7 Ultimate 32 bit9.4_M69.4_M69.4 TS1M69.4 TS1M6
Windows 7 Ultimate x649.4_M69.4_M69.4 TS1M69.4 TS1M6
64-bit Enabled AIX9.4_M69.4_M69.4 TS1M69.4 TS1M6
64-bit Enabled Solaris9.4_M69.4_M69.4 TS1M69.4 TS1M6
HP-UX IPF9.4_M69.4_M69.4 TS1M69.4 TS1M6
Linux for x649.4_M69.4_M69.4 TS1M69.4 TS1M6
Solaris for x649.4_M69.4_M69.4 TS1M69.4 TS1M6
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.