Need help to solved below issue:
*I am using :*
hive 1.2.1
drilll 1.6.0
*What i am doing : *
1. table is created in hive and data stored as parquet (this table is
partitioned on column "log_date". Data size is around 15GB (parquet-Gzip)
2. And used hive storage plugin in drill to read the data.
/******************************************************* hive shell
************************************************************************/
hive> select sessionid from hive_daily where log_date = '2016-04-23' limit
10;
OK
sessionid
64B06F4BF0260082F3A2D203E29C1
D0AC39A72265D1B946F6AE693D1D1
F0521251EE19C63AF63CF50919113
C7E83A9FFEEA8143B5666D0C27ED4
EADA5EADFFD17D6EE3B65BF8F26C1
3A33C47190942D4A9C5EAEC5D5735
C7E83A9FF9148143B5666D0C27ED4
1B88F36623F9BC08B085E8FC43931
A001DA690262B097C45540D184C41
59576D244F6FFA5474F1606B09413
Time taken: 0.122 seconds, Fetched: 10 row(s)
/******************************************************* drill shell
************************************************************************/
0: jdbc:drill:> select sessionid from hive.hive_daily where log_date =
'2016-04-23' limit 10;
Error: SYSTEM ERROR: NullPointerException
Fragment 1:28
[Error Id: a1bf4e7c-303b-424b-8f00-479f696601ca on namenode:31010]
(org.apache.drill.common.exceptions.ExecutionSetupException)
java.lang.reflect.UndeclaredThrowableException
org.apache.drill.common.exceptions.ExecutionSetupException.fromThrowable():30
org.apache.drill.exec.store.hive.HiveRecordReader.setup():275
org.apache.drill.exec.physical.impl.ScanBatch.<init>():108
org.apache.drill.exec.store.hive.HiveDrillNativeScanBatchCreator.getBatch():151
org.apache.drill.exec.store.hive.HiveDrillNativeScanBatchCreator.getBatch():58
org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():146
org.apache.drill.exec.physical.impl.ImplCreator.getChildren():169
org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():126
org.apache.drill.exec.physical.impl.ImplCreator.getChildren():169
org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():126
org.apache.drill.exec.physical.impl.ImplCreator.getChildren():169
org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():126
org.apache.drill.exec.physical.impl.ImplCreator.getChildren():169
org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():126
org.apache.drill.exec.physical.impl.ImplCreator.getChildren():169
org.apache.drill.exec.physical.impl.ImplCreator.getRootExec():100
org.apache.drill.exec.physical.impl.ImplCreator.getExec():78
org.apache.drill.exec.work.fragment.FragmentExecutor.run():231
org.apache.drill.common.SelfCleaningRunnable.run():38
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745
Caused By (java.util.concurrent.ExecutionException)
java.lang.reflect.UndeclaredThrowableException
java.util.concurrent.FutureTask.report():122
java.util.concurrent.FutureTask.get():192
org.apache.drill.exec.store.hive.HiveRecordReader.setup():268
org.apache.drill.exec.physical.impl.ScanBatch.<init>():108
org.apache.drill.exec.store.hive.HiveDrillNativeScanBatchCreator.getBatch():151
org.apache.drill.exec.store.hive.HiveDrillNativeScanBatchCreator.getBatch():58
org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():146
org.apache.drill.exec.physical.impl.ImplCreator.getChildren():169
org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():126
org.apache.drill.exec.physical.impl.ImplCreator.getChildren():169
org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():126
org.apache.drill.exec.physical.impl.ImplCreator.getChildren():169
org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():126
org.apache.drill.exec.physical.impl.ImplCreator.getChildren():169
org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch():126
org.apache.drill.exec.physical.impl.ImplCreator.getChildren():169
org.apache.drill.exec.physical.impl.ImplCreator.getRootExec():100
org.apache.drill.exec.physical.impl.ImplCreator.getExec():78
org.apache.drill.exec.work.fragment.FragmentExecutor.run():231
org.apache.drill.common.SelfCleaningRunnable.run():38
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745
Caused By (java.lang.reflect.UndeclaredThrowableException) null
org.apache.hadoop.security.UserGroupInformation.doAs():1672
org.apache.drill.exec.ops.OperatorContextImpl$1.call():156
java.util.concurrent.FutureTask.run():266
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745
Caused By (org.apache.drill.common.exceptions.ExecutionSetupException)
Failure while initializing HiveRecordReader: null
org.apache.drill.exec.store.hive.HiveRecordReader.init():221
org.apache.drill.exec.store.hive.HiveRecordReader.access$100():74
org.apache.drill.exec.store.hive.HiveRecordReader$1.call():261
org.apache.drill.exec.store.hive.HiveRecordReader$1.call():258
org.apache.drill.exec.ops.OperatorContextImpl$1$1.run():159
java.security.AccessController.doPrivileged():-2
javax.security.auth.Subject.doAs():422
org.apache.hadoop.security.UserGroupInformation.doAs():1657
org.apache.drill.exec.ops.OperatorContextImpl$1.call():156
java.util.concurrent.FutureTask.run():266
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745
Caused By (java.lang.NullPointerException) null
org.apache.drill.exec.store.hive.HiveRecordReader.init():200
org.apache.drill.exec.store.hive.HiveRecordReader.access$100():74
org.apache.drill.exec.store.hive.HiveRecordReader$1.call():261
org.apache.drill.exec.store.hive.HiveRecordReader$1.call():258
org.apache.drill.exec.ops.OperatorContextImpl$1$1.run():159
java.security.AccessController.doPrivileged():-2
javax.security.auth.Subject.doAs():422
org.apache.hadoop.security.UserGroupInformation.doAs():1657
org.apache.drill.exec.ops.OperatorContextImpl$1.call():156
java.util.concurrent.FutureTask.run():266
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745 (state=,code=0)
/*******************************************************************************************************************************/
