메뉴 건너뛰기

Bigdata, Semantic IoT, Hadoop, NoSQL

Bigdata, Hadoop ecosystem, Semantic IoT등의 프로젝트를 진행중에 습득한 내용을 정리하는 곳입니다.
필요한 분을 위해서 공개하고 있습니다. 문의사항은 gooper@gooper.com로 메일을 보내주세요.

hive java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error: Unable to deserialize reduce input key from...오류해결방법

총관리자 2015.06.16 09:31 조회 수 : 1758

Hive가 "GROUP BY"에서 최적화하면서 내부적으로 컬럼을 추가하여 reducer로 보내는데 이 컬럼은 실존하지 않는 컬럼으로 문제가 발생할 수 있음

hive 0.14.0에서 default가 disabled되었는데 이전 버전에서는 default가 enabled로 되어 있어서 문제가 발생하면

set hive.optimize.sort.dynamic.partition=false;

를 추가하여 준다.

-----오류내용----

2015-06-15 14:12:01,345 INFO [AsyncDispatcher event handler] org.apache.hadoop.mapreduce.v2.app.job.impl.TaskImpl: task_1434344795088_0005_r_000000 Task Transitioned from SCHEDULED to RUNNING
2015-06-15 14:12:02,327 INFO [RMCommunicator Allocator] org.apache.hadoop.mapreduce.v2.app.rm.RMContainerRequestor: getResources() for application_1434344795088_0005: ask=1 release= 0 newContainers=0 finishedContainers=0 resourcelimit=<memory:0, vCores:0> knownNMs=5
2015-06-15 14:12:03,067 INFO [Socket Reader #1 for port 47209] SecurityLogger.org.apache.hadoop.ipc.Server: Auth successful for job_1434344795088_0005 (auth:SIMPLE)
2015-06-15 14:12:03,079 INFO [IPC Server handler 2 on 47209] org.apache.hadoop.mapred.TaskAttemptListenerImpl: JVM with ID : jvm_1434344795088_0005_r_000003 asked for a task
2015-06-15 14:12:03,079 INFO [IPC Server handler 2 on 47209] org.apache.hadoop.mapred.TaskAttemptListenerImpl: JVM with ID: jvm_1434344795088_0005_r_000003 given task: attempt_1434344795088_0005_r_000000_0
2015-06-15 14:12:04,185 INFO [IPC Server handler 1 on 47209] org.apache.hadoop.mapred.TaskAttemptListenerImpl: MapCompletionEvents request from attempt_1434344795088_0005_r_000000_0. startIndex 0 maxEvents 10000
2015-06-15 14:12:04,363 INFO [IPC Server handler 2 on 47209] org.apache.hadoop.mapred.TaskAttemptListenerImpl: Progress of TaskAttempt attempt_1434344795088_0005_r_000000_0 is : 0.0
2015-06-15 14:12:04,382 INFO [IPC Server handler 6 on 47209] org.apache.hadoop.mapred.TaskAttemptListenerImpl: Progress of TaskAttempt attempt_1434344795088_0005_r_000000_0 is : 0.0
2015-06-15 14:12:04,769 INFO [IPC Server handler 7 on 47209] org.apache.hadoop.mapred.TaskAttemptListenerImpl: Progress of TaskAttempt attempt_1434344795088_0005_r_000000_0 is : 0.0
2015-06-15 14:12:04,772 FATAL [IPC Server handler 9 on 47209] org.apache.hadoop.mapred.TaskAttemptListenerImpl: Task: attempt_1434344795088_0005_r_000000_0 - exited : java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error: Unable to deserialize reduce input key from x1x50x48x49x53x45x48x54x45x49x53x32x49x52x58x49x49x58x52x53x0x1x50x48x49x53x45x48x54x45x48x51x0x1x50x48x49x53x45x48x54x45x48x51x32x49x53x58x49x57x58x48x49x46x0x1x50x50x48x46x57x48x46x50x49x54x46x55x51x0x1x104x116x116x112x58x47x47x50x50x48x46x57x48x46x50x0x1x71x69x84x0x1x187x154x203x138x255 with properties {columns=reducesinkkey0,reducesinkkey1,reducesinkkey2,reducesinkkey3,reducesinkkey4,reducesinkkey5,reducesinkkey6, serialization.lib=org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe, serialization.sort.order=+++++++, columns.types=string,string,string,string,string,string,string}
	at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:283)
	at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:444)
	at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:392)
	at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:415)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1614)
	at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error: Unable to deserialize reduce input key from x1x50x48x49x53x45x48x54x45x49x53x32x49x52x58x49x49x58x52x53x0x1x50x48x49x53x45x48x54x45x48x51x0x1x50x48x49x53x45x48x54x45x48x51x32x49x53x58x49x57x58x48x49x46x0x1x50x50x48x46x57x48x46x50x49x54x46x55x51x0x1x104x116x116x112x58x47x47x50x50x48x46x57x48x46x50x0x1x71x69x84x0x1x187x154x203x138x255 with properties {columns=reducesinkkey0,reducesinkkey1,reducesinkkey2,reducesinkkey3,reducesinkkey4,reducesinkkey5,reducesinkkey6, serialization.lib=org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe, serialization.sort.order=+++++++, columns.types=string,string,string,string,string,string,string}
	at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:222)
	... 7 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.io.EOFException
	at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserialize(BinarySortableSerDe.java:189)
	at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:220)
	... 7 more
