[
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)