Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-02-08 10:08 AM

Problem connecting to AWS Athena

I am trying to connect to AWS Athena through a JDBC connection. I am using Open Studio for Big Data 7.0.1 with AthenaJDBC41_2.0.6.jar

I created my Db Connection a when I run a 'test connection', all is well.

When I try to test my connection in a Job, I am getting this error. 

Anybody ran into something like this

 

Starting job Athena at 09:51 08/02/2019.

[statistics] connecting to socket on port 3599

[statistics] connected

log4j:ERROR Could not create an Appender. Reported error follows.

java.lang.ClassCastException: org.apache.log4j.ConsoleAppender cannot be cast to com.simba.athena.shaded.apache.log4j.Appender

at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:248)



To see the whole post, download it here
Labels (6)
Labels
474 Views
0 Likes
5 Replies
Anonymous
Not applicable
‎2019-03-04 01:52 AM
Author

Hello,

The tJDBCConnection component is  configured to use "AthenaJDBC42_2.0.5.jar" that contains log4j which is conflicting with the one used by the Job.

Could you please try to configure tJDBCConnection to use "AthenaJDBC41-1.1.0.jar" and adjust driver class name to be "com.amazonaws.athena.jdbc.AthenaDriver"?

Feel free to let us know if it doesn't work for you.

Best regards

Sabrina

474 Views
0 Likes
Anonymous
Not applicable
‎2019-05-01 01:12 AM
Author

I am also getting the same error.

 

Tried switching to AthenaJDBC41-1.1.0.jar and adjusting the driver class but the error still  appears. Error is listed below.

 

Any other possible solutions?

 

Thanks

 

log4j:ERROR Could not create an Appender. Reported error follows.
java.lang.ClassCastException: org.apache.log4j.ConsoleAppender cannot be cast to com.simba.athena.shaded.apache.log4j.Appender
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:248)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java:176)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurator.java:191)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfigurator.java:523)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseCategory(DOMConfigurator.java:436)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:1004)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:872)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:778)
at com.simba.athena.shaded.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:526)
at com.simba.athena.shaded.apache.log4j.LogManager.<clinit>(LogManager.java:127)
at com.simba.athena.shaded.apache.log4j.Logger.getLogger(Logger.java:104)
at com.simba.athena.shaded.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:262)
at com.simba.athena.shaded.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:108)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.createLogFromClass(LogFactoryImpl.java:1025)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.discoverLogImplementation(LogFactoryImpl.java:844)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:541)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:292)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:269)
at com.simba.athena.shaded.apache.commons.logging.LogFactory.getLog(LogFactory.java:655)
at com.simba.athena.amazonaws.util.VersionInfoUtils.<clinit>(VersionInfoUtils.java:47)
at com.simba.athena.amazonaws.ClientConfiguration.<clinit>(ClientConfiguration.java:70)
at com.simba.athena.athena.core.AJSettings.<init>(Unknown Source)
at com.simba.athena.athena.core.AJConnection.connect(Unknown Source)
at com.simba.athena.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
at com.simba.athena.jdbc.common.AbstractDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnection(JdbcRuntimeUtils.java:65)
at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnectionOrGetFromSharedConnectionPoolOrDataSource(JdbcRuntimeUtils.java:194)
at org.talend.components.jdbc.runtime.JDBCSourceOrSink.connect(JDBCSourceOrSink.java:217)
at org.talend.components.jdbc.runtime.setting.JdbcRuntimeSourceOrSinkDefault.initConnection(JdbcRuntimeSourceOrSinkDefault.java:46)
at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.validate(JdbcRuntimeUtils.java:89)
at org.talend.components.jdbc.runtime.JDBCSourceOrSink.validate(JDBCSourceOrSink.java:121)
at ipave_data_load.athena_query_1_1_0_jar_0_1.Athena_Query_1_1_0_JAR.tDBConnection_2Process(Athena_Query_1_1_0_JAR.java:466)
at ipave_data_load.athena_query_1_1_0_jar_0_1.Athena_Query_1_1_0_JAR.runJobInTOS(Athena_Query_1_1_0_JAR.java:1487)
at ipave_data_load.athena_query_1_1_0_jar_0_1.Athena_Query_1_1_0_JAR.main(Athena_Query_1_1_0_JAR.java:1326)

474 Views
0 Likes
Prithamreddy
Contributor
Contributor
‎2020-02-03 06:47 PM

Are you able to overcome this issue. Even I am getting same error.


Thanks!!

474 Views
0 Likes
spokala1002
Contributor
Contributor
‎2020-02-10 01:31 PM

I am also getting the same error.  I tried with both the drivers but no luck. 

Do you have any resolution to this?

 

Starting job kpi_summary_talend_poc at 10:28 10/02/2020.

