[
https://issues.apache.org/jira/browse/HIVE-17575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16175490#comment-16175490
]
mohammed morshed commented on HIVE-17575:
-----------------------------------------
Below is the Workaround to resolve the issue:
===================================
In your Hadoop cluster nodes, edit the file
“/etc/hive/conf.dist/hive-exec-log4j2.properties”
property.hive.root.logger = FA
appender.FA.type = RandomAccessFile
appender.FA.name = FA
appender.FA.fileName = ${sys:hive.log.dir}/${sys:hive.log.file1}
and
Also edit in your cluster nodes “/etc/hadoop/conf.empty/log4j.properties”
hadoop.log.file1=hadoop1.log
hadoop.log.file2=hadoop2.log
hadoop.log.file3=hadoop3.log
log4j.appender.HADOOP.File=${hadoop.log.dir}/${hadoop.log.file1}
log4j.appender.MAPRED.File=${hadoop.log.dir}/${hadoop.log.file2}
log4j.appender.RFA.File=${hadoop.log.dir}/${hadoop.log.file3}
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
> main ERROR Unable to locate appender "FA" for logger config "root"
> ------------------------------------------------------------------
>
> Key: HIVE-17575
> URL: https://issues.apache.org/jira/browse/HIVE-17575
> Project: Hive
> Issue Type: Bug
> Components: Beeline, Hive
> Reporter: mohammed morshed
> Priority: Critical
> Labels: usability
>
> Problem: In Hive version 2.3, when running 'INSERT' statements from beeline,
> observed following error as below:
> 0: jdbc:hive2://localhost:10000>INSERT INTO TABLE
> w2867998436858995169_write_orders_bkt_tgt_tmp_m_orders_updtx_50percent SELECT
> orders_bkt.o_orderkey as a0, orders_bkt.o_custkey as a1,
> orders_bkt.o_totalprice as a2, orders_bkt.o_orderdate as a3,
> orders_bkt.o_orderpriority as a4, orders_bkt.o_clerk as a5,
> orders_bkt.o_shippriority as a6, orders_bkt.o_comment as a7,
> orders_bkt.o_orderstatus as a8 FROM
> w2867998436858995169_write_orders_bkt_src_tmp_m_orders_updtx_50percent JOIN
> TPCH_TEXT_S3_SINGLE_100.orders_bkt ON
> (w2867998436858995169_write_orders_bkt_src_tmp_m_orders_updtx_50percent.a0 =
> orders_bkt.o_orderkey);
> WARN : Hive-on-MR is deprecated in Hive 2 and may not be available in the
> future versions. Consider using a different execution engine (i.e. spark,
> tez) or using Hive 1.X releases.
> INFO : WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available
> in the future versions. Consider using a different execution engine (i.e.
> spark, tez) or using Hive 1.X releases.
> WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the
> future versions. Consider using a different execution engine (i.e. spark,
> tez) or using Hive 1.X releases.
> INFO : Query ID = hive_20170921204456_1d837547-fa86-43c5-b57f-e16085abc5d8
> INFO : Total jobs = 3
> INFO : Starting task [Stage-6:CONDITIONAL] in serial mode
> INFO : Stage-7 is selected by condition resolver.
> INFO : Stage-1 is filtered out by condition resolver.
> INFO : Starting task [Stage-7:MAPREDLOCAL] in serial mode
> 2017-09-21 20:46:54,822 main ERROR Unable to invoke factory method in class
> class org.apache.logging.log4j.core.appender.RandomAccessFileAppender for
> element RandomAccessFile. java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at
> org.apache.logging.log4j.core.config.plugins.util.PluginBuilder.build(PluginBuilder.java:132)
> at
> org.apache.logging.log4j.core.config.AbstractConfiguration.createPluginObject(AbstractConfiguration.java:918)
> at
> org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:858)
> at
> org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:850)
> at
> org.apache.logging.log4j.core.config.AbstractConfiguration.doConfigure(AbstractConfiguration.java:479)
> at
> org.apache.logging.log4j.core.config.AbstractConfiguration.initialize(AbstractConfiguration.java:219)
> at
> org.apache.logging.log4j.core.config.AbstractConfiguration.start(AbstractConfiguration.java:231)
> at
> org.apache.logging.log4j.core.LoggerContext.setConfiguration(LoggerContext.java:496)
> at
> org.apache.logging.log4j.core.LoggerContext.reconfigure(LoggerContext.java:566)
> at
> org.apache.logging.log4j.core.LoggerContext.setConfigLocation(LoggerContext.java:555)
> at
> org.apache.logging.log4j.core.selector.ClassLoaderContextSelector.locateContext(ClassLoaderContextSelector.java:157)
> at
> org.apache.logging.log4j.core.selector.ClassLoaderContextSelector.getContext(ClassLoaderContextSelector.java:74)
> at
> org.apache.logging.log4j.core.impl.Log4jContextFactory.getContext(Log4jContextFactory.java:227)
> at
> org.apache.logging.log4j.core.config.Configurator.initialize(Configurator.java:157)
> at
> org.apache.logging.log4j.core.config.Configurator.initialize(Configurator.java:130)
> at
> org.apache.logging.log4j.core.config.Configurator.initialize(Configurator.java:100)
> at
> org.apache.logging.log4j.core.config.Configurator.initialize(Configurator.java:187)
> at
> org.apache.hadoop.hive.common.LogUtils.initHiveLog4jDefault(LogUtils.java:154)
> at
> org.apache.hadoop.hive.common.LogUtils.initHiveLog4jCommon(LogUtils.java:90)
> at
> org.apache.hadoop.hive.common.LogUtils.initHiveLog4jCommon(LogUtils.java:82)
> at
> org.apache.hadoop.hive.common.LogUtils.initHiveExecLog4j(LogUtils.java:76)
> at
> org.apache.hadoop.hive.ql.exec.mr.ExecDriver.setupChildLog4j(ExecDriver.java:634)
> at
> org.apache.hadoop.hive.ql.exec.mr.ExecDriver.main(ExecDriver.java:714)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
> Caused by: java.lang.ClassCastException:
> org.apache.logging.log4j.core.appender.RandomAccessFileManager$FactoryData
> cannot be cast to
> org.apache.logging.log4j.core.appender.rolling.RollingRandomAccessFileManager$FactoryData
> at
> org.apache.logging.log4j.core.appender.rolling.RollingRandomAccessFileManager.updateData(RollingRandomAccessFileManager.java:253)
> at
> org.apache.logging.log4j.core.appender.AbstractManager.getManager(AbstractManager.java:80)
> at
> org.apache.logging.log4j.core.appender.OutputStreamManager.getManager(OutputStreamManager.java:81)
> at
> org.apache.logging.log4j.core.appender.RandomAccessFileManager.getFileManager(RandomAccessFileManager.java:70)
> at
> org.apache.logging.log4j.core.appender.RandomAccessFileAppender.createAppender(RandomAccessFileAppender.java:166)
> ... 33 more
> 2017-09-21 20:46:54,825 main ERROR Null object returned for RandomAccessFile
> in Appenders.
> 2017-09-21 20:46:54,825 main ERROR Unable to locate appender "FA" for logger
> config "root"
> =======================================================================
> The error is due to multiple log4j appender is trying to write in the same
> file or location.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
