Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-17274

RowContainer spills for timestamp column throws exception

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.3.0, 3.0.0, 2.4.0
    • Fix Version/s: 3.0.0, 2.4.0
    • Component/s: None
    • Labels:
      None
    • Target Version/s:

      Description

      Path names cannot contain ":" (HADOOP-3257)
      Join key toString() is used as part of filename.
      https://github.com/apache/hive/blob/16bfb9c9405b68a24c7e6c1b13bec00e38bbe213/ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/RowContainer.java#L523

      If join key is timestamp column then this will throw following exception.

      2017-08-05 23:51:33,631 ERROR [main] org.apache.hadoop.hive.ql.exec.persistence.RowContainer: java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: .RowContainer7551143976922371245.[1792453531, 2016-09-02 01:17:43,%202016-09-02%5D.tmp.crc
      java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: .RowContainer7551143976922371245.[1792453531, 2016-09-02 01:17:43,%202016-09-02%5D.tmp.crc
              at org.apache.hadoop.fs.Path.initialize(Path.java:205)
              at org.apache.hadoop.fs.Path.<init>(Path.java:171)
              at org.apache.hadoop.fs.Path.<init>(Path.java:93)
              at org.apache.hadoop.fs.ChecksumFileSystem.getChecksumFile(ChecksumFileSystem.java:94)
              at org.apache.hadoop.fs.ChecksumFileSystem$ChecksumFSOutputSummer.<init>(ChecksumFileSystem.java:404)
              at org.apache.hadoop.fs.ChecksumFileSystem.create(ChecksumFileSystem.java:463)
              at org.apache.hadoop.fs.ChecksumFileSystem.create(ChecksumFileSystem.java:442)
              at org.apache.hadoop.fs.FileSystem.create(FileSystem.java:926)
              at org.apache.hadoop.io.SequenceFile$Writer.<init>(SequenceFile.java:1137)
              at org.apache.hadoop.io.SequenceFile.createWriter(SequenceFile.java:273)
              at org.apache.hadoop.io.SequenceFile.createWriter(SequenceFile.java:530)
              at org.apache.hadoop.hive.ql.exec.Utilities.createSequenceWriter(Utilities.java:1643)
              at org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat.getHiveRecordWriter(HiveSequenceFileOutputFormat.java:64)
              at org.apache.hadoop.hive.ql.io.HiveFileFormatUtils.getRecordWriter(HiveFileFormatUtils.java:243)
              at org.apache.hadoop.hive.ql.exec.persistence.RowContainer.setupWriter(RowContainer.java:538)
              at org.apache.hadoop.hive.ql.exec.persistence.RowContainer.spillBlock(RowContainer.java:299)
              at org.apache.hadoop.hive.ql.exec.persistence.RowContainer.copyToDFSDirecory(RowContainer.java:407)
              at org.apache.hadoop.hive.ql.exec.SkewJoinHandler.endGroup(SkewJoinHandler.java:185)
              at org.apache.hadoop.hive.ql.exec.JoinOperator.endGroup(JoinOperator.java:249)
              at org.apache.hadoop.hive.ql.exec.mr.ExecReducer.reduce(ExecReducer.java:195)
              at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:444)
              at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:392)
              at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168)
              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:1724)
              at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162)
      Caused by: java.net.URISyntaxException: Relative path in absolute URI: .RowContainer7551143976922371245.[1792453531, 2016-09-02 01:17:43,%202016-09-02%5D.tmp.crc
              at java.net.URI.checkPath(URI.java:1823)
              at java.net.URI.<init>(URI.java:745)
              at org.apache.hadoop.fs.Path.initialize(Path.java:202)
              ... 26 more
      

        Attachments

        1. HIVE-17274.1.patch
          5 kB
          Prasanth Jayachandran

          Issue Links

            Activity

              People

              • Assignee:
                prasanth_j Prasanth Jayachandran
                Reporter:
                prasanth_j Prasanth Jayachandran
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: