Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-4297

[beeswax] hue cannot create table from file if hive.default.fileformat has been changed

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 3.7.0
    • Fix Version/s: 3.9.0
    • Component/s: con.hive
    • Labels:
    • Environment:

      Ubuntu 12.04, unmanaged cdh5.4.9

    • Easy:
      Easy

      Description

      After changing hive.default.fileformat to RCFile import wizzard stops working. It's creates table correctly but not loads data into table.
      Hue logs looks like

      error.log

      INFO : Loading data to table iandreyev.test from hdfs://cluster/user/iandreyev/filter_OrderID.csv
      ERROR : Failed with exception Wrong file format. Please check the file's format.
      org.apache.hadoop.hive.ql.metadata.HiveException: Wrong file format. Please check the file's format.
      at org.apache.hadoop.hive.ql.exec.MoveTask.execute(MoveTask.java:302)
      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:1637)
      at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1397)
      at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1182)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1048)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1043)
      at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:144)
      at org.apache.hive.service.cli.operation.SQLOperation.access$100(SQLOperation.java:69)
      at org.apache.hive.service.cli.operation.SQLOperation$1$1.run(SQLOperation.java:196)
      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:1671)
      at org.apache.hive.service.cli.operation.SQLOperation$1.run(SQLOperation.java:208)
      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)

      Mapper fails with format exception.

      http://m02.delos.hdp.yandex.net:8088/taskdetails.jsp?jobid=job_1466771924697_0729&tipid=task_1466771924697_0729_m_000000


      Diagnostic Messages for this Task:
      Error: java.io.IOException: java.lang.reflect.InvocationTargetException
      at org.apache.hadoop.hive.io.HiveIOExceptionHandlerChain.handleRecordReaderCreationException(HiveIOExceptionHandlerChain.java:97)
      at org.apache.hadoop.hive.io.HiveIOExceptionHandlerUtil.handleRecordReaderCreationException(HiveIOExceptionHandlerUtil.java:57)
      at org.apache.hadoop.hive.shims.HadoopShimsSecure$CombineFileRecordReader.initNextRecordReader(HadoopShimsSecure.java:265)
      at org.apache.hadoop.hive.shims.HadoopShimsSecure$CombineFileRecordReader.<init>(HadoopShimsSecure.java:212)
      at org.apache.hadoop.hive.shims.HadoopShimsSecure$CombineFileInputFormatShim.getRecordReader(HadoopShimsSecure.java:332)
      at org.apache.hadoop.hive.ql.io.CombineHiveInputFormat.getRecordReader(CombineHiveInputFormat.java:721)
      at org.apache.hadoop.mapred.MapTask$TrackedRecordReader.<init>(MapTask.java:169)
      at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:432)
      at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
      at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
      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:1671)
      at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
      Caused by: java.lang.reflect.InvocationTargetException
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
      at org.apache.hadoop.hive.shims.HadoopShimsSecure$CombineFileRecordReader.initNextRecordReader(HadoopShimsSecure.java:251)
      ... 11 more
      Caused by: java.io.IOException: hdfs://delos/hive/warehouse/frozen_for_monitoring.db/test_part/2/test_log.txt not a RCFile and has magic of 2 1
      at org.apache.hadoop.hive.ql.io.RCFile$Reader.init(RCFile.java:1473)
      at org.apache.hadoop.hive.ql.io.RCFile$Reader.<init>(RCFile.java:1363)
      at org.apache.hadoop.hive.ql.io.RCFile$Reader.<init>(RCFile.java:1343)
      at org.apache.hadoop.hive.ql.io.RCFileRecordReader.<init>(RCFileRecordReader.java:100)
      at org.apache.hadoop.hive.ql.io.RCFileInputFormat.getRecordReader(RCFileInputFormat.java:57)
      at org.apache.hadoop.hive.ql.io.CombineHiveRecordReader.<init>(CombineHiveRecordReader.java:66)
      ... 16 more

      Looks like that import wizzard does not support any hive.default.fileformat except TextFile.

        Attachments

          Activity

            People

            • Assignee:
              iandreyev Igor Andreyev
              Reporter:
              iandreyev Igor Andreyev
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: