Uploaded image for project: 'CDAP'
  1. CDAP
  2. CDAP-11660

Group By and Order By queries in Explore are failing on Standalone

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.1.1
    • Fix Version/s: 4.2.0
    • Component/s: Explore
    • Labels:
      None
    • Rank:
      1|i002cv:

      Description

      SELECT * works, but SELECT * ... ORDER BY or SELECT * ... GROUP BY fails.

      There is an NPE as below in cdap-debug.log. Perhaps related to the recent move to Hadoop 2.8

      java.lang.NullPointerException
          at java.io.File.<init>(File.java:277)
          at org.apache.hadoop.mapred.LocalDistributedCacheManagerWithFix.setup(LocalDistributedCacheManagerWithFix.java:93)
          at org.apache.hadoop.mapred.LocalJobRunnerWithFix$Job.<init>(LocalJobRunnerWithFix.java:166)
          at org.apache.hadoop.mapred.LocalJobRunnerWithFix.submitJob(LocalJobRunnerWithFix.java:735)
          at org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:242)
          at org.apache.hadoop.mapreduce.Job$11.run(Job.java:1341)
          at org.apache.hadoop.mapreduce.Job$11.run(Job.java:1338)
          at java.security.AccessController.doPrivileged(Native Method)
          at javax.security.auth.Subject.doAs(Subject.java:422)
          at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1807)
          at org.apache.hadoop.mapreduce.Job.submit(Job.java:1338)
          at org.apache.hadoop.mapred.JobClient$1.run(JobClient.java:575)
          at org.apache.hadoop.mapred.JobClient$1.run(JobClient.java:570)
          at java.security.AccessController.doPrivileged(Native Method)
          at javax.security.auth.Subject.doAs(Subject.java:422)
          at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1807)
          at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:570)
          at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:561)
          at org.apache.hadoop.hive.ql.exec.mr.ExecDriver.execute(ExecDriver.java:431)
          at org.apache.hadoop.hive.ql.exec.mr.MapRedTask.execute(MapRedTask.java:137)
          at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:160)
          at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:88)
          at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1653)
          at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1412)
          at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1195)
          at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1059)
          at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1054)
          at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:154)
          at org.apache.hive.service.cli.operation.SQLOperation.access$100(SQLOperation.java:71)
          at org.apache.hive.service.cli.operation.SQLOperation$1$1.run(SQLOperation.java:206)
          at java.security.AccessController.doPrivileged(Native Method)
          at javax.security.auth.Subject.doAs(Subject.java:422)
          at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1807)
          at org.apache.hive.service.cli.operation.SQLOperation$1.run(SQLOperation.java:218)
          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
          at java.util.concurrent.FutureTask.run(FutureTask.java:266)
          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)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vinisha Vinisha Shah
                Reporter:
                bhooshan Bhooshan Mogal
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: