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

SQL select processors throw EOFException

New Contributor

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)