[
https://issues.apache.org/jira/browse/HIVE-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Daisy.Yuan updated HIVE-3594:
-----------------------------
Component/s: (was: Locking)
(was: StorageHandler)
(was: Shims)
(was: SQL)
(was: Statistics)
(was: JDBC)
(was: Indexing)
(was: CLI)
(was: UDF)
(was: Configuration)
(was: Server Infrastructure)
(was: Clients)
(was: Serializers/Deserializers)
(was: Metastore)
Description:
create table test (no int, name string) partitioned by (pts string) row format
delimited fields terminated by ' ';
load data local inpath '/opt/files/groupbyts1.txt' into table test
partition(pts='12:11:30');
load data local inpath '/opt/files/groupbyts2.txt' into table test
partition(pts='21:25:12');
load data local inpath '/opt/files/groupbyts3.txt' into table test
partition(pts='12:11:30');
load data local inpath '/opt/files/groupbyts4.txt' into table test
partition(pts='21:25:12');
when I execute “select * from test group by pts;”, it will 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(Utilities.java:1667)
at
org.apache.hadoop.hive.ql.exec.MapRedTask.estimateNumberOfReducers(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.java:93)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:135)
at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.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.execute(HiveServer.java:198)
at
org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:630)
at
org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:618)
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:176)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.net.URISyntaxException: Relative path in absolute URI:
fake-path-metadata-only-query-default.test{pts=12: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.exec.MapRedTask
When PhysicalOptimizer optimizes GroupByOperator, according to default
parameters "hive.optimize.metadataonly = true", MetadataOnlyOptimizer will be
enabled. The MetadataOnlyOptimizer will change the partition alias desc. The
partition alies
"hdfs://160.165.0.1:9000/user/hive/warehouse/test/pts=12%3A11%3A30" is changed
into "
fake-path-metadata-only-query-default.test{pts=12:11:30}". When construct uri
through new partition alies, it must occur java.net.URISyntaxException.
Affects Version/s: (was: 0.9.1)
(was: 0.10.0)
Fix Version/s: (was: 0.9.1)
(was: 0.10.0)
(was: 0.8.1)
(was: 0.9.0)
(was: 0.8.0)
Summary: Group by Timestamp or STRING which format contains
"HH:MM:SS" occurs URISyntaxException (was: Hive)
> Group by Timestamp or STRING which format contains "HH:MM:SS" occurs
> URISyntaxException
> ---------------------------------------------------------------------------------------
>
> Key: HIVE-3594
> URL: https://issues.apache.org/jira/browse/HIVE-3594
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.9.0
> Reporter: Daisy.Yuan
>
> create table test (no int, name string) partitioned by (pts string) row
> format delimited fields terminated by ' ';
> load data local inpath '/opt/files/groupbyts1.txt' into table test
> partition(pts='12:11:30');
> load data local inpath '/opt/files/groupbyts2.txt' into table test
> partition(pts='21:25:12');
> load data local inpath '/opt/files/groupbyts3.txt' into table test
> partition(pts='12:11:30');
> load data local inpath '/opt/files/groupbyts4.txt' into table test
> partition(pts='21:25:12');
> when I execute “select * from test group by pts;”, it will 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(Utilities.java:1667)
> at
> org.apache.hadoop.hive.ql.exec.MapRedTask.estimateNumberOfReducers(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.java:93)
> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:135)
> at
> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.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.execute(HiveServer.java:198)
> at
> org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:630)
> at
> org.apache.hadoop.hive.service.ThriftHive$Processor$execute.getResult(ThriftHive.java:618)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
> at
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:176)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> Caused by: java.net.URISyntaxException: Relative path in absolute URI:
> fake-path-metadata-only-query-default.test{pts=12: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.exec.MapRedTask
> When PhysicalOptimizer optimizes GroupByOperator, according to default
> parameters "hive.optimize.metadataonly = true", MetadataOnlyOptimizer will be
> enabled. The MetadataOnlyOptimizer will change the partition alias desc. The
> partition alies
> "hdfs://160.165.0.1:9000/user/hive/warehouse/test/pts=12%3A11%3A30" is
> changed into "
> fake-path-metadata-only-query-default.test{pts=12:11:30}". When construct uri
> through new partition alies, it must occur java.net.URISyntaxException.
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