Caused by: java.io.EOFException
	at org.apache.hadoop.hive.serde2.binarysortable.InputByteBuffer.read(InputByteBuffer.java:54)
	at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserializeText(BinarySortableSerDe.java:550)
	at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserialize(BinarySortableSerDe.java:285)
	at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserialize(BinarySortableSerDe.java:185)
	... 8 more

2015-06-15 14:12:04,772 INFO [IPC Server handler 9 on 47209] org.apache.hadoop.mapred.TaskAttemptListenerImpl: Diagnostics report from attempt_1434344795088_0005_r_000000_0: Error: java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error: Unable to deserialize reduce input key from x1x50x48x49x53x45x48x54x45x49x53x32x49x52x58x49x49x58x52x53x0x1x50x48x49x53x45x48x54x45x48x51x0x1x50x48x49x53x45x48x54x45x48x51x32x49x53x58x49x57x58x48x49x46x0x1x50x50x48x46x57x48x46x50x49x54x46x55x51x0x1x104x116x116x112x58x47x47x50x50x48x46x57x48x46x50x0x1x71x69x84x0x1x187x154x203x138x255 with properties {columns=reducesinkkey0,reducesinkkey1,reducesinkkey2,reducesinkkey3,reducesinkkey4,reducesinkkey5,reducesinkkey6, serialization.lib=org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe, serialization.sort.order=+++++++, columns.types=string,string,string,string,string,string,string}
	at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:283)
	at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:444)
	at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:392)
	at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:415)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1614)
	at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error: Unable to deserialize reduce input key from x1x50x48x49x53x45x48x54x45x49x53x32x49x52x58x49x49x58x52x53x0x1x50x48x49x53x45x48x54x45x48x51x0x1x50x48x49x53x45x48x54x45x48x51x32x49x53x58x49x57x58x48x49x46x0x1x50x50x48x46x57x48x46x50x49x54x46x55x51x0x1x104x116x116x112x58x47x47x50x50x48x46x57x48x46x50x0x1x71x69x84x0x1x187x154x203x138x255 with properties {columns=reducesinkkey0,reducesinkkey1,reducesinkkey2,reducesinkkey3,reducesinkkey4,reducesinkkey5,reducesinkkey6, serialization.lib=org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe, serialization.sort.order=+++++++, columns.types=string,string,string,string,string,string,string}
	at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:222)
	... 7 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.io.EOFException
	at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserialize(BinarySortableSerDe.java:189)
	at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:220)
	... 7 more
Caused by: java.io.EOFException
	at org.apache.hadoop.hive.serde2.binarysortable.InputByteBuffer.read(InputByteBuffer.java:54)
	at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserializeText(BinarySortableSerDe.java:550)
	at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserialize(BinarySortableSerDe.java:285)
	at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserialize(BinarySortableSerDe.java:185)
	... 8 more

2015-06-15 14:12:04,773 INFO [AsyncDispatcher event handler] org.apache.hadoop.mapreduce.v2.app.job.impl.TaskAttemptImpl: Diagnostics report from attempt_1434344795088_0005_r_000000_0: Error: java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error: Unable to deserialize reduce input key from x1x50x48x49x53x45x48x54x45x49x53x32x49x52x58x49x49x58x52x53x0x1x50x48x49x53x45x48x54x45x48x51x0x1x50x48x49x53x45x48x54x45x48x51x32x49x53x58x49x57x58x48x49x46x0x1x50x50x48x46x57x48x46x50x49x54x46x55x51x0x1x104x116x116x112x58x47x47x50x50x48x46x57x48x46x50x0x1x71x69x84x0x1x187x154x203x138x255 with properties {columns=reducesinkkey0,reducesinkkey1,reducesinkkey2,reducesinkkey3,reducesinkkey4,reducesinkkey5,reducesinkkey6, serialization.lib=org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe, serialization.sort.order=+++++++, columns.types=string,string,string,string,string,string,string}
	at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:283)
	at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:444)
	at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:392)
	at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:415)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1614)
	at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error: Unable to deserialize reduce input key from x1x50x48x49x53x45x48x54x45x49x53x32x49x52x58x49x49x58x52x53x0x1x50x48x49x53x45x48x54x45x48x51x0x1x50x48x49x53x45x48x54x45x48x51x32x49x53x58x49x57x58x48x49x46x0x1x50x50x48x46x57x48x46x50x49x54x46x55x51x0x1x104x116x116x112x58x47x47x50x50x48x46x57x48x46x50x0x1x71x69x84x0x1x187x154x203x138x255 with properties {columns=reducesinkkey0,reducesinkkey1,reducesinkkey2,reducesinkkey3,reducesinkkey4,reducesinkkey5,reducesinkkey6, serialization.lib=org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe, serialization.sort.order=+++++++, columns.types=string,string,string,string,string,string,string}
	at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:222)
	... 7 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.io.EOFException
	at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserialize(BinarySortableSerDe.java:189)
	at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:220)
	... 7 more
