hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brock Noland (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (HIVE-9620) Cannot retrieve column statistics using HMS API if column name contains uppercase characters
Date Sun, 22 Feb 2015 21:28:11 GMT

    [ https://issues.apache.org/jira/browse/HIVE-9620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14332383#comment-14332383
] 

Brock Noland edited comment on HIVE-9620 at 2/22/15 9:27 PM:
-------------------------------------------------------------

{noformat}
Error retrieving statistics via jdo
MetaException(message:Column columnNumber1 doesn't exist.)
	at org.apache.hadoop.hive.metastore.ObjectStore.validateTableCols(ObjectStore.java:5741)
	at org.apache.hadoop.hive.metastore.ObjectStore.getMTableColumnStatistics(ObjectStore.java:5692)
	at org.apache.hadoop.hive.metastore.ObjectStore.access$1000(ObjectStore.java:147)
	at org.apache.hadoop.hive.metastore.ObjectStore$5.getJdoResult(ObjectStore.java:5763)
	at org.apache.hadoop.hive.metastore.ObjectStore$5.getJdoResult(ObjectStore.java:5755)
	at org.apache.hadoop.hive.metastore.ObjectStore$GetHelper.run(ObjectStore.java:2223)
	at org.apache.hadoop.hive.metastore.ObjectStore.getTableColumnStatisticsInternal(ObjectStore.java:5755)
{noformat}


was (Author: jyu@cloudera.com):
REMOVED

> Cannot retrieve column statistics using HMS API if column name contains uppercase characters

> ---------------------------------------------------------------------------------------------
>
>                 Key: HIVE-9620
>                 URL: https://issues.apache.org/jira/browse/HIVE-9620
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore, Statistics
>    Affects Versions: 0.13.1
>            Reporter: Juan Yu
>            Assignee: Chaoyu Tang
>
> The issue only happens on avro table,
> {code}
> CREATE TABLE t2_avro (
> columnNumber1 int,
> columnNumber2 string )
> PARTITIONED BY (p1 string)
> ROW FORMAT SERDE 
>   'org.apache.hadoop.hive.serde2.avro.AvroSerDe' 
> STORED AS INPUTFORMAT 
>   'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' 
> OUTPUTFORMAT 
>   'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
> TBLPROPERTIES(
> 'avro.schema.literal'='{
> "namespace": "testing.hive.avro.serde",
> "name": "test",
> "type": "record",
> "fields": [
> { "name":"columnNumber1", "type":"int" },
> { "name":"columnNumber2", "type":"string" }
> ]}');
> {code}
> I don't have latest hive so I am not sure if this is already fixed in trunk.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message