Amazon athena connection

[Prakhar1]

I need to connect to Athena Database.

Any sample job or way to achieve this ?

[Anonymous]

Hi
I think the below two documentations can help you.
https://community.talend.com/t5/Design-and-Development/Connecting-Talend-on-Amazon-Athena/td-p/55940
https://help.talend.com/reader/36FNvH4mND6uL3cKKzTU~w/~xQ_ZPcAetw8zVHCU31Xdg

Regards
Shong

[Prakhar1]

I am getting this error 

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

[Anonymous]

@Prakhar
Can you upload some screenshots of your settings and provide the following information, it will help us to more easily evaluate your issue:
- Product and Version which you used (for example, Talend Data Fabric 7.3.1)
- Operating System, for example, Windows Server 2008 R2 SP1 (64bit)
- Version of Java Platform JDK / JRE in use (for example, ORACLE JDK 1.8.0_161)


Regards
Shong

[Prakhar1]

Hi @shong 

I have attached the connection screenshot and job design and java version screenshot.

I am using talend 7.2.1 for Big data.

Below is the error 

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)

Please check.