[
https://issues.apache.org/jira/browse/HIVE-8863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14214651#comment-14214651
]
Prabhu Joseph commented on HIVE-8863:
-------------------------------------
Hi Juan,
I tried to reproduce the issue but it's working fine in hive-0.9.0-bin
version with local mode. Below are the logs.
hive> create table Test (col INT);
OK
Time taken: 0.575 seconds
hive> analyze table Test compute statistics;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
14/11/17 18:53:38 WARN conf.Configuration: fs.default.name is deprecated.
Instead, use fs.defaultFS
WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use
org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
Execution log at:
/tmp/crsadmin/crsadmin_20141117185353_1a052b7c-2f4e-405f-8231-55bf43d9411b.log
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/opt/hadoop-2.0.0_cdh4.3.1/share/hadoop/mapreduce1/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/opt/hadoop-2.0.0_cdh4.3.1/share/hadoop/common/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/opt/HIVE/hive-0.9.0-bin/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
Job running in-process (local Hadoop)
Hadoop job information for null: number of mappers: 0; number of reducers: 0
2014-11-17 18:53:46,365 null map = 0%, reduce = 0%
Ended Job = job_local274860965_0001
Execution completed successfully
Mapred Local Task Succeeded . Convert the Join into MapJoin
Table default.test stats: [num_partitions: 0, num_files: 0, num_rows: 0,
total_size: 0, raw_data_size: 0]
OK
Time taken: 13.004 seconds
hive> drop table Test;
OK
Can you help me providing simple steps to reproduce the issue and How much data
present in Test table , what hive version , configuration details hive-site.xml
of your environment.
Thanks,
Prabhu Joseph
> Cannot drop table with uppercase name after "compute statistics for columns"
> ----------------------------------------------------------------------------
>
> Key: HIVE-8863
> URL: https://issues.apache.org/jira/browse/HIVE-8863
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Reporter: Juan Yu
>
> Create a table with uppercase name Test,
> run "analyze table Test compute statistics for columns col1"
> After this, you cannot drop the table by
> drop table Test;
> Got error:
> NestedThrowablesStackTrace:
> java.sql.BatchUpdateException: Cannot delete or update a parent row: a
> foreign key constraint fails ("hive2"."TAB_COL_STATS", CONSTRAINT
> "TAB_COL_STATS_FK" FOREIGN KEY ("TBL_ID") REFERENCES "TBLS" ("TBL_ID"))
> workaround is to use lowercase table name
> drop table test;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