[statistics] connecting to socket on port 3900
[statistics] connected
log4j:ERROR Could not create an Appender. Reported error follows.
java.lang.ClassCastException: org.apache.log4j.ConsoleAppender cannot be cast to com.simba.athena.shaded.apache.log4j.Appender
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:248)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java:176)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurator.java:191)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfigurator.java:523)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseCategory(DOMConfigurator.java:436)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:1004)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:872)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:778)
at com.simba.athena.shaded.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:526)
at com.simba.athena.shaded.apache.log4j.LogManager.<clinit>(LogManager.java:127)
at com.simba.athena.shaded.apache.log4j.Logger.getLogger(Logger.java:104)
at com.simba.athena.shaded.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:262)
at com.simba.athena.shaded.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:108)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.createLogFromClass(LogFactoryImpl.java:1025)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.discoverLogImplementation(LogFactoryImpl.java:844)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:541)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:292)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:269)
at com.simba.athena.shaded.apache.commons.logging.LogFactory.getLog(LogFactory.java:655)
at com.simba.athena.amazonaws.util.VersionInfoUtils.<clinit>(VersionInfoUtils.java:47)
at com.simba.athena.amazonaws.ClientConfiguration.<clinit>(ClientConfiguration.java:70)
at com.simba.athena.athena.core.AJSettings.<init>(Unknown Source)
at com.simba.athena.athena.core.AJConnection.connect(Unknown Source)
at com.simba.athena.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
at com.simba.athena.jdbc.common.AbstractDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnection(JdbcRuntimeUtils.java:77)
at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnectionOrGetFromSharedConnectionPoolOrDataSource(JdbcRuntimeUtils.java:206)
at org.talend.components.jdbc.runtime.JDBCSourceOrSink.connect(JDBCSourceOrSink.java:217)
at org.talend.components.jdbc.runtime.setting.JdbcRuntimeSourceOrSinkDefault.initConnection(JdbcRuntimeSourceOrSinkDefault.java:46)
at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.validate(JdbcRuntimeUtils.java:101)
at org.talend.components.jdbc.runtime.JDBCSourceOrSink.validate(JDBCSourceOrSink.java:121)
at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.tDBConnection_1Process(kpi_summary_talend_poc.java:759)
at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.tChronometerStart_1Process(kpi_summary_talend_poc.java:593)
at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.tPrejob_1Process(kpi_summary_talend_poc.java:441)
at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.runJobInTOS(kpi_summary_talend_poc.java:1447)
at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.main(kpi_summary_talend_poc.java:1258)
log4j:ERROR Could not create an Appender. Reported error follows.
java.lang.ClassCastException: org.apache.log4j.ConsoleAppender cannot be cast to com.simba.athena.shaded.apache.log4j.Appender
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:248)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java:176)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurator.java:191)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfigurator.java:523)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:492)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:1006)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:872)
at com.simba.athena.shaded.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:778)
at com.simba.athena.shaded.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:526)
at com.simba.athena.shaded.apache.log4j.LogManager.<clinit>(LogManager.java:127)
at com.simba.athena.shaded.apache.log4j.Logger.getLogger(Logger.java:104)
at com.simba.athena.shaded.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:262)
at com.simba.athena.shaded.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:108)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.createLogFromClass(LogFactoryImpl.java:1025)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.discoverLogImplementation(LogFactoryImpl.java:844)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:541)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:292)
at com.simba.athena.shaded.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:269)
at com.simba.athena.shaded.apache.commons.logging.LogFactory.getLog(LogFactory.java:655)
at com.simba.athena.amazonaws.util.VersionInfoUtils.<clinit>(VersionInfoUtils.java:47)
at com.simba.athena.amazonaws.ClientConfiguration.<clinit>(ClientConfiguration.java:70)
at com.simba.athena.athena.core.AJSettings.<init>(Unknown Source)
at com.simba.athena.athena.core.AJConnection.connect(Unknown Source)
at com.simba.athena.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
at com.simba.athena.jdbc.common.AbstractDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnection(JdbcRuntimeUtils.java:77)
at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.createConnectionOrGetFromSharedConnectionPoolOrDataSource(JdbcRuntimeUtils.java:206)
at org.talend.components.jdbc.runtime.JDBCSourceOrSink.connect(JDBCSourceOrSink.java:217)
at org.talend.components.jdbc.runtime.setting.JdbcRuntimeSourceOrSinkDefault.initConnection(JdbcRuntimeSourceOrSinkDefault.java:46)
at org.talend.components.jdbc.runtime.JdbcRuntimeUtils.validate(JdbcRuntimeUtils.java:101)
at org.talend.components.jdbc.runtime.JDBCSourceOrSink.validate(JDBCSourceOrSink.java:121)
at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.tDBConnection_1Process(kpi_summary_talend_poc.java:759)
at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.tChronometerStart_1Process(kpi_summary_talend_poc.java:593)
at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.tPrejob_1Process(kpi_summary_talend_poc.java:441)
at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.runJobInTOS(kpi_summary_talend_poc.java:1447)
at test.kpi_summary_talend_poc_0_1.kpi_summary_talend_poc.main(kpi_summary_talend_poc.java:1258)

474 Views
0 Likes
Anonymous
Not applicable
‎2020-04-23 07:16 AM
Author

FYI

 

ON Studio:

Talend Cloud Real-Time Big Data Platform

Version: 7.2.1
Build id: 20190620_1446

 

Setup an Athena connection with "AthenaJDBC42_2.0.9.jar"   and class path "com.simba.athena.jdbc42.Driver" and then in tDbConnection with a select statement we get the "log4j:ERROR Could not create an Appender. Reported error follows." error.

 

Any update on workarounds?

 

Thanks

474 Views
0 Likes