You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "pengcheng xiong (JIRA)" <ji...@apache.org> on 2014/09/01 02:14:21 UTC

[jira] [Commented] (HIVE-7923) populate stats for test tables

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

pengcheng xiong commented on HIVE-7923:
---------------------------------------

[~ashutoshc]
The src_thrift table is 

aint                	int                 	from deserializer
astring             	string              	from deserializer
lint                	array<int>          	from deserializer
lstring             	array<string>       	from deserializer
lintstring          	array<struct<myint:int,mystring:string,underscore_int:int>>	from deserializer
mstringstring       	map<string,string>  	from deserializer

and when i run 
query: ANALYZE TABLE src_thrift COMPUTE STATISTICS

it threw exception

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.ColumnStatsTask

The main reason is that in ObjectStore.java, validateTableCols function,
table.getSd().getCols() returns null.

The primitive table was there after the data/scripts/q_test_init.sql is executed.

But the primitive table and (dest1,2,3,4 tables) disappeared right before I run any q test. The partition column status of primitive table are there. I could not find the code where primitive table is dropped/deleted. 

> populate stats for test tables
> ------------------------------
>
>                 Key: HIVE-7923
>                 URL: https://issues.apache.org/jira/browse/HIVE-7923
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: pengcheng xiong
>            Assignee: pengcheng xiong
>            Priority: Minor
>         Attachments: HIVE-7923.1.patch
>
>
> Current q_test only generates tables, e.g., src only but does not create status. All the test cases will fail in CBO because CBO depends on the status. 



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