Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Wed, 5 Dec 2012 08:16:59 +0000 (UTC)
From: "Navis (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <450484702.62686.1354695419645.JavaMail.jiratomcat@arcas>
In-Reply-To: <602353723.61595.1350524523573.JavaMail.jiratomcat@arcas>
Subject: [jira] [Updated] (HIVE-3594) When Group by Partition Column Type is
 Timestamp or STRING Which Format contains "HH:MM:SS", It will occur
 URISyntaxException
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/HIVE-3594?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:all-tabpanel ]

Navis updated HIVE-3594:
------------------------

    Affects Version/s:     (was: 0.9.0)
               Status: Patch Available  (was: Open)
   =20
> When Group by Partition Column Type is Timestamp or STRING Which Format c=
ontains "HH:MM:SS", It will occur URISyntaxException
> -------------------------------------------------------------------------=
----------------------------------------------------
>
>                 Key: HIVE-3594
>                 URL: https://issues.apache.org/jira/browse/HIVE-3594
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Daisy.Yuan
>            Assignee: Navis
>         Attachments: HIVE-3594.D6081.1.patch, HIVE-3594.D6081.2.patch
>
>
> create table test (no int, name string) partitioned by (pts string) row f=
ormat delimited fields terminated by ' ';=20
> load data local inpath '/opt/files/groupbyts1.txt' into table test partit=
ion(pts=3D'12:11:30');
> load data local inpath '/opt/files/groupbyts2.txt' into table test partit=
ion(pts=3D'21:25:12');
> load data local inpath '/opt/files/groupbyts3.txt' into table test partit=
ion(pts=3D'12:11:30');
> load data local inpath '/opt/files/groupbyts4.txt' into table test partit=
ion(pts=3D'21:25:12');
> when I execute =E2=80=9Cselect * from test group by pts;=E2=80=9D, it wil=
l occur as follows exception.
>  at org.apache.hadoop.fs.Path.initialize(Path.java:157)
>         at org.apache.hadoop.fs.Path.<init>(Path.java:135)
>         at org.apache.hadoop.hive.ql.exec.Utilities.getInputSummary(Utili=
ties.java:1667)
>         at org.apache.hadoop.hive.ql.exec.MapRedTask.estimateNumberOfRedu=
cers(MapRedTask.java:432)
>         at org.apache.hadoop.hive.ql.exec.MapRedTask.setNumberOfReducers(=
MapRedTask.java:400)
>         at org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.j=
ava:93)
>         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:135)
>         at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRu=
nner.java:57)
>         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1329)
>         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1121)
>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:954)
>         at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.ex=
ecute(HiveServer.java:198)
>         at org.apache.hadoop.hive.service.ThriftHive$Processor$execute.ge=
tResult(ThriftHive.java:630)
>         at org.apache.hadoop.hive.service.ThriftHive$Processor$execute.ge=
tResult(ThriftHive.java:618)
>         at org.apache.thrift.ProcessFunction.process(ProcessFunction.java=
:32)
>         at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:3=
4)
>         at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(T=
ThreadPoolServer.java:176)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadP=
oolExecutor.java:886)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolE=
xecutor.java:908)
>         at java.lang.Thread.run(Thread.java:662)
> Caused by: java.net.URISyntaxException: Relative path in absolute URI: fa=
ke-path-metadata-only-query-default.test{pts=3D12:11:30%7D
>         at java.net.URI.checkPath(URI.java:1788)
>         at java.net.URI.<init>(URI.java:734)
>         at org.apache.hadoop.fs.Path.initialize(Path.java:154)
>         ... 19 more
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exe=
c.MapRedTask
> When PhysicalOptimizer optimizes GroupByOperator, according to default pa=
rameters "hive.optimize.metadataonly =3D true", MetadataOnlyOptimizer will =
be enabled. The MetadataOnlyOptimizer will change the partition alias desc.=
 The partition alies "hdfs://ip:9000/user/hive/warehouse/test/pts=3D12%3A11=
%3A30" is changed into "=20
> fake-path-metadata-only-query-default.test{pts=3D12:11:30}". When constru=
ct uri through new partition alies, it must occur java.net.URISyntaxExcepti=
on.=20
> =20

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrato=
rs
For more information on JIRA, see: http://www.atlassian.com/software/jira