You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "wd (JIRA)" <ji...@apache.org> on 2012/05/31 11:36:23 UTC
[jira] [Created] (HIVE-3069) Drop partition problem
wd created HIVE-3069:
------------------------
Summary: Drop partition problem
Key: HIVE-3069
URL: https://issues.apache.org/jira/browse/HIVE-3069
Project: Hive
Issue Type: Bug
Components: SQL
Affects Versions: 0.9.0
Environment: hive 0.9 bin, and postgres as metadata.
Reporter: wd
Setup a new hive 0.9 client, follow this steps
hive> create table t1(a int) partitioned by ( dt int );
OK
Time taken: 0.097 seconds
hive> load data local inpath '/tmp/t' into table t1 partition (dt=111);
Copying data from file:/tmp/t
Copying file: file:/tmp/t
Loading data to table default.t1 partition (dt=111)
OK
Time taken: 0.375 seconds
hive> show partitions t1;
OK
dt=111
Time taken: 0.108 seconds
hive> alter table t1 drop partition ( dt=111 );
FAILED: Error in semantic analysis: Partition not found dt = 111
hive> alter table t1 drop partition ( dt='111' );
FAILED: Error in semantic analysis: Partition not found dt = '111'
after change partition column type to string, it's worked.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3069) Drop partition problem
Posted by "wd (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13287202#comment-13287202 ]
wd commented on HIVE-3069:
--------------------------
Yes。 I've searched before posting, but didn't see it. Sorry for this post.
> Drop partition problem
> ----------------------
>
> Key: HIVE-3069
> URL: https://issues.apache.org/jira/browse/HIVE-3069
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 0.9.0
> Environment: hive 0.9 bin, and postgres as metadata.
> Reporter: wd
>
> Setup a new hive 0.9 client, follow this steps
> hive> create table t1(a int) partitioned by ( dt int );
> OK
> Time taken: 0.097 seconds
> hive> load data local inpath '/tmp/t' into table t1 partition (dt=111);
> Copying data from file:/tmp/t
> Copying file: file:/tmp/t
> Loading data to table default.t1 partition (dt=111)
> OK
> Time taken: 0.375 seconds
> hive> show partitions t1;
> OK
> dt=111
> Time taken: 0.108 seconds
> hive> alter table t1 drop partition ( dt=111 );
> FAILED: Error in semantic analysis: Partition not found dt = 111
> hive> alter table t1 drop partition ( dt='111' );
> FAILED: Error in semantic analysis: Partition not found dt = '111'
> after change partition column type to string, it's worked.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3069) Drop partition problem
Posted by "Ashutosh Chauhan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13286898#comment-13286898 ]
Ashutosh Chauhan commented on HIVE-3069:
----------------------------------------
Dupe of HIVE-3063 ?
> Drop partition problem
> ----------------------
>
> Key: HIVE-3069
> URL: https://issues.apache.org/jira/browse/HIVE-3069
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 0.9.0
> Environment: hive 0.9 bin, and postgres as metadata.
> Reporter: wd
>
> Setup a new hive 0.9 client, follow this steps
> hive> create table t1(a int) partitioned by ( dt int );
> OK
> Time taken: 0.097 seconds
> hive> load data local inpath '/tmp/t' into table t1 partition (dt=111);
> Copying data from file:/tmp/t
> Copying file: file:/tmp/t
> Loading data to table default.t1 partition (dt=111)
> OK
> Time taken: 0.375 seconds
> hive> show partitions t1;
> OK
> dt=111
> Time taken: 0.108 seconds
> hive> alter table t1 drop partition ( dt=111 );
> FAILED: Error in semantic analysis: Partition not found dt = 111
> hive> alter table t1 drop partition ( dt='111' );
> FAILED: Error in semantic analysis: Partition not found dt = '111'
> after change partition column type to string, it's worked.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (HIVE-3069) Drop partition problem
Posted by "Ashutosh Chauhan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Chauhan resolved HIVE-3069.
------------------------------------
Resolution: Duplicate
Fix Version/s: 0.10.0
> Drop partition problem
> ----------------------
>
> Key: HIVE-3069
> URL: https://issues.apache.org/jira/browse/HIVE-3069
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 0.9.0
> Environment: hive 0.9 bin, and postgres as metadata.
> Reporter: wd
> Fix For: 0.10.0
>
>
> Setup a new hive 0.9 client, follow this steps
> hive> create table t1(a int) partitioned by ( dt int );
> OK
> Time taken: 0.097 seconds
> hive> load data local inpath '/tmp/t' into table t1 partition (dt=111);
> Copying data from file:/tmp/t
> Copying file: file:/tmp/t
> Loading data to table default.t1 partition (dt=111)
> OK
> Time taken: 0.375 seconds
> hive> show partitions t1;
> OK
> dt=111
> Time taken: 0.108 seconds
> hive> alter table t1 drop partition ( dt=111 );
> FAILED: Error in semantic analysis: Partition not found dt = 111
> hive> alter table t1 drop partition ( dt='111' );
> FAILED: Error in semantic analysis: Partition not found dt = '111'
> after change partition column type to string, it's worked.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira