Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

SQL select processors throw EOFException

Highlighted

SQL select processors throw EOFException

I am trying to read a table using phoenix driver.

I tried ExecuteSQL, GenerateTableFetch or QueryDatabaseTable Processors all return the following exception,

com.google.common.util.concurrent.UncheckedExecutionException: java.lang.RuntimeException: java.io.EOFException

2018-01-17 11:07:39,209 WARN [Timer-Driven Process Thread-1] o.a.n.c.t.ContinuallyRunProcessorTask 

com.google.common.util.concurrent.UncheckedExecutionException: java.lang.RuntimeException: java.io.EOFException

	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2256)

	at com.google.common.cache.LocalCache.get(LocalCache.java:3985)

	at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3989)

	at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4873)

	at org.apache.phoenix.query.TableStatsCache.get(TableStatsCache.java:134)

	at org.apache.phoenix.query.ConnectionQueryServicesImpl.getTableStats(ConnectionQueryServicesImpl.java:2545)

	at org.apache.phoenix.iterate.BaseResultIterators.<init>(BaseResultIterators.java:151)

	at org.apache.phoenix.iterate.ParallelIterators.<init>(ParallelIterators.java:55)

	at org.apache.phoenix.iterate.ParallelIterators.<init>(ParallelIterators.java:61)

	at org.apache.phoenix.execute.AggregatePlan.newIterator(AggregatePlan.java:185)

	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:245)

	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:161)

	at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:253)

	at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:243)

	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)

	at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:242)

	at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:1231)

	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)

	at org.apache.nifi.processors.standard.GenerateTableFetch.onTrigger(GenerateTableFetch.java:253)

	at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1120)

	at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:147)

	at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47)

	at org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:132)

	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)

	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)

	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)

	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

	at java.lang.Thread.run(Thread.java:745)

Caused by: java.lang.RuntimeException: java.io.EOFException

	at org.apache.phoenix.schema.stats.GuidePostsInfo.deserializeGuidePostsInfo(GuidePostsInfo.java:172)

	at org.apache.phoenix.schema.stats.StatisticsUtil.readStatistics(StatisticsUtil.java:134)

	at org.apache.phoenix.query.TableStatsCache$StatsLoader.load(TableStatsCache.java:91)

	at org.apache.phoenix.query.TableStatsCache$StatsLoader.load(TableStatsCache.java:84)

	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3584)

	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2372)

	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2335)

	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2250)

	... 30 common frames omitted

Caused by: java.io.EOFException: null

	at java.io.DataInputStream.readFully(DataInputStream.java:197)

	at java.io.DataInputStream.readLong(DataInputStream.java:416)

	at org.apache.phoenix.schema.stats.GuidePostsInfo.deserializeGuidePostsInfo(GuidePostsInfo.java:157)


Don't have an account?
Coming from Hortonworks? Activate your account here