[ 
https://issues.apache.org/jira/browse/HIVE-19675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16493749#comment-16493749
 ] 

Jesus Camacho Rodriguez commented on HIVE-19675:
------------------------------------------------

[~ashutoshc], I have created HIVE-19731 and uploaded a fix. Root cause is the 
same as with other flaky test: default staging directory.

{noformat}
org.apache.hadoop.util.Shell$ExitCodeException: chmod: cannot access 
‘/tmp/hadoop/mapred/staging/hiveptest985275899/.staging/job_local985275899_0088’:
 No such file or directory

        at org.apache.hadoop.util.Shell.runCommand(Shell.java:1009) 
~[hadoop-common-3.1.0.jar:?]
        at org.apache.hadoop.util.Shell.run(Shell.java:902) 
~[hadoop-common-3.1.0.jar:?]
        at 
org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:1227) 
~[hadoop-common-3.1.0.jar:?]
        at org.apache.hadoop.util.Shell.execCommand(Shell.java:1321) 
~[hadoop-common-3.1.0.jar:?]
        at org.apache.hadoop.util.Shell.execCommand(Shell.java:1303) 
~[hadoop-common-3.1.0.jar:?]
        at 
org.apache.hadoop.fs.RawLocalFileSystem.setPermission(RawLocalFileSystem.java:840)
 ~[hadoop-common-3.1.0.jar:?]
        at 
org.apache.hadoop.fs.ChecksumFileSystem$1.apply(ChecksumFileSystem.java:508) 
~[hadoop-common-3.1.0.jar:?]
        at 
org.apache.hadoop.fs.ChecksumFileSystem$FsOperation.run(ChecksumFileSystem.java:489)
 ~[hadoop-common-3.1.0.jar:?]
        at 
org.apache.hadoop.fs.ChecksumFileSystem.setPermission(ChecksumFileSystem.java:511)
 ~[hadoop-common-3.1.0.jar:?]
        at org.apache.hadoop.fs.FileSystem.mkdirs(FileSystem.java:727) 
~[hadoop-common-3.1.0.jar:?]
        at 
org.apache.hadoop.mapreduce.JobResourceUploader.mkdirs(JobResourceUploader.java:658)
 ~[hadoop-mapreduce-client-core-3.1.0.jar:?]
        at 
org.apache.hadoop.mapreduce.JobResourceUploader.uploadResourcesInternal(JobResourceUploader.java:172)
 ~[hadoop-mapreduce-client-core-3.1.0.jar:?]
        at 
org.apache.hadoop.mapreduce.JobResourceUploader.uploadResources(JobResourceUploader.java:133)
 ~[hadoop-mapreduce-client-core-3.1.0.jar:?]
        at 
org.apache.hadoop.mapreduce.JobSubmitter.copyAndConfigureFiles(JobSubmitter.java:102)
 ~[hadoop-mapreduce-client-core-3.1.0.jar:?]
        at 
org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:197)
 ~[hadoop-mapreduce-client-core-3.1.0.jar:?]
        at org.apache.hadoop.mapreduce.Job$11.run(Job.java:1570) 
~[hadoop-mapreduce-client-core-3.1.0.jar:?]
        at org.apache.hadoop.mapreduce.Job$11.run(Job.java:1567) 
~[hadoop-mapreduce-client-core-3.1.0.jar:?]
        at java.security.AccessController.doPrivileged(Native Method) 
~[?:1.8.0_102]
        at javax.security.auth.Subject.doAs(Subject.java:422) ~[?:1.8.0_102]
        at 
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1682)
 ~[hadoop-common-3.1.0.jar:?]
        at org.apache.hadoop.mapreduce.Job.submit(Job.java:1567) 
~[hadoop-mapreduce-client-core-3.1.0.jar:?]
        at 
org.apache.hadoop.mapreduce.lib.jobcontrol.ControlledJob.submit(ControlledJob.java:336)
 [hadoop-mapreduce-client-core-3.1.0.jar:?]
        at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source) ~[?:?]
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:1.8.0_102]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_102]
        at 
org.apache.pig.backend.hadoop23.PigJobControl.submit(PigJobControl.java:128) 
[pig-0.16.0-h2.jar:?]
        at 
org.apache.pig.backend.hadoop23.PigJobControl.run(PigJobControl.java:194) 
[pig-0.16.0-h2.jar:?]
        at java.lang.Thread.run(Thread.java:745) [?:1.8.0_102]
        at 
org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher$1.run(MapReduceLauncher.java:276)
 [pig-0.16.0-h2.jar:?]
{noformat}

> Cast to timestamps on Druid time column leads to an exception
> -------------------------------------------------------------
>
>                 Key: HIVE-19675
>                 URL: https://issues.apache.org/jira/browse/HIVE-19675
>             Project: Hive
>          Issue Type: Bug
>          Components: Druid integration
>    Affects Versions: 3.0.0
>            Reporter: slim bouguerra
>            Assignee: slim bouguerra
>            Priority: Major
>         Attachments: HIVE-19675.2.patch, HIVE-19675.3.patch, 
> HIVE-19675.4.patch, HIVE-19675.5.patch, HIVE-19675.patch
>
>
> The following query fail due to a formatting issue.
> {code}
> SELECT CAST(`ssb_druid_100`.`__time` AS TIMESTAMP) AS `x_time`,
> . . . . . . . . . . . . . . . .>   SUM(`ssb_druid_100`.`lo_revenue`) AS 
> `sum_lo_revenue_ok`
> . . . . . . . . . . . . . . . .> FROM `druid_ssb`.`ssb_druid_100` 
> `ssb_druid_100`
> . . . . . . . . . . . . . . . .> GROUP BY CAST(`ssb_druid_100`.`__time` AS 
> TIMESTAMP);
> {code} 
> Exception
> {code} 
> Error: java.io.IOException: java.lang.NumberFormatException: For input 
> string: "1991-12-31 19:00:00" (state=,code=0)
> {code}
> [~jcamachorodriguez] maybe this is fixed by your upcoming patches.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to