Caused by: java.io.EOFException
	at org.apache.hadoop.hive.serde2.binarysortable.InputByteBuffer.read(InputByteBuffer.java:54)
	at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserializeText(BinarySortableSerDe.java:550)
	at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserialize(BinarySortableSerDe.java:285)
	at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserialize(BinarySortableSerDe.java:185)
	... 8 more

이 게시물을

목록

댓글 0

번호	제목	글쓴이	날짜	조회 수
741	[CDP7.1.7] oozie sqoop action으로 import혹은 export수행시 발생한 오류에 대한 자세한 로그 확인 하는 방법	gooper	2024.04.19	0
740	[Impala] alter table구문수행시 "WARNINGS: Impala does not have READ_WRITE access to path 'hdfs://nameservice1/DATA/Temp/DB/source/table01_ccd'" 발생시 조치	gooper	2024.04.26	0
739	[CDP7.1.7]Hive Replication수행시 Target Cluster에서 Specified catalog.database.table does not exist 오류	gooper	2024.05.08	0
738	[CDP7.1.7, Replication]Encryption Zone내 HDFS파일을 비Encryption Zone으로 HDFS Replication시 User hdfs가 아닌 hadoop으로 수행하는 방법	gooper	2024.01.15	1
737	[CDP7.1.7]Hive Replication수행중 Specified catalog.database.table does not exist : hive.db명.table명 오류 발생시 조치방법	gooper	2024.04.05	1
736	[CDP7.1.7][Replication]Table does not match version in getMetastore(). Table view original text mismatch	gooper	2024.01.02	3
735	./gradlew :composeDown 및 ./gradlew :composeUp 를 성공했을때의 메세지	gooper	2023.02.20	6
734	호출 url현황	gooper	2023.02.21	6
733	[vue storefrontui]외부 API통합하기 참고 문서	총관리자	2022.02.09	7
732	[Cloudera Agent] Metadata-Plugin throttling_logger INFO (713 skipped) Unable to send data to nav server. Will try again.	gooper	2022.05.16	7
731	[CDP7.1.7, Hive Replication]Hive Replication진행중 "The following columns have types incompatible with the existing columns in their respective positions " 오류	gooper	2023.12.27	7
730	[CDP7.1.7]Oozie job에서 ERROR: Kudu error(s) reported, first error: Timed out: Failed to write batch of 774 ops to tablet 8003f9a064bf4be5890a178439b2ba91가 발생하면서 쿼리가 실패하는 경우	gooper	2024.01.05	7
729	eclipse editor 설정방법	총관리자	2022.02.01	10
728	oozie의 sqoop action수행시 ooize:launcher의 applicationId를 이용하여 oozie:action의 applicationId및 관련 로그를 찾는 방법	gooper	2023.07.26	10
727	주문 생성 데이터 예시	총관리자	2022.04.30	11
726	주문히스토리 조회	총관리자	2022.04.30	11
725	[bitbucket] 2022년 3월 2일 부터 git 작업시 기존에 사용하던 비빌번호를 사용할 수 없도록 변경되었다.	총관리자	2022.04.30	11
724	[EncryptionZone]User:testuser not allowed to do "DECRYPT_EEK" on 'testkey'	gooper	2023.06.29	11
723	[CDP7.1.7]Encryption Zone내부/외부 간 데이터 이동(mv,cp)및 CTAS, INSERT SQL시 오류(can't be moved into an encryption zone, can't be moved from an encryption zone)	gooper	2023.11.14	11
722	[CDP7.1.7]impala-shell수행시 간헐적으로 "-k requires a valid kerberos ticket but no valid kerberos ticket found." 오류	gooper	2023.11.16	11

쓰기 태그

첫 페이지 1 2 3 4 5 6 7 8 9 10 끝 페이지

A personal place to organize information learned during the development of such Hadoop, Hive, Hbase, Semantic IoT, etc.
We are open to the required minutes. Please send inquiries to gooper@gooper.com.

위로